Creating a Db2 statement cache view

You can create a view of Db2 statements from the statement cache. Then, you can select statements to view, Explain, and tune.

Note

To have data in the Db2 statement cache, set the DB2 CACHEDYN subsystem parameter to YES.

To create a Db2 statement cache view

New console

Open or create a workspace.
In the DB2 Performance perspective, click the Add View menu arrow, and then click Add DB2 Statement Cache View.
Success
Tip
The default value of the Add View menu is always the last option that you created. If you previously created, in this or a previous saved session, a DB2 Statement Cache view then clicking creates a new DB2 Statement Cache view
Complete the Add DB2 Statement Cache View dialog box:
1. Select a DB2 connection from the list.
  Success
  Tip
  Clicking lets you specify which DB2 connections to include in your list of favorite connections.
2. Enter a filter pattern for the selected program name or package name.
Click OK.The view is added into the DB2 navigation pane in a hierarchical display organized by subsystem and type.
(Optional) To add additional filters to the same subsystem, return to Step 3.b and specify a filter.

Classic console

Open or create a workspace.
In the DB2 Navigator perspective, click the Add Viewmenu arrow, and then click Add DB2 Statement Cache View .
Success
Tip
You can also right-click in the DB2 navigation pane to select this option.The default value of the Add View menu is always the last option that you created. If you previously created, in this or a previous saved session, a DB2 Statement Cache view then clicking creates a new DB2 Statement Cache view
Complete the Add DB2 Statement Cache View dialog box:
1. Select a DB2 connection:
  - 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.
    Success
    Tip
    Clicking lets you specify which DB2 connections to include in your list of favorite connections.
2. Enter a filter pattern for the selected program name or package name.
Click OK.The view is added into the DB2 navigation pane in a hierarchical display organized by subsystem and type.
(Optional) To add additional filters to the same subsystem, return to Step 3.b and specify a filter.