An audit file is created by DMSII and contains the raw format of changes made to the DMSII database by update programs. Audit file records contain the deletes, adds, and modifies that were made to the various structures. It can contain, for example, hours, days, or weeks worth of information.

DATABridge uses the audit file for the raw data of each database change to exactly replicate the primary database. DATABridge records the audit location (AFN, ABSN, SEG, IDX) between runs, so it can restart without losing any records.

If you have DATABridge Plus or you set the DBEngine Read Active Audit option, DATABridge can access the current audit file. If you do not have DATABridge Plus, and you do not set Read Active Audit = true in the DBEngine parameter file, DATABridge can access audit information up to and including the current audit file minus one. Additionally, the audit file contains the update level at the time the audit file was created. The update level in the audit file and the update level in the DESCRIPTION file used by DATABridge must match before DATABridge will update a replicated database.

When an audit file is closed, DMSII creates the next one in the series. Audit files are closed for several reasons, including the following:

• An operator closes the audit file with the mixnumberSM AUDIT CLOSE command
• The audit file reaches the file size set in its DASDL
• There is an I/O error on the audit file
• There is not enough disk space for this audit file
• The database update level changes due to database definition changes
• A DATABridge accessory closed the file in preparation for the fixup phase after extracting records from a DMSII database
• The current audit file could not be found
• A file reorganization was executed to modify the DMSII structure

The Audit Trail

The audit trail consists of the audit files named as follows:

databasename/AUDITnnnn

where databasename is the name of the DMSII database, AUDIT is a literal, and nnnn is the AFN, a sequential number between 1 and 9999. For example, if you have a database named BANKDB, an audit file would be named similarly to the following:

BANKDB/AUDIT7714