Administration Guide > Database > Database Maintenance > Maintaining Data Records

Maintaining Data Records

Maintaining a databaseA database is an organized collection of data including relevant data structures. includes that data records are regularly archived and reorganized (statisticsThis is a list of a task's previous runs., 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 ILMStands for Information Lifecycle Management, which refers to a wide-ranging set of strategies for administering storage systems on computing devices.
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 jobAn Automation Engine object type for a process that runs on a target system. 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 configurationA set of constituent components that make up a system. This includes information on how the components are connected including the settings applied. per 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. 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 utilitiesUtilities support the execution of administrative tasks in an Automation Engine system (such as reorganizing and archiving the Automation Engine database)..

Keeping the last n data records per objectAutomation Engine controlled activities and processes are structured in the form of objects. See also: Task 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:

Use partitioning with ILM:

It is still necessary to run the utilities to reorganize object versionsAn application version holds zero or more deployment packages and may have dependencies to zero or more application versions of the same (or to different) applications and deleted objects as they are not covered by partitioning with ILM.

 

See also:

Graphical Interface of the Reporting Tool

 


Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support

Copyright © 2016 Automic Software GmbH