DATASETS Client Control Table

The DATASETS client control table tracks the state of data sets. State information consists of the ds_mode value and the DMSII audit file location from which subsequent updates should be processed. The audit file location includes the AFN, the ABSN, the segment and index in the audit files, and the audit file time stamp. These values, which are collectively referred to as the stateinfo, are stored in the audit_filenum, audit_block, audit_seg, audit_inx, and audit_time6 of the DATASETS client control table. The column audit_ts contains a date/time value, which corresponds to the audit_time6 data, which is binary and represents a DMSII TIME(6) value. This last column is not part of the stateinfo; it's there because knowing the audit time stamp value can sometimes be very useful.

Each subsequent time you run dbutility process, the DATABridge Client passes the stateinfo and the mode of each data set to the DATABridge Engine. The DATABridge Engine gathers data starting from this audit location and requests only updates to the DMSII database. Periodically, the DATABridge Client writes an updated DMSII audit file location to the DATASETS client control table. At the end of the process command, the location of the last quiet point in the audit trail is saved in the DATASETS client control table. This is the starting point for the next Client run (process command).