Writer instructions
Page title	For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n.
Purpose	Provide an announcement banner on every page of your space.
Location	Move this page outside of your home branch.
Guidelines	Space-announcements-banners

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

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.

BMCSYNC table

On this page