BMC common Db2 Repository tables


The BMC common Db2 Repository tables follow a naming convention. The following table provides the synonyms and local table names.

Warning

Important

The local table names might be different at your site, based on options selected during product installation.

Table name (Synonym)

Local table name

Description

OBJSETS (BMCSCC_OBJSETS)

BMCUTIL.CMN_OS

This table describes and provides information about object sets.

OBJSET_DEF (BMCSCC_OBJSET_DEF)

BMCUTIL.CMN_OS_DEF

This table contains one row for each object set definition specification defined for an object set.

OBJSET_SQL (BMCSCC_OBJSET_SQL)

BMCUTIL.CMN_OS_SQL

This table contains one row for each object set specification in dynamic SQL (type SQ).

GRPOPTS (BMCSCC_GRPOPTS )

BMCUTIL.CMN_OS_OPTS

This table contains one row for each option defined to either a defined object set or a subsystem level option.

PRODREG (BMCSCC_PRODREG)

BMCUTIL.CMN_OS_PREG

This table should have one entry for each product and version that is registered.

GROUPAUTH (BMCSCC_GROUPAUTH)

BMCUTIL.CMN_OS_GAUTH

This table optionally contains one row for each authority granted on an object set. No rows exist if no authority has been granted.


 

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

BMC AMI Recovery Manager for Db2 13.1