DB2v8 zos Visual Explain and missing milliseconds.

cliff boley

DB2v8 zos Visual Explain and missing milliseconds.
Hi all,
when I use VEv8 'Retrieve Statements' from the 'List Static SQL
Statements' window the statement list shows all of the
milliseconds and service units as 0.

What I'm I missing.

thanks,

cliff:-)

---------------------------------------------------------------------------------
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

Myron Miller

Re: DB2v8 zos Visual Explain and missing milliseconds.
(in response to cliff boley)
I would strongly suspect that the package/plan has not been bound with explain
for the sql userid that you're using. That's the only way that I've ever seen
this happen. The plan/package has to have been bound explain (yes) with the
specific userid that your using on the VE window. You either need to change
the userid to the one that the package was bound with or rebind it with explain
yes and your userid.

Myron
--- BOLEY Maurice C * Cliff <[login to unmask email]> wrote:

> Hi all,
> when I use VEv8 'Retrieve Statements' from the 'List Static SQL
> Statements' window the statement list shows all of the
> milliseconds and service units as 0.
>
> What I'm I missing.
>
> thanks,
>
> cliff:-)
>
>
---------------------------------------------------------------------------------
> 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
>

---------------------------------------------------------------------------------
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