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

Analyzing a statement from the Db2 statement cache

Use the following procedure to select and tune any statement in the Db2 statement cache. You must ensure that the workspace contains a Db2 object view that contains the statement.

To analyze a statement from the Db2 statement cache

New console
  1. In the Performance perspective, click the Add view NW_plus_circle_o.png menu arrow and then click Add SQL Statement Cache View.

  2. In the Add DB2 Statement Cache View dialog box, from the DB2 Connection list, select a Db2 subsystem.

    Note

    ClickNW_plug_connect_square_green.png and specify which Db2 connections to include in your list of favorite connections.

  3. In the Filter box, enter the name of the program that contains the statement.You can use wildcards to return a list of statements contained by programs that match the pattern.

  4. Click OK.In the results pane, a list of statements is displayed.

    Note

    Clicking the column headers sorts the results.

  5. Select the desired statement and click Generate explain plan NW_generate_explain.png.The Explain results are displayed along with the following tabs:
Classic console
  1. Click the DB2 Navigator tab.
  2. Click Add DB2 statement cache view CacheStmt-24.png.

  3. In the DB2 Statement Cache for Program Filter dialog box, select a Db2 subsystem:

    • Type the full or partial name of a Db2 connection to select the first subsystem that matches this value in the list of favorite connections.
    • Use the menu arrow to select from your list of favorite connections.

    Note

    ClickViewFavoritesList-24.png and specify which Db2 connections to include in your list of favorite connections.

  4. In the filter box, enter the name of the program that contains the statement.You can use wildcards to return a list of statements contained by programs that match the pattern.

  5. Click OK.In the results pane, a list of statements is displayed.

    Note

    Clicking the column headers sorts the results.

  6. Select the desired statement and click Explain explain-24.png.The Performance perspective displays the graphical Explain for the selected statement in the Explain screen.


 

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