Concurrency with other BMC utilities for Db2

All BMC utility products use the BMCUTIL table to control the use of utility IDs, which identify executions of BMC utilities. Only one utility with a specific utility ID can run at one time, and BMC AMI Recover terminates when it is started for a space against which another BMC utility is already running.

For more information about this table, see BMCUTIL table.

BMC utility products use the BMCSYNC table to coordinate access to Db2 objects. Db2 objects that participate in a BMC utility job are registered in the BMCSYNC table. When each object is registered, the registering utility assigns a share level to control access to that object from other BMC utilities. For partitioned Db2 spaces, registration is performed at the partition level. For more information about this table, see BMCSYNC table.

The BMCSYNC table allows multiple BMC utilities (or multiple instances of a single utility) to operate concurrently on different partitions of a Db2 space if no nonpartitioning indexes are involved. In addition, some BMC utilities can operate concurrently on the same object or partition. For information about which products can operate concurrently, see the following table.

The 'Access level' column in the table below refers to the value of the SHRLEVEL column in the BMCSYNC table. The level can be one of the following values:

S indicates shared access. Any other utility that registers with shared access (S) can run against the object.
X indicates exclusive access. No other utility can run against the object.
A blank value indicates that no status is requested and any other utility can run against the object.

Running BMC products concurrently

Product	Access level	Additional information
CHECK PLUS	S	None
BMC AMI Copy	S or blank	If you specify COPY IMAGECOPY, BMC AMI Copy registers the object with no access status (blank). In all other cases, BMC AMI Copy registers the object with shared access (S).
DASD MANAGER PLUS (BMCSTATS)	S	None
LOADPLUS	X	If you specify PART, LOADPLUS registers only the specified partitions with exclusive access (X). If no nonpartitioned indexes exist on the table space, you can run other utilities on different partitions concurrently with this job.
BMC AMI Recover	X, S, or blank	Under the following conditions, BMC AMI Recover registers an object with shared access (S): If an index is being rebuilt, the table space for that index is registered with shared access if that table space is not also recovered in the same job. A table space partition is registered with shared access if the keys for that partition are unloaded with a RECOVER UNLOADKEYS operation. If you specify the following commands or options, BMC AMI Recover registers the object with no access status (blank): The ACCUM command OUTCOPY ONLY INDEP OUTSPACE In all other cases, BMC AMI Recover registers the object with exclusive access (X).
BMC AMI Recovery Manager	S	None
REORG PLUS	X	If you specify PART, REORG PLUS registers only the specified partitions with exclusive access (X). If no nonpartitioned indexes exist on the table space, you can run other utilities on different partitions concurrently with this job.
UNLOAD PLUS	S	None

Related topic

Serialization and concurrency issues

Concurrency with other BMC utilities for Db2

Comments