BMCXCOPY table

DBNAME

CHAR(8)

Name of the database

IXNAME

CHAR(8)

Name of the index space or table space for Instant Snapshots and associated copies

DSNUM

INTEGER

Data set number within the index or table space

ICTYPE

CHAR(1)

ICDATE

CHAR(6)

Date of the entry (yymmdd)

START_RBA

CHAR(6)

FILESEQNO

INTEGER

Tape file sequence number of the copy:

DEVTYPE

CHAR(8)

Type of device on which the copy resides

IBMREQD

CHAR(1)

Whether the row came from the basic machine-readable material (MRM) tape:

• N (NO)
• Y (YES)

DSNAME

CHAR(44)

Name of the data set

If STYPE V, DSNAME is the name of the VSAM data component.

ICTIME

CHAR(6)

Time at which this row was inserted (hhmmss).

The insertion takes place after the completion of the operation that the row represents.

SHRLEVEL

CHAR(1)

SHRLEVEL parameter on COPY if ICTYPE F:

• C (change)
• R (reference)

DSVOLSER

VARCHAR(1784)

Volume serial numbers of the data set.

Commas separate items in a list of 6-byte numbers. This column is blank if the data set is cataloged.

TIMESTAMP

TIMESTAMP

Date and time when the row was inserted.

This is the date and time that are recorded in ICDATE and ICTIME. The use of TIMESTAMP over ICDATE and ICTIME is recommended because later Db2 releases might not support the latter two columns.

ICBACKUP

CHAR(2)

Type of image copy contained in the data set:

• LB (data set contains local backup data)
• RP (data set contains recovery system main data)
• RB (data set contains recovery system backup data)
• blank (data set contains local system main data or is not one of the multiple copies)

ICUNIT

CHAR(1)

Media on which the image copy data set is stored:

• D (DASD)
• T (tape)
• Blank (medium is neither tape nor DASD)

STYPE

CHAR(1)

type of copy:

• blank (for ICTYPE=F)
• V (Instant Snapshot or a VSAM data set)
• e (encrypted copy)

PIT_RBA

CHAR(6)

point-in-time recovery:

• X'000000000000' (for ICTYPE=F)
• consistent point (for COPY_TYPE=O)

GROUP_MEMBER

CHAR(8)

Data-sharing group member (the name of the SSID where the copy was made).

This column is blank if you are not using data sharing.

OTYPE

CHAR(1)

Type of object:

• T (table)
• I (index)
• i (compressed index)

LOWDSNUM

INTEGER

Not used

HIGHDSNUM

INTEGER

Not used

COPYPAGESF

FLOAT(8)

The number of pages written to the copy data set.

NPAGESF

FLOAT(8)

High-used RBA divided by the page size.

NPAGESF

FLOAT(8)

High-used RBA divided by the page size.

CPAGESF

FLOAT(8)

The total number of changed pages.

JOBNAME

CHAR(8)

Job name

AUTHID

CHAR(8)

Authorization ID

OLDEST_VERSION

SMALLINT

When ICTYPE= B, F, I, S, W, or X, the version number of the oldest format of data for an object.

For other values of ICTYPE, the value is –1.

LOGICAL_PART

INTEGER

Logical partition number

LOGGED

CHAR(1)

Logging attribute of the table space:

• Y (logged)
• N (not logged)
• blank (row inserted prior to Db2 version 9)

For a non-LOB table space or index space, a blank indicates that the logging attribute is logged.

TTYPE

CHAR(8)

Row format for the table space or partition:

• RRF (reordered row format)
• BRF (basic row format)

INSTANCE

SMALLINT

Instance number of the current base objects (table and
index)

The default value is 1.

RELCREATED

CHAR(1)

Db2 release that created the object

If the release is earlier than version 9, the value is blank.

COPY_TYPE

CHAR(1)

Type of copy:

• C (cabinet copy)
• O (online consistent copy)
• blank (default value)

NOTE_VALUE

CHAR(4)

The encoded value that quickly locates data for a specific space in a cabinet copy

The default value is blank.

OCC_COPY_RBA

CHAR(6)

Original START_RBA of an online consistent copy

The default value is blank.

OCC_LOCKRULE

CHAR(1)

Locking rule for a table space (not used for indexes):

• A (for page level)
• R (for row-level)
• Blank (default value)

OCC_SPACE_ALTERED

CHAR(1)

Whether the space was altered:

• Y (altered)
• N (not altered)
• Blank (default value)

CAB_BLOCKS

INTEGER

Total number of frames written for a cabinet copy