Flushing Dynamic sql cache

lekhrajm

Newbie

Join Date: Dec 2007

Posts: 2

#1: Dec 14 '07

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

« previous question | next question »

Similar DB2 Database bytes

SQL Functions & the Package cache... (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,471 network members.