Audit Trail File Sizes (ttaud3135m000)

Use this session to determine the size of the audit trail files ( sequence files).

The system can store a maximum of 999 sequence files for each table/company combination. When you exceed this number, you must purge the existing sequence files with the Purge Audit Files (ttaad4261m000) session.

To define a good file size, keep in mind the following considerations:

  • The audit data is stored per transaction. If a single transaction generates too much data to be stored in a sequence file, the transaction is aborted. Therefore, the sequence file size must enable you to store transactions that involve many changes in a table, for example, an update of all fields in several columns.
  • If the file size is too small, you reach the number of 999 too quick, and you may be required to purge files you still want to keep.
  • If the file size is too big, you are unable to delete a part of the audit trail, because you cannot purge the current sequence file.

Related topics

 

All Companies
If this check box is selected, the sequence file size applies for all companies in the selected package(s), module(s), and table(s).
All Modules
If this check box is selected, the sequence file size applies for all modules in the selected package.
Note

If this check box is selected, the All Tables check box is also automatically selected and cannot be cleared.

All Packages
If this check box is selected, the sequence file size applies for all packages, modules, tables, and companies.
Note
  • Only one record can have this check box selected.
  • If this check box is selected, other records define exceptions.
All Tables
If this check box is selected, the sequence file size applies for all tables in the selected module.
Company Group
The company group you defined in the Company Groups (ttaud3140m000) session.
Module
A part of a package consisting of a number of related software components, such as sessions, tables, program scripts, reports, forms and menus. For example, the General Ledger module in Financials.

A module code consists of three characters. For example, the General Ledger has the code "gld".

Package
A set of related modules that implements a complete part of the functionality, for example, Enterprise Planning, Financials, or Warehousing. Packages are designed to function as independent as possible, to enable a customer to implement only particular packages.

A package code consists of two characters. For example, tt is the code of the Tools package.

Each package has a unique version structure, the VRC structure.

Size
The number that, together with the unit you select, defines the sequence file size.
Size
The unit in which the size is measured, which is either Bytes, Kilobytes or Megabytes.
Table
A data structure that is used to store data that consists of a list of records, each entry being identified by a unique key and containing a set of related values. A table contains a number of table fields that belong to a specific domain.

A table code consists of a package code, module code, and three digits.

Example

Table: tc mcs010 Countries

Table fields
CodeLabelLengthData Type
cctyCountry3String
dscaDescription30Multibyte String
meecEU Member State5Enumerated
...

 

 

Create Runtime Audit Definitions
Click to zoom to the Create Runtime Audit Definitions (ttaud3200s000) session.
Print Audit Trail File Sizes
Click to zoom to the Print Audit Trail File Sizes (ttaud3435m000) session.