Database Areas

This topic describes the available database areas and lists only the main table for each area. For a complete list of the tables, see the DB Schema.

This page includes the following:

Object Area

The size of this area depends on the number of objects that have been created. Usually, it grows slowly.

If the Version Management is used or Transport Cases are loaded and Clients are copied, these tables grow rapidly. Use the provided utilities for deleting object versions, Recycle Bin contents, or Clients that are no longer used.

Creating statistics is very useful. Reorganize your tables and indexes if major modifications have been made, otherwise do so from time to time.

The main table for the objects is the OH table.

Process Monitoring

These tables contain information on the tasks. Its size depends on the number of tasks that are shown in the Process Monitoring perspective.

In the Automatic Deactivation section on the Attributes Page of executable objects, select the Deactivate on Finish: Always option to keep control over table growth and avoid a negative impact on performance. For more information, see Attributes Page.

It is not possible to work with dynamic statistics because table entries change constantly. It is recommended to create one-time statistics instead.

Tables and indexes must only be reorganized when there have been atypically large table movements. Usually, they do not have to be reorganized.

The main table for the executions is the EH table.

Archive and Statistics

This is the largest part of the AE database. Its contents depend on the ongoing tasks and their reports. The "RT" table is the largest one.

Significant changes in volume occur when Clients are copied or deleted.

Use the supplied utilities to archive and remove data.

Tip: Create statistics whenever you reorganize data records. Reorganize tables and indexes regularly.

Important! As of v12.2.2, the LAH table is used to store the daily telemetry data for PLA. This is the data that can be accessed via the Rest API or sent to Broadcom. To run queries and create various reports about usage data, you can now use the available command-line options of the License Reporting Tool (LRT). This tool including detailed documentation are available from our download center at https://downloads.automic.com/.

The main table for the archive and statistics DB area is the AH table.

Forecast

This is a small area of the AE database because, usually, not many forecasts are available.

Statistics must be created only once.

The main table for the forecasts is the FH table.

Messages

This table is relatively large. It includes AE system messages and grows constantly.

Use the supplied utilities to reduce the amount of data.

CA Automic recommends creating statistics whenever you have had data records reorganized. Reorganize tables and indexes regularly.

Tip: Create statistics whenever you reorganize data records. Reorganize tables and indexes regularly.

The table for the messages is the MELD table.

Processing

Because processing is handled on a highly dynamic basis, the corresponding tables are mostly empty.

Tip: Creating statistics automatically is not useful. Create statistics once.

Tables and indexes must be reorganized after unusually large table movements but not regularly.

Example: The work processes block because of a database problem. The communication processes run as usual and write in the corresponding tables. These tables are not processed.

The tables for processing are MQ*CP*and MQ*WP*, depending on the server process processing the data.

System Tables

These tables are almost static. Data amounts do not really change.

Statistics must be created only once.

The tables do not have to be reorganized.

The UC_* tables are system tables.

Temporary tables

This area is mostly empty. The tables are populated only when data has been searched and the contents are deleted subsequently.

Do not create access statistics. Tables and indexes must be reorganized only if there have been large table movements. No regular reorganization is necessary.

Sample tables are BH, BT and UC_TEMP*.