Administrators can use the AE DB Reorg utility (ucybdbre) to reorganize data in the database. Reorganizing your database tables regularly is vital because it ensures that you use your database space efficiently. During this process, this utility marks data records with a deletion flag according to the parameters and settings that you have defined. Once the data records are marked, the AE DB Unload utility can permanently remove the flagged data records from the database throughout your AE system, and in all clients.
Important!
- Check your database, log-file backups, and database consistency regularly. Do so by using the means that are available for the specific database.
- Reorganize every client regularly, especially client 0. Even in small systems, it is recommended to run the reorganization process every day. You can set up an SQLI variable for this purpose. For details, see SQLI VARA Objects
- It is recommended to reorganize indexes regularly. Doing so increases your system performance, and ensures that you can use database space more efficiently. You can reorganize indexes by using the means that are available for the specific database, such as the Database Wizard for MS SQL Server.
- You can archive the relevant data in batch mode. For this purpose that you must start the utility in regular mode at least once to specify the settings you require. For more information, see Start Parameters - Utilities.
Tips:
- This utility automatically creates and updates the UC_UTILITY_REORG variable. No manual interaction is required. For details, see UC_UTILITY_REORG - Reorganization Specifications
This page includes the following:
Overview
Log on to the utility by using the client that you want to reorganize.
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 AEDB Unload.
- Forecast
Creates a forecast of the data that should be reorganized. You may want to create such a forecast before you start the actual reorganization process. In this case, the utility counts the data records to be reorganized according to your settings, and displays the result in the particular tables.
Note: Forecast calculations ignore the Keep last settings, and the settings specified in no_archive_check=. - 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
This table includes all system messages. You can 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 INI file parameter auto_reorg= setting 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
This table contains a list of past executions.
- 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
This table stores all reports that are associated with tasks.
- 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). If you activate report organization in the Reports tab, the effect is that reports are reorganized before the statistical records are reorganized.
Version Management Tab
The object version table contains the complete set of versions created incrementally for every object.
- 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
This table contains the revision reports generated by the AE DB Revision Report DB Revision Report utility.
- 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
See also:
- Utilities
- Start Parameters - Utilities
- INI file - AE DB Reorg