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

Generating a tuned statement

After evaluating the effects of What-If indexes on statement performance, you can generate the SQL statements required to create indexes, drop indexes, and update index statistics.

Related topic

Creating-and-editing-a-What-If-index-scenario

Before you begin

The What-If index feature is available only if you have a valid license for the BMC AMI SQL Performance for Db2 solution.

To generate a tuned statement

  1. Create a What-If scenario.For more information, see Creating-and-editing-a-What-If-index-scenario.
  2. Make changes as needed to the indexes:
  3. Explain the What-If scenario.For more information, see Explaining-SQL-statements.
  4. (BMC.DB2.SPE2304) (Optional) To export the explain plan to a PDF file, perform the following steps:
    1. Click Generate Report NW_file_text_o.png .
      Based on your browser settings, after Command Center generates the report, either the Save As dialog box is displayed or the browser saves the file automatically.
    2. Enter a name for the file.
    3. Click Save.
  5. Click Generate.The Generated Statements pane displays the statement required to make the index changes.
  6. Click Save.
  7. Save the file to the required data set.For more information, see Editing-text-files-in-Scratchpad.

 

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