A lot of data accumulates during daily operation of an AE system.
This includes:
Onemethod to maintain the AE databaseA database is an organized collection of data including relevant data structures. is using the following utilitiesUtilities support the execution of administrative tasks in an Automation Engine system (such as reorganizing and archiving the Automation Engine database).:
The utilities included in the maintenance procedure can be called in batch mode (see Start Parameters). Use this opportunity and create a workflowAn object of the Automation Engine that can include several executable objects and which runs them in a specified order. [Formerly called "ProcessFlow" and "JobPlan."] in your AE system, which carries out the individual steps on a regular basis (see example)! The particular settings need to be specified only once in the utility.
Note that system clientA closed environment within an Automation Engine system where you can create and run objects. A client name consists of a 4-digit number that must be indicated when a user logs on to the Automation Engine system. Users and their rights are also defined in clients. A particular Automation Engine object type. 0000 should also be maintained! It can accumulate major amounts of data as it contains the log files of the servers and agents and other data.
Note that you must not backup the table DIVDB when you use a DB2 database and want to backup it manually before you run the reorganization process. The reason is that the reorganization process uses the table DIVDB running the statement
ALTER TABLE DIVDB ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE
and you can neither restore the backup data nor run the command ROLLFORWARD anymore.
![]() |
1. |
---|
The utility AE DB ArchiveThe utility AE DB Archive can be used to remove the increasing amounts of data from the Automation Engine database. serves to archive messages, statisticsThis is a list of a task's previous runs. and reports. The generated files are clearly structured in folders organized by clients and archiving runs. As folderTop level entities such as Environment, Deployment Target, Activity, … are stored in folders. The permissions a user has on an entity depend on the permissions that are set on the folder for the entities. names also contain the corresponding dates, it is easier to locate particular data records.
Archived data can be viewed with the Archive Browser at any time. Set filters to limit the number of data records to be displayed depending on your requirements.
![]() |
2. |
---|
Use the utility AE DB ReorgData can be reorganized by using the utility DB Reorg. It marks data records with a deletion flag in accordance with the settings that have been specified. for the subsequent reorganization of data records. These are marked with deletion markers in this step but are not yet deleted from the database!
![]() |
3. |
---|
Call the utility AE DB UnloadUtility for unloading the Automation Engine database. to finally erase the data records from the database. Use the option "Reorganize database". If necessary, this utility can also be used for resetting archive and reorganization flags.
The archiving, reorganizing and unloading processes can take some time if huge amounts of data are involved. The following tips can help to improve performance by accelerating the above processes:
See also:
Sample Collection - Database Maintenance with Options
Technical Maintenance of the AE database
Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support |
Copyright © 2016 Automic Software GmbH |