BMC Common Db2 repository

The Db2 tables that compose the BMC Common Db2 repository are described in the following topics:

Naming conventions

This section describes the naming conventions for BMC Common Db2 repository tables.

The following table provides the synonyms and local table names:

Important

Synonyms cannot be different and tables names may be different at your site based upon options chosen during product installation.

Synonym	Local table name
BMCSCC_OBJSETS	BMCUTIL.CMN_OS
BMCSCC_OBJSET_DEF	BMCUTIL.CMN_OS_DEF
BMCSCC_OBJSET_SQL	BMCUTIL.CMN_OS_SQL
BMCSCC_GRPOPTS	BMCUTIL.CMN_OS_OPTS
BMCSCC_PRODREG	BMCUTIL.CMN_OS_PREG
BMCSCC_GROUPAUTH	BMCUTIL.CMN_OS_GAUTH

Object set table

The OBJSETS table describes and provides information about object sets.

The following table contains one row for each object set defined in the repository:

Column name	Data type	Description
OSNAME	VARCHAR(27) NOT NULL	Name of object set
CREATE_TSMP	TIMESTAMP NOT NULL WITH DEFAULT	Timestamp of object set creation
CREATE_UID	CHAR(8) NOT NULL	AUTHID of creator of the object set
UPDATE_TSMP	TIMESTAMP NOT NULL WITH DEFAULT	Timestamp of last maintenance activity
UPDATE_UID	CHAR(8) NOT NULL	AUTHID of last updater of the object set
DESCRIPTION	VARCHAR(60) NOT NULL	Description of the object set
PRODUCT_ID	CHAR(3) NOT NULL	Creating product ID: ACP (BMC AMI Copy) AFR (BMC AMI Recover) ARM (BMC AMI Recovery Manager)
TYPE	CHAR(2) NOT NULL	Product group type: BG - full subsystem BA - application RP - repository plan group
NUMBER_OBJECTS	INTEGER NOT NULL WITH DEFAULT	Number of objects from last open
CHECKSUM	SMALLINT NOT NULL	Verification value from API updates

Object set definition table

The following OBJSET_DEF table contains one row for each object set definition specification defined for an object set:

Column Name	Data Type	Description of contents
OSNAME	VARCHAR(27) NOT NULL	Name of the object set
SEQNO	SMALLINT NOT NULL	Sequence number of definition
INCEXC_IND	CHAR(1) NOT NULL	Include or exclude indicator (+, -)
PATTERN_TYPE	CHAR(2) NOT NULL	Pattern for include or exclude: TS (table space name pattern) IX (index name pattern) TB (table name pattern) IS (index space name pattern) PL (plan name pattern) PG (package name pattern) SG (stogroup name pattern) OS (object set name pattern) SQ (dynamic SQL pattern) RP (repository plan)
INC_IX	CHAR(1) NOT NULL	Include related indexes: Y (Yes) N (No
INC_RI	CHAR(1) NOT NULL	Include RI objects: Y (Yes) N (No
INC_LOBS	CHAR(1) NOT NULL	Include LOB objects: Y (Yes) N (No
INC_XML	CHAR(1) NOT NULL	Include XML objects: Y (Yes) N (No
INC_CLONES	CHAR(1) NOT NULL	Include clones only: Y (Yes) N (No
BY_PART	CHAR(1) NOT NULL	Expand objects by partition: Y (Yes) N (No
PART_BEG	SMALLINT NOT NULL	Beginning partition number (0-4096)
PART_END	SMALLINT NOT NULL	Ending partition number (0-4096)'
REF_SEQ_NBR	SMALLINT NOT NULL	For future use
DESC	VARCHAR(60) NOT NULL	Description of the specification
OBJ_QUAL1	VARCHAR(128) NOT NULL	Object qualifier 1
OBJ_QUAL2	VARCHAR(128) NOT NULL	Object qualifier 2
OBJ_QUAL3	VARCHAR(128) NOT NULL	Object qualifier 3
UNI_QUALS	CHAR(1) NOT NULL	UNICODE indicator
UPDATE_UID	CHAR(8) NOT NULL	ID of last updater of object set definitions
UPDATE_TSMP	TIMESTAMP NOT NULL WITH DEFAULT	Timestamp of last maintenance activity
PACKAGE_VERSION	SMALLINT NOT NULL	Package version
INC_HISTORY	CHAR(1) NOT NULL WITH DEFAULT 'N'	Include related history objects: Y (Yes) N (No

Object set SQL table

The following OBJSET_SQL table table contains one row for each object set specification in dynamic SQL (type SQ):

Column name	Data type	Description
OSNAME	VARCHAR(27) NOT NULL	Name of the object set
SPEC_SEQNO	SMALLINT NOT NULL	Sequence number from OBJSET_DEF table
SEQNO	SMALLINT NOT NULL	Sequence number to order multiple SQL entries
TEXT	VARCHAR(72) NOT NULL	Line of SQL text

Group options table

The following GRPOPTS table contains one row for each option defined to either a defined group, or a subsystem level option:

For information about the recover and backup options supported by BMC AMI Recovery Manager, seeBMC AMI Recovery Manager documentation.

Column name	Data type	Description
OSNAME	VARCHAR(27) NOT NULL	Name of object set
OPTION_TYPE	CHAR(10) NOT NULL	Option type: Backup—ARMOPTBKUP Recover —ARMOPTRCVR These are the option types currently used by BMC AMI Recovery Manager. The option type is defined by the product, so this list is product-dependent.
OPTION	VARCHAR(200) NOT NULL	Option name
OPT_VALUE	VARCHAR(200) NOT NULL	Value for named option

Product registration table

The following PRODREG table should be one entry for each product and version that is registered:

Column name	Data type	Description
PRODUCT_ID	CHAR(3) NOT NULL	Product ID
PLAN_NAME	VARCHAR(24) NOT NULL	Plan name
PRODUCT_VERSION	CHAR(4) NOT NULL	Product version

Group authorizations table

The following GROUPAUTH table optionally contains one row for each authority granted on a group: