Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Catalog Manager for Db2 13.1.

Utility commands

Catalog Manager generates and submits a JCL file for several BMC and Db2 utilities.

Related topic

Commands

To execute a utility, type the command in the Cmd column next to an appropriate item on a list. The following table lists the utility commands:

Command

Description

AMICOPY

Displays panels from which you can input options and generate BMC AMI Copy jobs

AMILOAD

Displays panels from which you can input options and generate BMC AMI Load jobs

AMIRECOVER

Displays panels from which you can input options and generate BMC AMI Recover jobs

AMIREORG

Displays panels from which you can input options and generate BMC AMI Reorg jobs

AMISTATS

Displays panels from which you can input options and generate BMC AMI Stats jobs

AMIUNLOAD

Displays panels from which you can input options and generate BMC AMI Unload jobs

BMCCHECK

Displays panels from which you can input options and generate CHECK PLUS jobs with the CHECK DATA command

BMCCHECK INDEX

BMCCHECK IX

Displays panels from which you can input options and generate CHECK PLUS jobs with the CHECK INDEX command

BMCCHTS

Displays panels from which you can input options and generate CHECK PLUS jobs with the CHECK TABLESPACE command

BMCCOPY

BMCCOPY INDEX

BMCCOPY IX

Displays panels from which you can input options and generate BMC AMI Copy jobs

BMCEXPLORE

Calls the SQL Explorer interface

BMCHOBJ

Displays a list of objects processed by BMC utilities

To limit the amount of information displayed by the command, include the userID.utilityID qualifier after the command.

BMCHSTEP

Displays a list of job steps executed by BMC utilities

To limit the amount of information displayed by the command, include the userID.utilityID qualifier after the command.

(BMC.DB2.SPE2110) To display a list of job steps, you can also use the SEARCH BHS command. The SEARCH command provides additional filtering options to limit the amount of information displayed.

BMCLOAD

Displays panels from which you can input options and generate LOADPLUS jobs

BMCREBUILD

BMCREBUILD INDEX

BMCREBUILD IX

Displays panels from which you can input options and generate BMC AMI Recover jobs with the REBUILD INDEX command

BMCRECOVER

BMCRECOVER INDEX

BMCRECOVER IX

Displays panels from which you can input options and generate BMC AMI Recover jobs

BMCREORG

BMCREORG INDEX

BMCREORG IX

Displays panels from which you can input options and generate REORG PLUS jobs

BMCSTATS

BMCSTATS INDEX

BMCSTATS IX

Displays panels from which you can input options and generate BMCSTATS jobs

BMCSTATS is a component of the DASD MANAGER PLUS product.

BMCUHIST

Displays information from the BMC Utility History table

You can also use BMCUHIST as a list command.

BMCUNLOAD

Displays panels from which you can input options and generate UNLOAD PLUS jobs

BMCUTIL

Important

You must have SYSADM authorization or SELECT access on the BMCUTIL tables to access this information.

Executes the BMCUTIL command, and displays the BMC utilities that have not completed or have not been terminated

From this list, you can terminate a utility.

To limit the amount of information displayed, include the userID.utilityID qualifier after the command.

CHECK

CHKD

Displays panels from which you can input options and generate IBM CHECK DATA jobs

CHECK INDEX

CHECK IX

CHKI

Displays panels from which you can input options and generate IBM CHECK INDEX jobs

COPY

COPY INDEX

COPY IX

Displays panels from which you can input options and generate IBM COPY jobs

COPYTOCOPY

COPYTOCOPY INDEX

COPYTOCOPY IX

Displays panels from which you can input options and generate IBM COPYTOCOPY jobs

DISUTIL

Executes the DB2 DISPLAY UTILITY command, and displays the status of utility jobs

To limit the amount of information displayed by the command, include the userID.utilityID qualifier after the command.

DSN1COMP

Displays panels from which you can input options for the IBM DSN1COMP utility

DSN1COPY

Displays panels from which you can input options for the IBM DSN1COPY utility

EXCEPTIONS

Invokes the DASD MANAGER PLUS product to report exceptions on the object

EXEC

Displays panels from which you can input options for the IBM EXEC SQL utility

LOAD

Displays panels from which you can input options for the IBM LOAD utility

MERGECOPY

Displays panels from which you can input options for the IBM MERGECOPY utility

MODIFY

Displays panels from which you can input options for the IBM MODIFY utility

MODIFYRECOVERY

Displays panels from which you can input options for the IBM MODIFY utility with the RECOVERY option

MODIFYSTATISTICS

Displays panels from which you can input options for the IBM MODIFY STATISTICS utility

Displays panels from which you can delete the RUNSTATS profile for a table

Displays panels from which you can define the RUNSTATS profile for a table

Displays panels from which you can update the RUNSTATS profile for a table

QUIESCE

Displays panels from which you can input options for the IBM QUIESCE utility

REBUILD

REBUILD INDEX

REBUILD IX

Displays panels from which you can input options for the IBM REBUILD INDEX utility

RECOVER

RECOVER INDEX

RECOVER IX

Displays panels from which you can input options for the IBM RECOVER utility

REORG

Displays panels from which you can input options for the IBM REORG TABLESPACE utility

REORG INDEX

REORG IX

Displays panels from which you can input options for the IBM REORG INDEX utility

REPORT

REPORT INDEX

REPORT IX

Displays panels from which you can input options for the IBM REPORT utility

RUNSTATS

RUNSTATS INDEX

RUNSTATS IX

Displays panels from which you can input options for the IBM RUNSTATS utility

SPACE

Invokes the DASD MANAGER PLUS product to display space estimation for the object

SSR

Displays all rows from the SmartSwitch rules table

SST

From the SmartSwitch tracking table, this command displays objects processed by BMC utilities

To limit the amount of information displayed by the command, include the databaseName.spaceName qualifier after the command.

STATS

Invokes the DASD MANAGER PLUS product to display statistics for the specified object

STATUS

Important

You must have SYSADM authorization or SELECT access on the BMCUTIL tables to access this information.

Executes the DB2 DISPLAY UTILITY and BMCUTIL commands, and displays the results in a single list

From this list, you can terminate a utility.

To limit the amount of information displayed, include the userID.utilityID qualifier after the command.

STOSPACE

Displays panels from which you can input options for the IBM STOSPACE utility

SYNC

Executes the SYNC command and displays the BMC utility sync tables

TERM

Information

TERM of a BMC Utility requires DELETE authorization on the BMCUTIL and BMCSYNC tables.

Executes the DB2 TERM UTILITY command

The command is valid from the following lists only:

  • IBM UTILITY LIST (DISUTIL)
  • BMC UTILITY LIST (BMCUTIL)
  • Db2 and BMC UTILITIES LIST (STATUS)

TERMBATCH

Generates JCL to terminate a utility in batch

The command is valid from the following lists only:

  • BMC UTILITY LIST (BMCUTIL)
  • Db2 and BMC UTILITIES LIST (STATUS)

UNLOAD

Displays panels from which you can input options for the IBM UNLOAD utility

UTIL

UTILITY

Displays a panel from which you can select and order one or more utilities to run in a single job for the specified object

UTIL profileID

UTILITY profileID

Displays panels from which you can input options for the utilities that are included in the specified utility profile

 

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