Integrating Catalog Manager with the BMC 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 13.1