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!
- Check your database and log-file backups and database consistency regularly. You can do so by using the means that are available for the specific database.
- Indexes should regularly be reorganized. Doing so increases your system performance, and results in database space that you can use 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.
Tips
-
This utility automatically creates and updates the UC_UTILITY_REORG variable. No manual interaction is required. For details, seeUC_UTILITY_REORG - Reorganization Specifications
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:
- Table
Shows data areas such as messages, statistics, reports, version management and object audits. The related database tables are included in brackets. By double-clicking the relevant table line, you can change the settings. - Last reorganization
Date and time of the last reorganization run that was made with the AE DB Unload utility - Current number
Number of data records that can be reorganized - Criteria for reorganization
Current definitions of the reorganization criteria that have been made. The date as of which the reorganization should take place is shown in brackets. - Number after reorganization
Number of data records that are not reorganized because of the specified criteria
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:
- Reset deletion flags
Allows you to reset the deletion flags of the particular.
To reset the deletion flags of several clients, see AE DB Unload. - Forecast
Creates a forecast of the data that should be reorganized. - Reorganization
Starts the reorganization process. You can view the progress of the reorganization run in the status line of the window. This line shows the name of the current table, the entire number of data records, and the progress in percent..
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:
- Reorg messages
Check this checkbox to signal that the messages of the client should be archived. - Unread messages
All unread messages that are older than the specified number of days are reorganized. Also, 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 are reorganized. Also, 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. 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
- Reorg statistics
Check this checkbox to signal that the statistics of the client should be reorganized. - Reorg statistics older than
All statistical data that is older than the specified number of days is reorganized.
Also, the date that corresponds to the number of days is displayed. Statistical data that shows this date or a more recent one is kept. - Keep last
By using this option, you can specify that the last n statistical records of each object that should be reorganized are kept. Doing so is useful for executable objects because you can keep statistical data and reports of processes that have run some time ago, and do not run often. At least the defined number of statistical records is kept for all objects that should be reorganized. All statistical records that are older and exceed the specified number are flagged for deletion.
Reports Tab
- Report reorganization
Check this checkbox to have the statistics of the client reorganized - Reorg reports older than
All reports that are older than the specified number of days are reorganized. Also, the date that corresponds to the number of days is displayed. Reports younger than the specified number of days are kept. - Keep last
You can specify that the last n statistical records of the object are not reorganized. Doing so is useful for tasks that have not been executed very often.
Keep last refers to the complete reorganization period. This setting does not imply that all reports but the last n reports are 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 Version Management objects of the client reorganized. See Version Management Page. - Reorg objects older than
All Version Management objects that are older than the specified number of days are reorganized. Also, the date that corresponds to the number of days is displayed.
All Version Management objects that are younger than the specified number of days are kept. - Keep last
You can specify that the last n Version Control objects are not reorganized. Doing so is useful for tasks that have not been changed very often.
Keep last refers to the complete reorganization period. This setting does not imply that all reports but the last n reports are 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 Object Audits of the client 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. Also, the date that corresponds to the number of days is displayed.
All Object Audits that are younger than the specified number of days are kept. - 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
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: