XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Chapter 8. Maintaining the XMA Database
XYPRO Technology Corporation 150 Proprietary and Confidential
[$<vol>.<SUBVOL>.batarch
- == Process type -/*/######
[t_begin_dt] == Begin Date
00:00:00 == Begin Time
[t_end_dt] == End Date
23:59:59 == End Time
<add archive subvol> == Archive Location
<add description here> == Archive Description
]
#unframed
Deleting Obsolete Archives
You can delete obsolete archive tables manually, using Database Management Menu,
option 10 or 11. Refer to section 5.5, “The Database Management Menu” page 104.
You can also automate the deletion of obsolete archives by creating a batch job similar
to Example 1 below. This job invokes the ADELMAC macro to select the data records
to be archived and invokes the BARCDEL program that is shipped with XMA and
resides in its installation subvolume.
Example 1: Sample Archive Cleanup Job File:
Run <$vol>.<subvol>.xma install
Run <<$vol>.<subvol>.ADELMAC
ADELMAC is shipped with XMA and resides in its installation subvolume. Customize it
to define the archive tables you wish to delete. Its contents are shown in Example 2
below.
Example 2: Contents of the ADELMAC Listing
?tacl macro
#frame
==
== = Runs the BARCDEL macro
== =
[#push
t_end_dt
]
XMA_datetime_make <days>
#set t_end_dt [XMAdt_year4]-[XMAdt_month]-[XMAdt_day]
[<$vol>.<subvol>..barcdel
[t_end_date] === delete everything <= this date
23:59:59 === end time & <= this time
]
#unframed
8.1.3 Using CLEANUP to Delete Obsolete Data Records
You can automate the cleanup by configuring the HKEEPER (Housekeeper)
Serverclass. The first time you run the XMA_MANAGER after installing/upgrading
XMA, you be asked if you want automatic database cleanup to occur. You will be
prompted for the number of days of data to retain and what time of day you want the
cleanup program to run.