XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix B: Administrative Tables
XYPRO Technology Corporation 168 Proprietary and Confidential
B1: XYGATE MOVER Configuration Tables
XYGATE MOVER Table =XMA_XYMVTBL
The information in this table describes the Serverclass-to-XYGATE product
relationship and the audit filename and location for that product.
CREATE TABLE =XMA_XYMVTBL
(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 XYMOVER
-- process has to look to obtain product version information
-- to ensure that the correct audit file layout is used
, 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
-- Indicates status of audit file processing. Updated by Mover
, PRIMARY KEY ServerclassNAME
);
XYGATE MOVER Parameters Table =XMA_XYMVPARAMSTBL
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 XYGATE
MOVER Table above.
CREATE TABLE =XMA_XYMVPARAMSTBL
(RECORDPARAMSKEY TIMESTAMP DEFAULT CURRENT NOT NULL
, ServerclassNAME CHAR (15) NO DEFAULT NOT NULL
-- Refers to =XMA_XYMVTBL
, 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
);