BMC Common Db2 repository tables

The BMC common Db2 repository is made up of several Db2 tables.

Naming conventions

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

Important

The local table names might be different at your site, based on options selected 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

OBJSETS table

The following table describes the contents of the OBJSETS table. This table describes and provides information about object sets. This 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
OSNAME_DELIMITED	CHAR(1) NOT NULL WITH DEFAULT 'N'	For use with delimited names Will be 'Y' if the related column is a delimited name (entered with double quotes around it) when entered

OBJSET_DEF table

The following table describes the contents of the OBJSET_DEF table. This table contains one row for each object set definition specification defined for an object set.

Column name	Data type	Description
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
QUAL1_DELIMITED	CHAR(1) NOT NULL WITH DEFAULT 'N'	For use with delimited names Will be 'Y' if the related column is a delimited name (entered with double quotes around it) when entered
QUAL2_DELIMITED	CHAR(1) NOT NULL WITH DEFAULT 'N'	For use with delimited names Will be 'Y' if the related column is a delimited name (entered with double quotes around it) when entered
QUAL3_DELIMITED	CHAR(1) NOT NULL WITH DEFAULT 'N'	For use with delimited names Will be 'Y' if the related column is a delimited name (entered with double quotes around it) when entered

OBJSET_SQL table

The following table describes the contents of the OBJSET_SQL table. This 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

GRPOPTS table

The following table describes the contents of the GRPOPTS table. This table contains one row for each option defined to either a defined group, or a subsystem level option.

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

PRODREG table

The following table describes the contents of the PRODREG table. There 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

GROUPAUTH table

The following table describes the contents of the GROUPAUTH table. This table optionally contains one row for each authority granted on a group. No rows exist if no authority has been granted.

Column name	Data type	Description
OSNAME	VARCHAR(27) NOT NULL	Name of object set
GRANTEE	CHAR(8) NOT NULL	AUTHID to whom authorization was granted
TYPE	CHAR(1) NOT NULL	Type of authorization granted
GRANTOR	CHAR(8) NOT NULL	Grantor of authorization
DATE_GRANTED	TIMESTAMP NOT NULL WITH DEFAULT	Timestamp of when authorization was granted