XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix B: Administrative Tables
XYPRO Technology Corporation 170 Proprietary and Confidential
XYGATE MOVER State Auxiliary Table =XMA_XYMVSTATEAUXTBL
CREATE TABLE =XMA_XYMVSTATEAUXTBL
(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_XYMVSTATETBL
, 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
)
B3: EMS MOVER Table =XMA__EMSMVTBL
CREATE TABLE =XMA_EMSMVTBL
( ServerclassNAME CHAR(15) NO DEFAULT NOT NULL
-- server class name
,DELETED CHAR(1) DEFAULT 'N' NOT NULL
-- whether this server class has been deleted
,NODE CHAR(8) NO DEFAULT NOT NULL
-- location of the collector
,COLLECTOR CHAR(6) NOT NULL
-- collector process
,CURRENTSTATUS VARCHAR(256) NO DEFAULT NOT NULL
-- what is the server doing
,PRIMARY KEY ServerclassNAME
)
CATALOG =XMA_CAT
ORGANIZATION K
AUDIT;