AIX 5.3 (JFS2)
DB2 8.2

Do all queries issued against a database get put in the package cache? To be clear, and say differently, I want to know if there is ever a an occasion for a given query to not have an entry in what is reported by the "db2 get snapshot for dynamic sql on db" command?

My intent is to use this to identify what queries (and tables) are involved in excessive execution times.

Thanks.

That is true for Dynamic SQL, but not if the SQL statement is embeded static SQL in a application (C, COLBOL, etc) that is pre-compiled, compiled, and a bind package takes place. SQL Stored proecedures are also bound in packages.

Also, if the package cache is too small, and a package is bumped out to make room for a new package, then you may not see it with the snapshot.

Also, make sure your Statement Monitor is set ON in the dbm config.

I don't suppose you know whether or not there is much embedded/compiled/bound sql with SAP?

There is currently a healthy listing in my package cache so there must be a good deal of dynamic sql.

Thanks again.

You should be able to tell by looking at the list of packages in the Control Center. Obviously, you need to ignore any packages that come with DB2.