Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Analyzing a statement from a Db2 package

Use the following procedure to select and tune a statement from any package.

To analyze a statement from a package

 New console


  1. In the DB2 Navigator perspective, open or create a package view that contains the required statement.
  2. Select the package containing the required statement.
  3. From the Navigate To list, click Explainable Statements.

    The results pane displays all Explainable statements for that package.

  4. Search for and select the required statement.
  5. Perform one of the following actions:
    • Click Properties  to view the statement properties.

    • Click Explain  to display the Explain results in the Performance perspective. You can now perform SQL tuning tasks.

 Classic console
  1. Click the DB2 Navigator tab.
  2. Open or create a package view that contains the required statement.
  3. Select the package containing the required statement.
  4. From the command toolbar, click Show Explainable Statements .

    The results pane displays all Explainable statements for that package.

  5. Search for and select the required statement.
  6. Perform one of the following actions:
    • Click Properties  to view the statement properties.

    • Click Explain  to display the graphical Explain of the selected statement in the Explain tab. You can now perform SQL tuning tasks.


Where to go from here

You can return to the results pane in the DB2 Navigator tab to select other statements.



Was this page helpful? Yes No Submitting... Thank you

Comments