Skip to Content

 

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

Integrating Catalog Manager with the Common Explain component

This section describes how to use 

Catalog Manager

 commands to navigate to the 

BMC Explain

 component of the 

BMC AMI SQL Explorer for Db2

 and 

BMC AMI Apptune for Db2

 products. For detailed information about the functions of 

BMC Explain

 and the reports that it produces, see the BMC AMI SQL Explorer for Db2 documentation

.

You can access and explain SQL in several ways. To access SQL statements in Catalog Manager, you can create lists of Db2 objects and navigate through the objects to SQL statements that are stored in the Db2 catalog, or you can use the Catalog Manager SQL_Table to access SQL statements that were saved in a Catalog Manager session.

Before you begin

Before you attempt to use the BMC Explain component with Catalog Manager, verify that the ACTPSS CLIST has been installed and customized.

For more information, see the Installation system documentation and Customizing BMC Products and Solutions for DB2.

This section contains the following topic:



 

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

BMC AMI Catalog Manager for Db2 12.1