Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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.

Note

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 (NGT Copy)

  • AFR (NGT Recover)

  • ARM (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 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

Related topic

Was this page helpful? Yes No Submitting... Thank you

Comments