Db Maintainance in Automic

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Db Maintainance in Automic

Environment

Product: Automic SaaS, Automic Automation, CA Automic Workload Automation - Automation Engine,CA Automic Operations Manager, CA Continuous Delivery Automation - Automation Engine, CA Automic One Automation, CA Automic Service Orchestration - Automation Engine, CA Automic Oracle, Automic Workload Automation, One Automation

Release : 12.x, 21.x, 24.X, 26.X

Resolution

Database maintenance is Must in an Automation Engine environment, as the system's performance is highly dependent upon the DB's response time.
Maintenance has to be performed with Automic utilities DB Archive, DB Reorg, and DB Unload on a regular basis.

1 - Reorganized data

The Automic DB contains a lot of data related to job processing and object versions. Here is the list of tables that are affected by maintenance:

• MELD : contains messages [visible in the message window of the GUI].
• RH and RT : contain all information related to execution reports.
• AH : contains statistics.
• OH : Contains all the objects (JOBS, EVNT, USER, CLNT, ...) and their versions [visible in the documentation tab]
• XAO : Records the history of modifications against objects, which can consult through the Revision Report.

2 - Automic Utilities

• DB Archive makes a backup copy of the entries, which can, later on, be read through the Archive Browser.
• DB Reorg will flag entries that should be deleted.
• DB Unload will delete the flagged entries.