XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix B: Administrative Tables
XYPRO Technology Corporation 182 Proprietary and Confidential
B18: iTP Secure WebServer State Table
The iTP MOVERs utilizes the table below to track the current audit file and the date of
the last record within the file that has been processed. This prevents the creation of
duplicates. It also allows the MOVERs to “catch-up” if they have to be stopped and
restarted.
CREATE TABLE =XMA_AUDITFILESTATETBL
( AUDITFILENAME_HASH CHAR(28) NO DEFAULT NOT NULL
,FILEBEGIN_LCT TIMESTAMP NO DEFAULT NOT NULL
,ALERTCOLLECTTYPE CHAR(01) DEFAULT 'B' NOT NULL
,SERVERCLASSNAME CHAR(15) DEFAULT SYSTEM NOT NULL
,AUDITFILENAME VARCHAR(1024) NO DEFAULT NOT NULL
,AUDITFILECT LARGEINT DEFAULT SYSTEM NOT NULL
,AUDITFILEMT LARGEINT DEFAULT SYSTEM NOT NULL
,FILEEND_LCT TIMESTAMP DEFAULT TIMESTAMP
"1970-01-01:00:00:00.000000" NOT NULL
,COMPLETED CHAR(1) DEFAULT 'N' NOT NULL
,PROCESSHANDLE CHAR(35) DEFAULT SYSTEM NOT NULL
,RECORDSPROCESSED LARGEINT DEFAULT SYSTEM NOT NULL
,SESSIONTBLINSCOUNT LARGEINT DEFAULT SYSTEM NOT NULL
,AUDITTBLINSCOUNT LARGEINT DEFAULT SYSTEM NOT NULL
,CURRENTAUDITSTATUS VARCHAR(256) DEFAULT SYSTEM NOT NULL
,PRIMARY KEY (AUDITFILENAME_HASH
,FILEBEGIN_LCT
,ALERTCOLLECTTYPE )
)
CATALOG =XMA_CAT
ORGANIZATION K
AUDIT;