Analyzing a statement from a Db2 package

To analyze a statement from a package

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.

Where to go from here

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