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).

Related topics

Common-utility-tables

Displaying-the-status-of-a-BMC-AMI-Recover-job

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 Overview of 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

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.

    For more information, see the BMC AMI Utilities documentation.

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.

This section contains the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*