XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix B: Administrative Tables
XYPRO Technology Corporation 176 Proprietary and Confidential
B11: BASE24 Parameter Table
As of release 1.90 of XYGATE Merged Audit this table will not be used. The data will
be stored in the PARAMS table. When upgrading from a prior release, the data in the
individual product tables will be converted and placed in the PARAMS table.
CREATE TABLE =XMA_b24mvPARAMSTBL
( RECORDPARAMSKEY TIMESTAMP DEFAULT CURRENT NOT NULL
,SERVERCLASSNAME CHAR(15) NO DEFAULT NOT NULL
-- refers to =XMA_b24mvTBL
,PARAMNAME VARCHAR(50) NO DEFAULT NOT NULL
-- name of the parameter
,PARAMVALUE VARCHAR(256) NO DEFAULT NOT NULL
-- value of the parameter
,PRIMARY KEY RECORDPARAMSKEY
)
CATALOG =XMA_CAT
ORGANIZATION K
SIMILARITY CHECK ENABLE
AUDIT;
B12: BASE24 State Tables
The BASE24 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_b24mvASTATETBL
( 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_b24mvTBL
,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