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
