Important We are integrating BMC AMI LOBMaster technology into the BMC AMI Reorg product and discontinuing BMC AMI LOBMaster as a separate product. For the latest integrated documentation, see BMC AMI Reorg for Db2 13.1.

BMCSYNC table

The BMCSYNC table contains information about the status of the objects that the currently executing products are accessing.

The BMCSYNC table synchronizes and controls access to Db2 spaces by concurrently executing BMC products. If you have more than one product installed, all of these products should share the same BMCSYNC table.

The following BMC AMI Utilities insert rows into BMCSYNC during the BEFOREACC phase and delete rows during the AFTERACC phase:

  • BMC AMI Check
  • BMC AMI Load
  • BMC AMI Reorg
  • BMC AMI Stats
  • BMC AMI Unload

Related topics

BMCUTIL and BMCSYNC table maintenance

Shared-access-levels-of-BMC-products

Concurrent-access-control

Overview-of-BMC-AMI-Utilities-concepts

All other products insert rows into BMCSYNC during the UTILINIT phase and delete rows during the UTILTERM phase. While the job executes, the products update the table when the status of the object changes.

The following table describes the contents of the BMCSYNC table:

Column name

Data type

Description

UTILID

CHAR(16)

Product identifier

(BMC AMI Recover) This column is blank when a RECOVER UNLOADKEYS command creates the row and then a RECOVER BUILDINDEX command reads and deletes the row.

NAME1

CHAR(8)

Database name or creator name

(DASD MANAGER PLUS) This value is the database name.

(CHECK PLUS, LOADPLUS, REORG PLUS, and UNLOAD PLUS) If the value for NAME1 would exceed 8 bytes or the value for NAME2 would exceed 18 bytes, NAME1 contains the DBID for the object.

(BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload) If the value for NAME1 would exceed 8 bytes, NAME1 contains the OBID in hexadecimal format.

NAME2

CHAR(18)

Space, table, or index name

(DASD MANAGER PLUS) The BMCSTATS product always inserts the space name (limited to a maximum of 8 characters).

(CHECK PLUS, LOADPLUS, REORG PLUS, and UNLOAD PLUS) If the value for NAME1 would exceed 8 bytes or the value for NAME2 would exceed 18 bytes, NAME2 contains the table OBID or index ISOBID of the object in hexadecimal format.

(BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload) If the value for NAME2 would exceed 18 bytes, NAME2 contains the OBID in hexadecimal format.

KIND

CHAR(2)

Type of object:

  • IP (index partition)
  • IX (index)
  • TB (table)
  • TP (table space partition)
  • TS (table space)
  • DD, DW, D1, D2 (dynamic work file allocation)
  • CI (copy information)
  • RD (restart data set block)
  • LK (limit key)

PARTITION

SMALLINT

Physical partition number:

  • Null or 0 for a single data set nonpartitioned space
  • Data set number for a multi-data-set, nonpartitioned space
  • Partition number for a partitioned space

(all products except BMC AMI Recover and BMC AMI Recovery Manager) The value is null or 0 for any nonpartitioned space.

BMCID

SMALLINT

Internal identifier of the object

DASD MANAGER PLUS, BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column.

UTILNAME

CHAR(8)

Name of the executing product:

  • CHECK
  • CHECKIX
  • COPY
  • STATS
  • LOAD
  • NGTSTATS
  • REBUILD
  • RECOVER
  • REORG
  • UNLOAD

SHRLEVEL

CHAR(1)

Degree to which products can share this object:

  • Blank means that no status is requested, and any other product can obtain any status.
  • S allows sharing among any number of SHRLEVEL S products.
  • X indicates that exclusive control is required. No other product can run with SHRLEVEL X.

STATUS

CHAR(1)

Status of the product or object:

  • Blank (indicates no processing has been done)
  • C (for CHECK PLUS, indicates checked)
  • L (for LOADPLUS, indicates loaded)
  • U (for UNLOAD PLUS, indicates unloaded)
  • R (for REORG PLUS, indicates reloaded)

DASD MANAGER PLUS does not use this column.

XCOUNT

INTEGER

Number of rows or keys processed in the current phase

DASD MANAGER PLUS, BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column.

DDNAME

CHAR(8)

Check, load, unload, or work ddname

DASD MANAGER PLUS, BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column.

BLOCKS

INTEGER

Number of blocks for the check, load, unload, or work data set

DASD MANAGER PLUS, BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column.

ORIG_STATUS

CHAR(8)

Encoded representation of the original Db2 status of the space

(BMC AMI Recover) This column restores the Db2 status of a space after recovery, if necessary.

DASD MANAGER PLUS, BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column.

EXTRBA

CHAR(10)

(BMC AMI Recover) Log point at which this space was externalized

BMC AMI Recover serialization logic uses this column. The other products do not use this column.

Important

BMC AMI Recover no longer uses EXTRBA.

STATE

LONG VARCHAR

Restart information for the space

For example, the STATE indicates the object state and sync information.

DASD MANAGER PLUS, BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column.

INSTANCE

SMALLINT

(BMC AMI Recovery Manager and BMC AMI Recover) Instance number of the current base objects (table and index)

The default value is 1. The other products do not use this column.

 

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