Limited supportBMC 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 Ops Monitor for Db2 13.1 image-2024-5-19_8-5-1.png .

Explain entry points

Several BMC Software products and solutions share the Explain function. The following table describes how you can access the Explain function from these products.

 Entry points for the Explain function

Product

Entry point

Description

BMC AMI Apptune for Db2




Explain Interface option on the product main menu

You can perform a dynamic or static Explain on a plan or package, or on a statement from one of these objects. 1, 2 , 3

SQL Workload Analysis Menu

You can drill down to a statement that was executed and captured by the Data Collector. For static statements, you can run a dynamic, static, or Compare Explain. For dynamic statements, you can run a dynamic Explain.

Statement Cache

You can drill down to a statement that was executed and still resides in the statement cache. You can run a dynamic Explain or you can display Explain information reflecting the current access path for the cache entry.

Views that invoke Explain

You can access the following views:

  • View APPSQLST(Statement data)—Explains the statement associated with the data
  • View APPSQLER(SQL errors)—Explains the statement associated with a SQL error
  • View APPEXCPT(Apptune SQL Exceptions)—Explains the statement associated with exceptions triggered by exceeding thresholds

BMC AMI Ops Monitor for Db2

Explain Interface option on the BMC AMI Ops Monitor for Db2
 - DC Main Menu

You can perform a dynamic or static Explain on a plan, package, or on a statement from one of these objects. 1, 2, 3

Current Activity hyperlink on the THDDETL, THDACTV, THDDBAT, THDSAPD, THDSTPR, THDTSO, THDSPEXT, and THDSPNAT views

You can access Explain information for an active SQL statement in a current thread if the BMC AMI Ops Monitor for Db2
 - Data Collector component is installed.

CACHE ID hyperlink on the ASUTIME view

You can access Explain information for a long-running, dynamic SQL statement that is cached in the EDM pool if the BMC AMI Ops Monitor for Db2
 - Data Collector component is installed.

EXPLAIN button on the SQL summary pop-up of the STRAC display

You can access Explain information for a static SQL statement if the BMC AMI Ops Monitor for Db2
 - Data Collector component is installed.

EXPLAIN button on the SQL event pop-up of the DTRAC display

EXPLAIN button on the DUSER display

You can access Explain information for a dynamic SQL statement if the BMC AMI Ops Monitor for Db2
 - Data Collector component is installed.

Statement ID hyperlink on the SCSQLD view

BMC AMI SQL Explorer for Db2

SQL Explorer main menu

You can perform a dynamic or static Explain on a plan, package, or on a statement from one of these objects. 1, 2,  3

SQLX edit macro

You can mark existing SQL text in a source program for dynamic Explain or execution, or type ad hoc SQL text into an edit session and mark it for dynamic Explain or execution.

BMC AMI Catalog Manager for Db2


BMCEXPLORE command

You can specify BMCEX on a plan or package for Explain processing. 3

Confirm SQL panel

You can perform a dynamic Explain on a single statement by specifying Y for the Analysis option on the Confirm SQL panel. You can access the Confirm SQL panel as follows:

  • Type ANALYZE on SQL that was saved to Catalog Manager’s SQL table.
  • Type DESCRIBE on a package, 3 and type GET nnn , where nnn is the statement number.
  • Type a DML statement on an object in a table list.

BMC AMI Command Center for Db2

DB2 Navigator tab

You can select a statement to Explain from:

  • The DB2 Statement Cache
  • A package, by using the DB2 Object View

Performance tab

You can manually type in an ad hoc statement to Explain.

  1. You can also perform a dynamic Explain on ad hoc SQL text that you enter, or on a DBRMLIB member or one of its statements.
  2. From a list of packages, you can perform an explain package which shows the current access path for static SQL statements even if a BIND with EXPLAIN(YES) has not been done.
  3. If you have not applied PTF BQU0782, you can perform this action on a DBRM as well.


Related topic

Overview-of-the-Explain-function



 

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