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

[paul_power]

Hello Kay,

The behaviour in recent support pack and db2 release levels is that the sql chace is refreshed once you check the sql cache in dbacockpit/st04.

The new behaviour whereby the SQL cache data is refreshed upon entering ST04 -> SQL chache is

the preferred behaviour. The main reason for the old behaviour where the previously stored SQL cache data was initially displayed until a refresh was requested, was due to very slow SQL cahce retrieval in previous releases.

With newer releases, especially db2 v9, it has become faster to retrieve and so, reached an acceptable speed that the behaviour has been changed to trigger a refresh of the data immediately once ST04-> sql cache is

selected.

With this you can be sure that the sql cache you are seeing is current, whenever you check it via dbacockpit.

Hope this helps,

Paul