AE DB Reorg

Reorganization

Data can be reorganized by using the utility AE DB ReorgDienstprogramm für die Reorganisierung der Automation Engine-Datenbank. Datensätze werden auf Grund bestimmter Einstellungen mit einem Löschkennzeichen versehen.. It marks data records with a deletion flag in accordance with the settings that have been specified.

You can use the parameter no_archive_check= in the program's INI file in order to define that only data records are reorganized that have already been archived.

Log on to the utility using the client that should be reorganized. You can also reorganize in batch mode (see Start Parameters).
Before you start this service program in batch mode, note that you must start it in regular mode at least once in order to specify the settings you require.

Use the utility AE DB Unload to remove the marked data records from the database. This data is then deleted throughout the AE system and in all clients.

Only have the utility AE DB Reorg reorganize reports if they should be reorganized before the statistical records are reorganized. If this option is not activated, the utility reorganizes reports and statistical records together.

Field/Control		Description
Table		Lists the possible data areas that can be reorganized.
	Table	Data area with a specification of the relevant tables.
	Last reorganization.	Date and time of the last reorganization run that has been made by using the utility AE DB UnloadDienstprogramm zum Entladen der Automation Engine-Datenbank.
	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 are not reorganized because of the specified criteria.
Reset deletion flags		Enables the resetting of the client's deletion flags. You can also use the utility AE DB Unload to reset the deletion flags of several clients.
Forecast		This button activates the creation of a Forecast for the current data stock
Reorganization		Click this button in order to start 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.

Settings

You can specify the reorganization parameters by using the menu command Settings. You can also double-click the table entry in order to open the window in which you can specify your settings.

Note that these settings only apply to the client that you used to log on to the utility.

Note that the setting of the INI-file parameter auto_reorg= overrules the setting of the graphical interface which determines a period of time (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.

A particular period of time can be specified for all data records that should be reorganized. The hour 00:00 is the time that is used to ensure that complete days are considered in calculations.

Messages Tab

Description

Field/Control Element	Description
Reorg messages	Use this checkbox to specify that the messages of the client are reorganized.
Unread messages	All messages that have not yet been read and are older than the specified number of days are reorganized. Additionally, the date that corresponds to the number of days displays.
Read messages	All read messages that are older than the specified number of days are reorganized. Additionally, the date that corresponds to the number of days displays.

Statistics Tab

Description

Field/Control Element	Description
Reorg statistics	You can use this check box to specify that the statistics of the client are reorganized.
Reorg statistics older ...	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 or a more recent date 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 in doing so, you can keep statistical data and reports of processings 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 or exceed the specified number will be flagged for deletion

Field/Control Element

Description

Reorg statistics

You can use this check box to specify that the statistics of the client are reorganized.

Reorg statistics older ...

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 or a more recent date 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 in doing so, you can keep statistical data and reports of processings 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 or exceed the specified number will be flagged for deletion

Note that the deletion flag is always set if you reorganize the reports that are related to the statistics (RH/RT). It is set even if the reorganization of reports is not activated.

Reports Tab

Description

Field/Control Element	Description
ReportBericht, der nähere Informationen über die Durchführung einer Aufgabe oder einer Komponente enthält. reorganization	With this check box you can specify that the reports of the client are reorganized.
Reorg reports older ...	All reports 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 also specify that the last n statistics of the object are not reorganized. This function is suitable for tasks that have not been executed very often. "Keep last..." refers to the reorganization period. It does not imply that all reports but the last n reports are reorganized. In fact, the utility checks the number of reports that lie within the reorganization period and keeps the last n reports.

Field/Control Element

Description

ReportBericht, der nähere Informationen über die Durchführung einer Aufgabe oder einer Komponente enthält. reorganization

With this check box you can specify that the reports of the client are reorganized.

Reorg reports older ...

All reports 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 also specify that the last n statistics of the object are not reorganized. This function is suitable for tasks that have not been executed very often.

"Keep last..." refers to the reorganization period. It does not imply that all reports but the last n reports are reorganized. In fact, the utility checks the number of reports that lie within the reorganization period and keeps the last n reports.

Version Management Tab

Description

Field/Control Element	Description
Version management object reorganization	You can use this check box to specify that Version-Control objects of the client are reorganized.
Reorg objects older than ...	All Version-Control 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 also specify that the last n Version-Control objects are not reorganized. This function is suitable for tasks that have not been changed very often. "Keep last..." refers to the reorganization period. It does not imply that all versions but the last n versions are reorganized. In fact, the utility checks the number of versions that lie within the reorganization period and keeps the last n versions.

Field/Control Element

Description

Version management object reorganization

You can use this check box to specify that Version-Control objects of the client are reorganized.

Reorg objects older than ...

All Version-Control 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 also specify that the last n Version-Control objects are not reorganized. This function is suitable for tasks that have not been changed very often.

"Keep last..." refers to the reorganization period. It does not imply that all versions but the last n versions are reorganized. In fact, the utility checks the number of versions that lie within the reorganization period and keeps the last n versions.

Object Audit Tab

Description

Field/Control Element	Description
Reorg Object Audit	You can use this check box to specify that Object Audits of the client are reorganized.
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	Using this option reorganizes only data that has previously been put out in reports by using the revisioning program (UCYBDBRR.EXE).

Forecast

You can create a Forcast before you start the reorganization process. The data records that should be reorganized are counted according to the specified settings and the results are displayed in tables.

Note that the setting "Keep last ..." is not included in Forcast calculations. It does not consider the setting no_archive_check=1 which the utility uses to flag only the previously archived data records with a deletion flag.

Technical aspects

Automic strongly recommends checking 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 particular database.
Indices should regularly be reorganized. Doing so increases performance and results in database space that can be used more efficiently. You can also reorganize indices by using the means that are available for the particular database (such as the Database Wizard for MS SQL Server).