XYGATE Merged Audit Reference Manual

Table Of Contents
XYGATE Merged Audit
®
Reference Manual
Chapter 8. Maintaining the XMA Database
XYPRO Technology Corporation 149 Proprietary and Confidential
Option Selection Description
1: Archive Interval
(M[ONTHLY]/W[EEKLY]/D[ISABLED])
Designate the frequency of the archive
processing.
2: Auto Archive Start Date The first date the archive will run.
3: Auto Archive Start Time The time of day the archive will run.
4: Data retention Days before
archiving
The number of days to keep in the XMA
database.
5: Archive Location The subvolume where the archive records will
be stored.
6: Archive Tables Security The security assigned to the archive tables.
7: Spooler Location for output
Default is
$s.#archive
R: Exit Exit to the Database Management Menu.
X: Run Set up Auto Archive Parameters.
You can automate the archive process outside of the XMA_MANAGER by creating a
batch job similar to Example 2 below. This job invokes the ARCMAC macro that is
shipped with XMA and resides in its installation subvolume.
Example 2: Sample Archive Job File:
Run <$vol>.<subvol>.xma install
Run <<$vol>.<subvol>.ARCMAC
ARCMAC is shipped with XMA and resides in its installation subvolume. You can
customize it to define the date range of the data you wish to remove from the
production database to a set of archive tables. Its contents are shown in Example 3
below.
Example 3: Contents of the ARCMAC Listing
===================================================================
== Macro to run Archive Macro BATARCH ==
== Note Regarding Process Type: ==
== - indicates to create a new set of archive tables ==
== * indicates restart all stopped archive processing ==
== ##### Add archive data to existing set of archive tables ==
===================================================================
?tacl routine
#frame
[#push
t_begin_dt
t_end_dt
]
XMA_datetime_make <days>
#set t_begin_dt [XMA_dt_year4]-[XMA_dt_month]-[XMA_dt_day]
XMA_datetime_make <days>
#set t_end_dt [XMA_dt_year4]-[XMA_dt_month]-[XMA_dt_day]