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.

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

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

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.