Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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.

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>';

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.

Related topic
Was this page helpful? Yes No Submitting... Thank you

Comments