Check Audit Files Integrity (ttaad4460m000)

Use this session to check, for one or more tables, whether the various sequence files are consistent with the corresponding audit-info file.

Audit information of a table is stored in:

  • One or more sequence files. These files contain the information that is logged by the audit server, e.g. the properties of new records, or the old and the new properties of existing records that were changed.
  • One information file (audit-info file) that contains the technical information (metadata) for the sequence files.

Each audit sequence file contains a sequence header at start of it. This header contains:

  • Sequence file information, such as
    • the file's sequence number
    • creation date and time
    • termination date and time
    • termination status: indicates whether the file was terminated, and if so, for what reason. For example: "UNTERMINATED" (the sequence file is not terminated) or "MAX_SIZE" (the sequence file was terminated because the sequence file reached the maximum size).
  • audit dd information for each field that is audited, such as the field's name, data type, depth (for array fields only) and length. When the audit dd changes (for example, the number of audited columns in a table has changed, or the order of the columns in the table's primary key has changed), the audit server terminates the currently active sequence file (Termination Status = "DD CHANGED ") and switches to a new sequence file with a new audit dd. Refer to the Infor Enterprise Server Technical Manual for more details.

The audit-info file contains copies of the sequence headers for all sequence files generated.

This session prints a report, which displays for each table whether the sequence header information in the sequence files and the sequence header information in the audit-info file matches. In case of a discrepancy, Tools prints the information from both files so that you can find the exact mismatch.

Note: Running this session is especially useful when the audit dd for one or more audited tables has changed.

To check audit files, enter the desired range of tables and companies and click Check.