Define an interval in st04 / SQL-Cache

[KayKa]

Hi,

one of our customers runs their systems with DB2 under solaris. The others work with DB2 z/OS or Oracle.

In these both platforms there is a functionality to define an interval in the Statement Cache / Cursor Cache. With a 'reset' button i can reset all data to zero. And with the 'since reset' button i get new data only for the time since pushing the 'reset' button.

I wonder if there is nothing familiar in the DB6 SQL-Cache.

In the st04 transaction there are some buttons to define such an interval, but it seems they work only on the database snapshot screen for bufferpools, cache etc.

The SAP status shows a DB2 9.5.4 and ECC 6.0 SP 18.

Is there something that i have overlooked ?

regards

Kay

[Former Member · Accepted solution]

Kay,

You are right. There is no way to do a reset and "since reset" in the SQL cache in the DBA Cockpit. However other performance snapshots like bufferpools, database etc allow you to do so.

- Sameer