iSeries Navigator and Execution Plan

[Jack]

Hi,

Using iSeries Navigator V5R4M0 on my laptop to get an execution plan
from a SQL Script (under the "Run and Explain" option), I get the
diagram of the execution plan. That's fine.

My coworker does the same on his laptop. And he gets a message stating
that the diagram for the request cannot be displayed since no
statistical data has been collected for the request (it's an
approximate translation since the message he gets is in French).

Suspecting an authority problem, I logged with my user profile on his
laptop and ran the SQL statement under the "Run and Explain" option.
Same error message is displayed.

Looks like there is a difference in the configuration in our 2 iSeries
Navigator. We compared the most obvious parameters, and they're all
the same. Since it does not look like an authority problem, what
should we do in order to get his iSeries Navigator to display the
execution plan?

Thanks

Jack

[Stefano P.]

> Hi,
> Using iSeries Navigator V5R4M0

Have you installed latest service pack (for Navigator)?
ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/v5r4m0/servicepack/si27741/SI27741.EXE

> My coworker does the same on his laptop.

Is that the same query against the same files in the same libraries?

And what about statistics collecting on your iSeries/i5?!

> Thanks
> Jack

Regards
Stefano P.

--
"Niuna impresa, per minima che sia,
può avere cominciamento e fine senza queste tre cose:
e cioè senza sapere, senza potere, senza con amor volere"
[Anonimo fiorentino, XIV sec.]

(togliere le "pinzillacchere" dall'indirizzo email ;-)