Administrators can use the utility AE DB Reorg (ucybdbre) to reorganize data in the database. During this process, data records are marked with a deletion flag in accordance with the specified settings. Once they have been marked, the utility AE DB Unload can be used to remove the flagged data records from the database throughout the AE system and in all clients.
This page includes the following:
Log on to the utility by using the client that you want to reorganize.
(Optional) You can archive the relevant data in batch mode but 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 immediately provides the following status information:
- Table columns
- Table
Data areas (such as messages or statistics) that shows the database tables. By double-clicking the relevant table line, you can change the settings as described below. - Last reorganization
Date and time of the last reorganization run that has been made by using the utility AE DB Unload. - Current number
Number of data records that can be reorganized. - Criteria for reorganization
Current setting of the reorganization criteria including a display of the corresponding date. - Number after reorganization
Number of data records that won't reorganized because of the specified criteria.
Three options are available which you can either double-click directly or open from the File menu:
- Table
- Reset deletion flags
Enables the resetting of the client's deletion flags.
To reset the deletion flags of several clients, see AE DB Unload. - Forecast
Activates the creation of a forecast for the data to be reorganized. - Reorganization
Starts the reorganization process.
You can view the progress of the reorganization run in the window's status line. It displays the name of the current table, the entire number of data records and the progress in percent.
Specify your Settings
You can either use the Settings menu to define your reorganization parameters or double-click the specific table line. The settings you define here will only apply to the client that you 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 should be reorganized:
- Reorg messages
Check this checkbox to signal that the client's messages should be reorganized. - Unread messages
All unread messages that are older than the specified number of days are reorganized. Additionally, the date that corresponds to the specified number of days is displayed. - Read messages
All read messages that are older than the specified number of days will be reorganized. Additionally, the date that corresponds to the specified number of days is displayed.
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) provided 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
- Reorg statistics
Check this checkbox to signal that the client's statistics should be reorganized. - Reorg statistics older than
All statistical data that is older than the specified number of days will be reorganized.
Additionally, the date that corresponds to the number of days displays. Statistical data that shows this date or a more recent on is kept. - Keep last
By using this option, you can specify that the last n statistical records of each object that should be reorganized will be kept. This is useful for executable objects because you can keep statistical data and reports of processes that have run some time ago.
At least the defined number of statistical records will be kept for all objects that should be reorganized. All statistical records that are older and exceed the specified number will be flagged for deletion.
Reports Tab
- Report reorganization
Check this checkbox to have the client's statistics reorganized - Reorg reports older than
All reports that are older than the specified number of days will be reorganized.
Additionally, the date that corresponds to the number of days displays. - Keep last
You can specify that the last n statistical records of the object are not reorganized. This is useful for tasks that have not been executed very often.
Keep last refers to the complete reorganization period. It does not imply that all reports but the last n reports will be reorganized. The utility checks the number of reports that lie within the reorganization period and keeps the last n reports.
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
- Version Management object reorganization
Check this checkbox to have the client's Version Management objects reorganized, see Version Management Page. - Reorg objects older than
All Version Management objects that are older than the specified number of days are reorganized. Additionally, the date that corresponds to the number of days displays. - Keep last
You can specify that the last n Version Control objects are not reorganized. This is useful for tasks that have not been changed very often.
Keep last refers to the complete reorganization period. It does not imply that all reports but the last n reports will be reorganized. The utility checks the number of reports that lie within the reorganization period and keeps the last n reports.
Object Audit Tab
- Reorg Object Audit
Check this checkbox to have the client's Object Audits reorganized, see AE DB Revision Report - Reorg Object Audits older than
All Object Audits that are older than the specified number of days are reorganized.
Additionally, the date that corresponds to the number of days displays. - Only reorg revised Object Audits
Use this option to reorganize only data that has previously been put out in reports by using the utility, see AE DB Revision Report
Create a Forecast
You can create a forecast before you start the actual reorganization process. The advantage is that you can use the settings that you want to use for the reorganization run and have the result displayed in tables.
Note: The setting Keep last is not included in forecast calculations. It ignores the setting that is specified in no_archive_check=.
Technical aspects
- Check your database and log-file backups and database consistency on a regular basis. You can do so by using the means that are available for the specific database.
- Indexes should regularly be reorganized. Doing so increases performance and results in database space that can be used more efficiently. You can also reorganize indexes by using the means that are available for the specific database (such as the Database Wizard for MS SQL Server).
See also: