XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix B: Administrative Tables
XYPRO Technology Corporation 184 Proprietary and Confidential
B20: PARAMS Table
As of release 1.90 of XMA, all the Serverclasses share the PARAMS Table.
CREATE TABLE =XMA_PARAMSTBL
( SERVERCLASSTYPE CHAR(15) NO DEFAULT NOT NULL
,SERVERCLASSNAME CHAR(15) NO DEFAULT NOT NULL
,PARAMNAME VARCHAR(50) NO DEFAULT NOT NULL
-- name of the parameter
,PARAMVALUE VARCHAR(256) NO DEFAULT NOT NULL
-- value of the parameter
,PARAMDESC VARCHAR(50) NO DEFAULT NOT NULL
-- description of the parameter
,PRIMARY KEY ( SERVERCLASSTYPE, SERVERCLASSNAME, PARAMNAME )
)
CATALOG =XMA_CAT
ORGANIZATION K
SIMILARITY CHECK ENABLE
AUDIT;
B21: SESSIONOIP Table
This table is the queue file for the IP Address Resolver (IPRESLVR).
CREATE TABLE =XMA_SESSIONNOIPTBL
( PARTITIONKEY NUMERIC (4,0) NO DEFAULT NOT NULL
,RECORDSESSIONKEY DATETIME YEAR TO FRACTION(6) DEFAULT SYSTEM N
,SESSIONID CHAR(36) NO DEFAULT NOT NULL
,RECORDLCT DATETIME YEAR TO FRACTION(6) DEFAULT SYSTEM N
,TERMINAL VARCHAR(64) DEFAULT NULL
,PROCESSTHREADID VARCHAR(50) DEFAULT NULL
,IPADDRESS CHAR(16) DEFAULT NULL
,RETRIES SMALLINT NO DEFAULT NOT NULL
,PRIMARY KEY (PARTITIONKEY,RECORDSESSIONKEY)
)
CATALOG =XMA_CAT
ORGANIZATION K
SIMILARITY CHECK ENABLE
EXTENT (512,512) format 2
AUDIT;