Maintaining Data Records

Maintaining a database includes that data records are regularly archived and reorganized (statistics, reports, messages etc.). The involved process has direct impact on the size of the AE database and positively affects the performance of your AE system.

For maintaining your data records, you can either use the utilities or partitioning with ILM. The table shown below lists the differences between these two methods:

For	Utilities	Partitioning with ILMSignifie Information Lifecycle Management (gestion du cycle de vie des informations), et se réfère à un large ensemble de stratégies permettant d'administrer les systèmes de stockage de calculateurs.
Supported databases	MS SQL Server, Oracle and DB2	MS SQL Server and Oracle (Enterprise Editions with Partitioning Feature required)
Administrative effort	Low	Higher
Usage	Ideal for smaller AE databases (the more executions per time the longer takes the maintenance run)	Ideal for complex AE databases (short maintenance run almost independent from number of job executions per time)
Performance	The maintenance run can burden the AE system if there are numerous data records.	Changing the partition burdens the AE system only marginally.
Maintenance time and relevant settings	Individual configurationUn ensemble de composants qui constituent un système. Ceci comprend des informations relatives à la manière dont les composants sont connectés, ainsi que les paramètres appliqués. per clientEnvironnement indépendant pour la création et l'exécution d'objets dans un système AE. Le nom d'un client est un nombre de quatre chiffres à saisir lors de la connexion d'un utilisateur au système AE. Les utilisateurs et leurs droits y sont aussi définis.Egalement un type d'objet distinct dans l'Automation Engine. is possible	Same configuration for all clients of the AE system
Archiving	Via the utility AEDB Archive	Via the utility AEDB Archive or Backup of partitions
Viewing archived data records	Via the Archive Browser	Via the Archive Browser or the AE DB Reporting Tool It is also possible to transfer partitions to a separate database and use utilities.
Keeping the last n data records per object	Possible	Not possible
Reports	Reports can be deleted before statistical records are deleted	Reports are reorganized together with the corresponding statistical records because they are both in the same partition.

Use exclusively utilities:

if just a few tasks run in your AE system. This includes that there are fewer statistical records, reports and messages.

Use partitioning with ILM:

if lots of tasks run in your AE system. This includes that there are many data records or
if you do not want to archive the data records. Partitions can be deleted quickly and easily.

It is still necessary to run the utilities to reorganize object versions and deleted objects as they are not covered by partitioning with ILM.