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.
To query the tables
Run SQL statements similar to the following examples.
To display BMC utility status
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>';
To terminate a BMC utility
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.