XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix B: Administrative Tables
XYPRO Technology Corporation 169 Proprietary and Confidential
B2: XYGATE MOVER State Tables
The XYGATE 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.
XYGATE MOVER State Table =XMA_XYMVSTATETBL
CREATE TABLE =XMA_XYMVSTATETBL
(RECORDSTATEKEY TIMESTAMP DEFAULT CURRENT NOT NULL
, XYGATENODE CHAR (8) NO DEFAULT NOT NULL
, XYGATEVOLUME CHAR (8) NO DEFAULT NOT NULL
, XYGATESUBVOLUME CHAR (8) NO DEFAULT NOT NULL
, XYGATEPRODUCT CHAR (3) NO DEFAULT NOT NULL
, ServerclassNAME CHAR (15) NO DEFAULT NOT NULL
-- Refers to =XMA_XYMVTBL
, AUDITFILECT LARGEINT SIGNED NO DEFAULT NOT NULL
-- Equivalent to a long long (64 bit timestamp)
-- Creation timestamp of the audit trail enscribe 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 enscribe file
, LASTRECORD_ADDRESS LARGEINT SIGNED NO DEFAULT NOT NULL
-- Equivalent to a long long (64 bit address)
-- Address 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 enscribe file
-- LCT of the last record processed in the file
, FILEBEGIN_LCT CHAR (26) NO DEFAULT NOT NULL
-- yyyy-mm-dd hh:nn:ss.msssss as picked from enscribe 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 enscribe 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 enscribe file
, CURRENTFILESTATUS VARCHAR (256) NO DEFAULT NOT NULL
-- What is the server doing to this file
, PRIMARY KEY RECORDSTATEKEY
)