Creating a Db2 statement cache view

Related topics

Analyzing a statement from the Db2 statement cache

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

Important

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

To create a Db2 statement cache view

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.