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.

Commands to access SQL

Catalog Manager

 enables you to issue simple line commands to access SQL, as follows:

  • Issue the BMCEXPLORE command to explain a DBRM, package, or plan.

    Using the BMCEXPLORE command

    GUID-798DA5C7-F1A8-4B5A-B688-84196E708E7C-low.png

  • Issue the DESCRIBE and GET commands to explain an SQL statement that is stored in a DBRM or a package.

    Using the DESCRIBE and GET commands

    GUID-E08BA5F1-B229-48BF-BAC6-D445B1279E8D-low.png

  • Issue the ANALYZE command to explain or edit a DML statement from the Catalog Manager SQL_Table.

    Using the ANALYZE command

    GUID-E4423AE3-F670-4D49-9852-3A41A7021884-low.png

This section contains the following topics:

Related topic

Integrating-Catalog-Manager-with-the-Common-Explain-component



 

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

BMC AMI Catalog Manager for Db2 12.1