XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix B: Administrative Tables
XYPRO Technology Corporation 174 Proprietary and Confidential
B9: SAFEGUARD MOVER State Tables
The Safeguard MOVERs utilize the two tables below to track the current audit file and
the date of the last record within the file that has been processed. This prevents the
creation of duplicates. It also allows the MOVERs to “catch-up” if they have to be
stopped and restarted.
SAFEGUARD State Table =XMA_SFGMVSTATETBL
CREATE TABLE =XMA_SFGMVSTATETBL
(RECORDSTATEKEY TIMESTAMP DEFAULT CURRENT NOT NULL
, SFGNODE CHAR (8) NO DEFAULT NOT NULL
, ServerclassNAME CHAR (15) NO DEFAULT NOT NULL
-- Refers to =XMA_SFGMVTBL
, AUDITFILECT LARGEINT SIGNED NO DEFAULT NOT NULL
-- Equivalent to a long long (64 bit timestamp)
-- Creation timestamp of the audit trail file
, AUDITFILEMT LARGEINT SIGNED NO DEFAULT NOT NULL
-- Equivalent to a long long (48 bit converted to 64 bit timestamp)
-- modification timestamp of the audit trail file
, LASTRECORDGMTTSTMP TIMESTAMP DEFAULT CURRENT NOT NULL
-- GMT Tstmp of last record processed in the file
, LASTRECORD_LCT CHAR (26) NO DEFAULT NOT NULL
-- yyyy-mm-dd hh:nn:ss.msssss as picked from audit trail file
-- LCT of the last record processed in the file
, FILEBEGIN_GMT CHAR (26) NO DEFAULT NOT NULL
-- GMT of the first record in the file
-- uniquely determines a file for a node
, FILEBEGIN_LCT CHAR (26) NO DEFAULT NOT NULL
-- yyyy-mm-dd hh:nn:ss.msssss as picked from audit trail file
-- LCT of the first record in the file
, FILEEND_LCT CHAR (26) NO DEFAULT NOT NULL
-- yyyy-mm-dd hh:nn:ss.msssss as picked from audit trail file
-- LCT of the last record in the file
--
NOTE: if FILEEND_LCT <> 0 then it implies the file has been
-- fully processed and should not be processed again
, RECORDSPROCESSED LARGEINT SIGNED NO DEFAULT NOT NULL
-- Number of records processed from this file
, SESSIONTBLINSCOUNT LARGEINT SIGNED NO DEFAULT NOT NULL
-- Number of session table inserts done while processing records from
--this file
, AUDITTBLINSCOUNT LARGEINT SIGNED NO DEFAULT NOT NULL
-- Number of audit table inserts done while processing records from
--this file
, AUDITFILENAME VARCHAR (40) NO DEFAULT NOT NULL
-- Name of the audit trail file
, CURRENTFILESTATUS VARCHAR (256) NO DEFAULT NOT NULL
-- What is the server doing to this file
, PRIMARY KEY RECORDSTATEKEY
)