XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix B: Administrative Tables
XYPRO Technology Corporation 179 Proprietary and Confidential
B16: HLR State Tables
The HLR 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.
CREATE TABLE =XMA_hlrMVSTATETBL
( 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_hlrmvTBL
,AUDITFILECT LARGEINT SIGNED NO DEFAULT NOT NULL
-- equivalent to a long long (64 bit timestamp)
-- Creation timestamp of the audit trail
,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
,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 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 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 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
,AUDITTBLINSCOUNT LARGEINT SIGNED NO DEFAULT NOT NULL
-- number of audit table inserts done while processing records from the
,AUDITFILENAME VARCHAR(1024) 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
)
CATALOG =XMA_CAT
ORGANIZATION K
SIMILARITY CHECK ENABLE
AUDIT;
CREATE TABLE =XMA_hlrmvSTATEAUXTBL
( 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_hlrmvSTATETBL