Database Areas

This topic describes the available database areas and lists their tables.

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.

Table Names

CODE, HACL, HOST, IY, JBA, JFA, JPA, JPOP, JPOV, JPP, JPPA, JPPC, JPPCV, JPPF, JPPO, JPPV, JPVA, MAND, OACL, OBLOB, OCA, OCV, ODOC, OEA, OET, OFA, OFC, OFS, OGA, OH, OHA, OHAA, OHAF, OHG, OHGF, OIA, OKA, OKB, OKC, OKD, OEO, OKG, OKZ, OLC, ONA, OOA, OOI, OPPF, OPSA, OPSE, OPSEA, OPU, OPUD, OPUDA, OQA, OQT, ORA, ORACL, ORADR, ORB, ORCON, ORET, ORLNK, ORSYS, OSA, OSLF, OSLOA, OSLOB, OT, OTA, OTI, OTZC, OUA, OVB, OVC, OVD, OVP, OV, OVT, OVW, OVX, OX, OY, OYD, OYR, OYW, UACL, USG, USR, USRG, USRP.

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.

Table Names

ECA, ECV, EEC, EEDB, EET, EFC, EH, EJ, EJPCV, EJPFV, EJPOP, EJPOV, EJPP, EJPPA, EJPPC, EJPPF, EJPPO, EJPPV, EJPVA, EOI, EPD, EPDC, EPPF, EPUD, EPUDA, EQT, ERB, ERET, ESTP, ETI, EV, EVP, EY.

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/.

Table Names

ABLOB, ACA, ACLNT, ACMT, ACTEX, ACV, AFC, AH, AHG, AHGH, AJPCV, AJPFV, AJPOP, AJPOV, AJPP, AJPPA, AJPPF, AJPPO, AJPPC, AJPPV, AJPVA, APD, APDC, APPF, ARB, AUSR, AV, AWS, LAH, LASLM, LLOG, RH, RT, XAO, XRO.

Forecast

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

Statistics must be created only once.

Table Names

FE, FH, FJPP, FJPPA, FJPPC, FJPPF.

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.

Table Name

MELD.

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.

Table Names

IPH, ISTMT, ITL, MQLS, MQMEM, MQSRV, MQ1CP001, MQ1CP0.N, MQ1WP, MQ2DWP, MQ2JWP, MQ2OWP, MQ2PWP, MQ2QWP, MQ2RWP, MQ2WP.

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.

Table Names

FIFO, IDS, INI, UC_ACLB, UC_ACLK, UC_ACLT, UC_AKTX, UC_ATYP, UC_CAR, UC_CHCK, UC_DBSYN, UC_HTYP, UC_INDEX, UC_JOBQ, UC_JOBQE, UC_JOBQT, UC_LIC, UC_MTYP, UC_OREF, UC_OTTYP, UC_OTYP, UC_OVFMT, UC_OVGB, UC_OVTYP, UC_PLATF, UC_REST, UC_RTYP, UC_SGRP, UC_STYP, UC_SVAL, UC_SVALF, UC_SVALM, UC_SVALU, UC_SVALV, UC_SYS, UC_TABLE, UC_VERSI, UC_XERR, UC_ZDU, UC_ZUTYP, VERSION, XREQ.

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.

Table Names

BH, BT, DIVDB, UC_TEMP, UC_TEMP1, UC_TEMP2, UC_TEMP3.

Unused Tables

APA, PC, UC_JBA_REST, UC_SYNTX.

See also:

Automation Engine Database