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