Managing common utility tables

This topic provides basic procedures for working with the common utility tables.

To determine your site’s table names

The names of the common utility tables can be changed during installation.

To determine the names that your site uses, perform one of the following actions:

Use your utility to run a job with restart parameters of MAINT and MSGLEVEL(1).
Specifying MSGLEVEL(1) with MAINT prints the names of the BMC tables that your utility uses and identifies the applied maintenance. The utility does not perform any other processing, and the job ends without affecting any utility that is running.
Run the following SQL statement, replacing tableName with a BMC common utility table name (listed in Common-utility-tables):
SELECT CREATOR,NAME FROM SYSIBM.SYSTABLES
WHERE TSNAME='<tableName>';
Get the names from your Db2 system administrator.

Run SQL statements similar to the following examples.

Example

This example queries the BMCXCOPY table to access information about the rows in an index space:

SELECT *
FROM <creatorName>.CMN_BMCXCOPY
WHERE DBNAME = '<databaseName>'
AND IXNAME = '<indexSpaceName>'
ORDER BY START_RBA;

This example identifies (from the BMCHIST table) the database name, table space name, elapsed time, and when the utility completed:

SELECT DBNAME,SPNAME,CHAR(ELAPSED,ISO),CHAR(TIME,ISO)
FROM <creatorName>.CMN_BMCHIST
WHERE UTILID='<utilityID>';

Use one of the following methods to display the status of BMC utilities:

To display the status of all BMC utilities that are executing or awaiting restart for a given table space or index space, use the following SQL statements:
SELECT * FROM <creatorName>.CMN_BMCUTIL
WHERE DBNAME='<databaseName>'
AND SPNAME='<tableSpaceName>'
SELECT * FROM <creatorName>.CMN_BMCSYNC
WHERE NAME1='<databaseName>'
AND NAME2='<spaceName>';
If you have a license for the BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, or BMC AMI Unload product, specify NGTDISP BMCUTIL or NGTDISP BMCSYNC to display information about the utilities that are executing or awaiting restart. You can optionally filter this information by utility ID.

To terminate a BMC utility, perform one of the following actions:

To terminate a BMC utility that is executing, use the following SQL statements:
DELETE FROM <creatorName>.CMN_BMCUTIL
WHERE UTILID='<utilityID>';
DELETE FROM <creatorName>.CMN_BMCSYNC
WHERE UTILID='<utilityID>';
DELETE FROM <creatorName>.CMN_BMCDICT -- for LOADPLUS and REORG PLUS
WHERE UTILID='<utilityID>';
The utility terminates with return code 8 when the next checkpoint is taken.
To clean up a BMC utility that is not executing, run the utility with the correct utility ID and specify the TERM restart parameter.

This section contains the following topics: