XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix B: Administrative Tables
XYPRO Technology Corporation 171 Proprietary and Confidential
B4: EMS MOVER Parameters Table =XMA_EMSMVPARAMSTBL
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_EMSMVPARAMSTBL
( RECORDPARAMSKEY TIMESTAMP DEFAULT CURRENT NOT NULL
,ServerclassNAME CHAR(15) NO DEFAULT NOT NULL
-- refers to =XMA_EMSMVTBL
,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
AUDIT;
B5: EMS MOVER State Table =XMA_EMSMVSTATETBL
CREATE TABLE =XMA_EMSMVSTATETBL
( RECORDSTATEKEY TIMESTAMP DEFAULT CURRENT NOT NULL
,NODE CHAR(8) NO DEFAULT NOT NULL
,COLLECTOR CHAR(6) NOT NULL
,PROCESSDATE CHAR(10) NOT NULL
-- date of record (1 record for each day for a node+collector)
,COMPLETED CHAR(1) DEFAULT 'N' NOT NULL
-- whether this day has been completed for the node+collector
,PROCESSHANDLE CHAR(35) NO DEFAULT NOT NULL
-- handle of process working on this record
,ServerclassNAME CHAR(15) NO DEFAULT NOT NULL
-- refers to =XMA_EMSMVTBL
,LASTRECORDGMTTSTMP TIMESTAMP NO DEFAULT NOT NULL
(GMT Tstmp of last record processed)
,LASTRECORD_LCT CHAR(26) NO DEFAULT NOT NULL
-- LCT of the last record processed
,RECORDSPROCESSED LARGEINT SIGNED NO DEFAULT NOT NULL
-- number of records processed for this day for node+collector
,SESSIONTBLINSCOUNT LARGEINT SIGNED NO DEFAULT NOT NULL
-- number of session table inserts done while processing records for this day
for node+collector
,AUDITTBLINSCOUNT LARGEINT SIGNED NO DEFAULT NOT NULL
-- number of audit table inserts done while processing records for this day
for node+collector
,PRIMARY KEY RECORDSTATEKEY
)
CATALOG =XMA_CAT
ORGANIZATION K
AUDIT;