XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix B: Administrative Tables
XYPRO Technology Corporation 175 Proprietary and Confidential
SAFEGUARD State Auxiliary Table =XMA_SFGMVSTATEAUXTBL
CREATE TABLE =XMA_SFGMVSTATEAUXTBL
( RECORDSTATEKEY TIMESTAMP DEFAULT CURRENT NOT NULL
,SFGNODE CHAR (8) NO DEFAULT NOT NULL -- SAFEGUARD node
,ServerclassNAME CHAR (15) NO DEFAULT NOT NULL -- Refers to
=XMA_SFGMVSTATETBL
,FILEBEGIN_GMT CHAR (26) NO DEFAULT NOT NULL -- GMT of the first
record in the file
,FILEBEGIN_LCT CHAR (26) NO DEFAULT NOT NULL -- LCT of the first
record in the file
,RECORDBEGINGMTTSTMP LARGEINT SIGNED NO DEFAULT NOT NULL -- GMT of first
record in this range in timestamp format
,RECORDENDGMTTSTMP LARGEINT SIGNED NO DEFAULT NOT NULL -- GMT of last
record in this range in timestamp format
,RECORDBEGIN_LCT CHAR(26) NO DEFAULT NOT NULL -- LCT of first
record in this range
,RECORDEND_LCT CHAR(26) NO DEFAULT NOT NULL -- LCT of last
record in this range
,PRIMARY KEY RECORDSTATEKEY
)
B10: BASE24 MOVER Table
CREATE TABLE =XMA_b24MVTBL
( SERVERCLASSNAME CHAR(15) NO DEFAULT NOT NULL
-- server class name
,DELETED CHAR(1) DEFAULT 'N' NOT NULL
-- whether this server class has been deleted
,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
-- the above four fields describe the location where the xymove process
-- has to look for the CONF file to get the location of the enscribe
-- audit files
,PRIMARYAUDITFILE CHAR(35) NO DEFAULT NOT NULL
-- primary audit file for this installation
,AUDITFILEMASK CHAR(35) NO DEFAULT NOT NULL
-- location of the audits for this node
,AUDITFILECODE SMALLINT NOT NULL
-- file code to look for
,CURRENTSTATUS VARCHAR(256) NO DEFAULT NOT NULL
-- what is the server doing
,PRIMARY KEY SERVERCLASSNAME
)
CATALOG =XMA_CAT
ORGANIZATION K
SIMILARITY CHECK ENABLE
AUDIT;