DB2 LUW 8.1 fixpak 14
Red Hat EL AS 4.4
I'm trying to diagnose some nocturnal CPU pressure, and am trying to
understand the dynamic statement cache as it applies to LUW. The only
doc/redbooks I am finding are for Z/OS, which I am completely ignorant
of.
I am using only Java and JDBC in my applications. No static SQL.
How does dynamic statement cache work in LUW 8.1? Is there a local
statement cache? I think there is a global statement cache (based
upon the "get snapshot for dynamic sql on <db>" command), but how do I
control it? Is it always turned on? Can I change its size?
If I prepare a statement in a java app, will the compiled version
of the statement remain in the cache after I have closed the
PreparedStatement? Will it remain after the java program completely
exits?
Any help appreciated.
aj
