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 Command Center for Db2 13.2

SQL tab

The SQL tab opens when you select a statement in the Performance perspective, or when you create a tuning session for an ad hoc SQL statement.

If you select a statement from a package or from the statement cache, the statement is displayed in the SQL tab.

Tip

If you want to edit a statement selected from the statement cache or from a package, you must create a What-If scenario.

If you are creating an ad hoc tuning session, you must enter the statement into this pane. You must also populate the other fields. For more information, see Analyzing-an-ad-hoc-statement.

Note

After the statement has been explained, in the Classic console click What-If WhatIf-24.png(in the New console, click NW_create_what_if.png) to modify the statement, or enter new parameters to run a subsequent Explain.


 

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