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.
- 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 Warehouse Management. 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.
- File 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
Code Label Length Data Type ccty Country 3 String dsca Description 30 Multibyte String meec EU Member State 5 Enumerated ...