XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix E: XMA Host Macros
XYPRO Technology Corporation 206 Proprietary and Confidential
In this Example the start date is set to a date well in the past to pick up any “stray”
records that might remain in the XMA database from long-running sessions. For the
end date a value of 60 is specified, which from October 5, 2004 is calculated to be
August 6, 2004. This removes all data older
than 60 days from the database.
E4: EMSBUILD
The EMSBUILD macro is used to build the template file based on the system
templates and the EMSTEMP file.
E5: PARSAMP
This file contains sample SQLCI commands that you can use to partition your AUDIT
SESSION and AUDIT DETAIL tables.
The PARSAMP File:
-- ********************************************************************
-- ** File: PARSAMP **
-- ** This file contains samples of the commands used to partition **
-- ** an SQL Table **
-- ** Procedure: **
-- ** ========== **
-- ** 1) Modify the statements below adding the volume name. You may **
-- ** optionally enter values for EXTENTS & MAXEXTENTS. **
-- ** The default for EXTENTS is (16,64). The default unit type **
-- ** is page. The default for MAXEXTENTS is 160. **
-- ** You may add additional ALTER statements if more partitions **
-- ** are desired. **
-- ** NOTE: During XMA processing the partition key values **
-- ** assigned are 2 - 255. The value zero is omitted so **
-- ** that an empty partition can be created. The value 1 **
-- ** is reserved for conversion purposes. **
-- ** 2) Stop your XMA Pathway via XMA_MANAGER **
-- ** 3) run the macro XMA_LOAD_DEFINES **
-- ** 4) Execute the following command: **
-- ** SQLCI/in PARSAMP,out $S.#XMA.PART/ **
-- ** 5) Adding partitions will invalidate the SQL programs. **
-- ** To remedy the situation do the following: **
-- ** run $<vol>.<subvol>.xma install **
-- ** run XMA_SQLCOMPALL **
-- ** 6) Restart your XMA Pathway via the XMA_MANAGER **
-- ********************************************************************
?Section audsession
ALTER TABLE =XMA_AUDSESSIONTBL
ADD PARTITION <vol1>.XMADAT.AUDSESS
FIRST KEY 1
WITH DATA MOVEMENT
CATALOG <vol>.XMACAT
-- EXTENT <size1>
-- MAXEXTENTS <int>
;
ALTER TABLE =XMA_AUDSESSIONTBL
ADD PARTITION <vol2>.XMADAT.AUDSESS
FIRST KEY 2
WITH DATA MOVEMENT