Span Accessory Tracking

Tracking is the process of extracting only completed changes from a DMSII audit file and then updating the secondary database with those changes. To accomplish the tracking of changes from the host DMSII database to a secondary database, the Span Accessory uses the audit files created by DMSII. The audit files contain information about which records have been modified, deleted, or added.

You can determine how “up-to-date” your secondary database is by how often you close the DMSII audit files and run the Span Accessory. For example, you can close the audit file every hour, every day, or even every week, depending on how crucial current information is. If you do not explicitly close the audit file, the Accessroutines close it when the audit file reaches the size specified in the DASDL. If you use the Engine parameter setting READ ACTIVE AUDIT = TRUE, the Span Accessory can process all of the audit trail up to the last quiet point. Since a new audit file is opened as soon as an old one is closed, you can take the closed audit file and immediately begin the updating on the secondary database.

For information on automating this process, see Automating Span Accessory Processing. For information on controlling when audit files close, see Chapter 11, “DATABridge Utilities."

What is crucial in tracking is that the secondary database know its exact position in the audit trail. Therefore, the following is a list of issues you must be aware of when updating the secondary database:

  • Audit position
  • Replicating additional data sets
  • DMSII rollback or rebuilding
  • DMSII reorganizations

Audit Position

Each secondary database must record the current audit position for each data set. (DATABridge provides this information at the end of each transaction group.) If the secondary database is rolled back or reloaded from a dump, the audit position of the secondary database can be rolled back to a audit position prior to the database rollback or reload. Tracking then starts at the rolled back audit position so that the data records on the secondary database are in sync with the actual data records.

Replicating Additional Data Sets

If you want to replicate data sets that you did not include in previous runs of the Span Accessory, you must uncomment the appropriate entry in the Span Accessory parameter file so that Span Accessory replicates the added structures as well.

DMSII Rollback or Rebuilding

Before you perform a rollback or reload, see Normal Recovery from a Rollback.

DMSII Reorganizations

Before you perform a reorganization, see DMSII Reorganizations.