XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix B: Administrative Tables
XYPRO Technology Corporation 177 Proprietary and Confidential
-- 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(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
)
CATALOG =XMA_CAT
ORGANIZATION K
SIMILARITY CHECK ENABLE
AUDIT;
CREATE TABLE =XMA_b24mvASTATEAUXTBL
( 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_b24mvSTATETBL
,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
,RECORDBEGINADDR LARGEINT SIGNED NO DEFAULT NOT NULL
-- equivalent to a long long (64 bit address)
-- begin address of record range
,RECORDENDADDR LARGEINT SIGNED NO DEFAULT NOT NULL
-- equivalent to a long long (64 bit address)
-- end address of record range
,RECORDBEGIN_LCT CHAR(26) NO DEFAULT NOT NULL
-- LCT of record corresponding to RECORDBEGINADDR
,RECORDEND_LCT CHAR(26) NO DEFAULT NOT NULL
-- LCT of record corresponding to RECORDENDADDR
,PRIMARY KEY RECORDSTATEKEY
)
CATALOG =XMA_CAT
ORGANIZATION K
SIMILARITY CHECK ENABLE
AUDIT;