XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix B: Administrative Tables
XYPRO Technology Corporation 172 Proprietary and Confidential
B6: MEASURE MOVER Tables
There are three MEASURE MOVER Tables as described below.
MEASURE MOVER Table =XMA_MEASMVTBL
This table contains an entry for each MEASURE MOVER Serverclass.
CREATE TABLE =XMA_MEASMVTBL
( 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
, VOLUME CHAR (8) NO DEFAULT NOT NULL
, SUBVOLUME CHAR (8) NO DEFAULT NOT NULL
, LASTRECORD_LCT CHAR (26) NO DEFAULT NOT NULL
, AUDITTBLINSCOUNT LARGEINT SIGNED NO DEFAULT NOT NULL -- Number of audit
table inserts done
, CURRENTSTATUS VARCHAR(256) NO DEFAULT NOT NULL -- yyyy-mm-dd hh:nn:ss.msssss
LCT of the last record processed -- what is the server doing
, PRIMARY KEY ServerclassNAME
)
MEASURE MOVER Parameter Table =XMA_MEASMVPARAMSTBL
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.
This table contains sets of parameters for each MOVER identified in the MEASURE
MOVER Table above.
Note: The MEASURE MOVER parameters are required. If you choose to add a
MEASURE MOVER via option 7: Add <All Steps> on the Movers Management
Menu (page 101), you must also perform option 12: Alter Database params.
Refer to section 6.9, “MOVER Parameters” starting on page 129 for more
information.
CREATE TABLE =XMA_MEASMVPARAMSTBL
( RECORDPARAMSKEY TIMESTAMP DEFAULT CURRENT NOT NULL
, ServerclassNAME CHAR (15) NO DEFAULT NOT NULL -- Refers to =XMA_MEASMVTBL
, 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
)