Analyzing a statement from the Db2 statement cache

To analyze a statement from the Db2 statement cache

1. In the Performance perspective, click the Add view  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.

   Important

   Click 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.

   Important

   The results pane lists statements up to the limit set by the Maximum rows returned option. The default limit is 5000 statements. For more information, see Setting Command Center options.

5. (Optional) To sort the results, click the column headers.
6. Select the desired statement and click Generate explain plan . The Explain results are displayed along with the following tabs:
   • SQL (see SQL tab)
   • Indexes (see Indexes tab)
   • Explain (see Explain tab)
   • Cost (see Cost tab)
   • Predicates (see Predicates tab)