December 14th, 2007, 04:25 AM
|
|
Registered User
|
|
Join Date: Dec 2007
Posts: 2
Time spent in forums: 31 m 53 sec
Reputation Power: 0
|
|
|
Flushing Dynamic sql cache
Hi,
I want to flush Dynamic Sql CACHE completely in db2 9.1.2
I used command "db2 FLUSH PACKAGE CACHE DYNAMIC".
But it lefts some queries in cache. These are fixed queries.
It creats problem for me to find out top 10 queries with high hit ratio, using table function snap_get_dyn_sql_v91().
These queries come in top 10 most of the time.
Is there any way to flush dynamic sql cache completely.
Lekh Raj
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
