[z/os] Visual Explain and Dynamic Cache

Mae Bruce

[z/os] Visual Explain and Dynamic Cache
Visual Explain has a feature that you can look at the statements in the
dynamic cache. But it appears that when you do the "list cache
statements" the DSN_STATEMENT_CACHE_TABLE table is cleaned out and
EXPLAIN STMTCACHE ALL is being done. Is there a way that you can look
at what is already in the DSN_STATEMENT_CACHE_TABLE? Once we do a
EXPLAIN STMTCACHE ALL we would like to be able to analyze that data for
a while, even having several people looking at it. Also if you are data
sharing and want to look at the activity from a whole data sharing group
you can't because the rows in the DSN_STATEMENT_CACHE_TABLE keep
getting deleted each time you do the "list cache statement".

I just upgraded to the latest version (Ver 8 v1.0.11) hoping that
something had changed for the better, but it still works the same way.

Mae Bruce

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm