AE DB Reorg

Administrators can use the AE DB Reorg utility (ucybdbre) to reorganize data in the database. During this process, data records are marked with a deletion flag according to the parameters and settings that have been defined. Once the data records are marked, the AE DB Unload utility can remove the flagged data records from the database throughout your AE system, and in all clients.

This page includes the following:

Important!

Tips

Overview

You can log on to the utility by using the client that you want to reorganize.
(Optional) You can archive the relevant data in batch mode. For this purpose that you must start the utility at least once in regular mode to specify the settings you require. For more information, see Start Parameters - Utilities.

The graphical user interface provides the following status information in the following table columns:

The lower window area provides three sections that you can either double-click directly, or open from the File menu in the upper left window area:

Defining Reorganization Parameters

You can either use the Settings menu to define your reorganization parameters or double-click the specific table line. The settings you define here only apply to the client that you have used to log on to the utility. You can specify a specific period for all data records that should be archived. The hour 00:00 is used as the start time of a day to ensure that complete days are considered in calculations.

Messages Tab

Define what you want to reorganize:

Important! The setting of the INI file parameter auto_reorg= overrules the setting of the graphical interface which determines a period such as messages that are older than x days. A prerequisite is that the INI file value is the lower value. The system always uses the lower value. For more information, see Utility DB Reorg.

Statistics Tab

Reports Tab

Important! Statistical records are reorganized together with the reports that are related to them (RH/RT). When you activate report organization in the Reports tab, the effect is that reports are reorganized before the statistical records are reorganized.

Version Management Tab

Object Audit Tab

Creating a Forecast

You can create a forecast before you start the actual reorganization process. The advantage is that you use the settings for the upcoming reorganization run, and have the result displayed in tables.

Note: Forecast calculations ignore the Keep last setting, and the setting that is specified in no_archive_check=.

See also: