Skip to Content

 

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Catalog Manager for Db2 13.1.

Catalog Manager tables

The tables that are listed in the following table are created by 

Catalog Manager

. You can refer to the data in these tables for information on your daily operations.

Catalog Manager tables

Table name

Description

BMCACT vr.ATTR

Contains information about attributes

BMCACT vr.ATTR_VAL

Contains the valid values for each attribute

BMCACT vr.AUDIT_LOG

Contains an entry for each DDL statement that is executed by Catalog Manager to modify the Db2 catalog

For more information, see The-DDL-Audit-Log.

BMCACT vr.CRS_VAL

Contains cross-validation between attributes

BMCACT vr.DLG

Contains dialog-specific information

BMCACT vr.DLG_ATTR

Contains the attributes to be displayed for each dialog

BMCACT vr.EDITOR_USERS

Contains one row for each data editing session in progress

A row is inserted when data is fetched and deleted when the editing session ends. All rows that reference a particular user ID are deleted when that user ID begins another editing session.

If an editing session ends abnormally, the applicable row might not be deleted from the table. Users with SYSADM authorization can delete all rows from the table by using an option on the Edit and Browse Options panel.

For more information about the Clear Editor Users Table option , see Setting-options-for-browsing-data

BMCACT vr.FCRS

Contains the Filter Combo Result Table

BMCACT vr.GMAP

Contains the grid mapping table

BMCACT vr.MSG

Contains the informational messages

BMCACT vr.RECOVERY_LOG

Contains an entry for each object that is dropped and each privilege that is revoked when the DROP statement is executed within Catalog Manager and the Drop Recovery option is set to Y

For more information, see The-Drop-Recovery-Log.

BMCACT vr.SEARCH_VARS2

Contains the values for variables that were entered in SEARCH statements and saved

For more information, see Using-host-variables-in-a-search.

BMCACT vr.SESSION_LOG

Contains an entry for each Catalog Manager action for which logging was requested

For more information, see The-Session-Log.

BMCACT vr.SQL_TABLE

Contains SQL statements that have been saved

For more information, see Using-the-SQL_Table

BMCACT vr.VIEW

Contains the initial view for each utility that is supported

Related topic

Setting-up-Catalog-Manager


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Catalog Manager for Db2 12.1