Hello,

I'm trying to find the static statement cache (not dynamic). As far as I know it is somewhere in the catalog but I didn't find it. Could you please tell me where to look for it?

Regards,
Stephan

there is no such thing as a static statements cache
db2 stores in memory the packages that are being executed for the static statements

if you want to see which statements each package contains you can query sysibm.syspackstmts

Thanks for the quick answer. As far as I have seen the stmt text is encoded. Is there a simple way (for example using an SQL stmt) to get the originial stmt texts?