EXPLAIN STATEMENT CACHE ALL no CPU being collected

Edward Long

EXPLAIN STATEMENT CACHE ALL no CPU being collected
Hi all.
I've begun playing with the above V8 enhancement.
I get the SQL text but nothing else.
I looked through IBMLINK, the install, ops, and administration manuals to see if there is some documented trace requirement or other consideration.
I didn't find one.
Has anyone gotten this thing to fully work? What kind of reports do you run against the resulting table(s)?
Thanks.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Douwe van Sluis

Re: EXPLAIN STATEMENT CACHE ALL no CPU being collected
(in response to Edward Long)
You need to start IFCID 318.
Statistical Data is not collected otherwise.
You can use a normal -START TRACE to active IFCID 318.

Column STAT_TS of table DSN_STATEMENT_CACHE_TABLE contains the timestamp
when the 318 was started.

Vriendelijke groet,
Douwe van Sluis




-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
Ed Long
Verzonden: vrijdag 19 december 2008 19:48
Aan: [login to unmask email]
Onderwerp: [DB2-L] EXPLAIN STATEMENT CACHE ALL no CPU being collected


Hi all.
I've begun playing with the above V8 enhancement.
I get the SQL text but nothing else.
I looked through IBMLINK, the install, ops, and administration manuals
to see if there is some documented trace requirement or other
consideration. I didn't find one. Has anyone gotten this thing to fully
work? What kind of reports do you run against the resulting table(s)?
Thanks.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms