Administration Guide > Database > Database Maintenance > Method A - Utilities

Maintaining Data Records

A lot of data accumulates during daily operation of an AE system.

This includes:

Statistical records
Reports
Messages and data for the Revision Reportand the Open Interface toOutput Management Systems

Onemethod to maintain the AE databaseA database is an organized collection of data including relevant data structures. is using the following utilities:

AE.DB Archive
AE.DB Reorg
AE.DB Unload

General

The utilities included in the maintenance procedure can be called in batch mode (see Start Parameters). Use this opportunity and create a workflow in your AE system, which carries out the individual steps on a regular basis (see example)! The particular settings need to be specified only once in the utility.

Note that system client 0000 should also be maintained! It can accumulate major amounts of data as it contains the log files of the servers and agents and other data.

Note that you must not backup the table DIVDB when you use a DB2 database and want to backup it manually before you run the reorganization process. The reason is that the reorganization process uses the table DIVDB running the statement

ALTER TABLE DIVDB ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE

and you can neither restore the backup data nor run the command ROLLFORWARD anymore.

Procedure

	1.	Archiving

The utility AE DB Archive serves to archive messages, statistics and reports. The generated files are clearly structured in folders organized by clients and archiving runs. As folder names also contain the corresponding dates, it is easier to locate particular data records.

Archived data can be viewed with the Archive Browser at any time. Set filters to limit the number of data records to be displayed depending on your requirements.

	2.	Reorganizing

Use the utility AE DB Reorg for the subsequent reorganization of data records. These are marked with deletion markers in this step but are not yet deleted from the database!

	3.	Unloading the data records

Call the utility AE DB Unload to finally erase the data records from the database. Use the option "Reorganize database". If necessary, this utility can also be used for resetting archive and reorganization flags.

Performance Improvement

The archiving, reorganizing and unloading processes can take some time if huge amounts of data are involved. The following tips can help to improve performance by accelerating the above processes:

When reorganizing, avoid using the option "Keep the last n statistics." By doing so, the utility AE DB Reorg does not count all statistical records of all objects but directly starts the reorganization process using the date as a basis.
Only reorganize reports if they should be reorganized before the statistical records. If this option is not activated, the utility AE DB Reorg reorganizes reports together with the statistical records.
In the utility AE DB Unload, specify that no REORG files should be generated. The corresponding parameter suppress_output= is available in the INI file section [REORG].