BMCXCOPY table

The BMC utilities use the BMCXCOPY table to track registered copies.

The following table describes the contents of the BMCXCOPY table, which contains information about the following types of registered copies:

  • Indexes that BMC AMI Copy has copied:
    • COPY NO index copies
    • DSNUM n index (nonpartitioned) copies
    • Incremental index copies
    • Index copies that are made at data set level

Related topics

Common-utility-tables

Maintaining-the-BMCXCOPY-table

Registering-index-copies

Registration-of-copies

  • Instant Snapshots made by BMC AMI Copy that are not registered as Flash Copies in SYSCOPY with the BMC EXTENDED BUFFER MANAGER (XBM) product or BMC SNAPSHOT UPGRADE FEATURE (SUF) technology, and any standard copies made in association with the Instant Snapshot
  • Online consistent copies
  • Cabinet copies
  • Encrypted copies

The BMCXCOPY table functions like SYSIBM.SYSCOPY except that IXNAME replaces TSNAME in BMCXCOPY. You must control authorization and access to users for BMCXCOPY through standard Db2 authorization.

If you have more than one BMC utility installed, all of these utilities should share the same BMCXCOPY table.

Column name

Data type

Description

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)

Operation type:

  • F (COPY FULL YES; for BMC AMI Copy, online consistent copies)
  • I (COPY FULL NO)
  • W (REORG LOG NO)
  • B (REBUILD INDEX)
  • P (POINT-IN-TIME RECOVERY)
  • C (for BMC AMI Copy version 7.3 and earlier, online consistent copies)
  • s (used by BMC AMI Copy to track system pages)
  • m (indicates that the table space was exported by the BMC AMI Copy EXPORT command or migrated by the BMC AMI Recover IMPORT command)
  • i (index incremental old image copy)
  • t (tag)
  • f (migrate only)
  • r (reset rba - Used for updating HPGCLRSN)
  • b INDEP or SIMULATE progress reporting
  • e INDEP or SIMULATE progress reporting
  • p INDEP or SIMULATE progress reporting

ICDATE

CHAR(6)

Date of the entry (yymmdd)

START_RBA

VARCHAR(10)

The relative byte location of a point in the IBM Db2 RECOVERY log

The indicated point is as follows:

  • For ICTYPE F, the starting point for all updates since the image copy was taken
  • For COPY_TYPE O, the minimum of the consistent point and the oldest inflight URID
  • (BMC AMI Recovery Manager) For ICTYPE C, the consistent log point for the copy
    • RBA for non-data-sharing systems
    • LRSN for data sharing systems

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 column contains 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

VARCHAR(10)

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(53)

Number of pages written to the copy data set

NPAGESF

FLOAT(53)

High-used RBA divided by the page size

CPAGESF

FLOAT(53)

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 earlier 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)

RBA/LRSN format for the space or partition:

  • B (basic 6-byte format)
  • E (extended 10-byte 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

COPY_TYPE

CHAR(1)

Type of copy:

  • C (cabinet copy)
  • O (online consistent copy)
  • X (export copy)
  • I (import copy)
  • Blank (default value)

NOTE_VALUE

CHAR(4)

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

The default value is blank.

NOTE_TYPE

CHAR(1)

Type of NOTE (issued by BMC AMI Copy):

  • A (ABS - tape)
  • R (REL - disk)
  • F (frame)
  • Blank (default value)

OCC_COPY_RBA

VARCHAR(10)

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

EXPSSID

VARCHAR(8)

Source location SSID of the migration file (valid with COPY_TYPE = I)

EXPSLRSN

VARCHAR(10)

Indicates the SYNC AUTO point on the source (valid with COPY_TYPE = I and COPY_TYPE = X)

EXPTLRSN

VARCHAR(10)

Indicates the SYNC AUTO point on the target (valid with COPY_TYPE = I)

 

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