for SQL performance analysis you'll need access to the database part of the
iSeries Navigator (not the application administration part).
In the iSeries Navigator part you'll not only find Visual Explain (which is
much more powerful than STRDBG), but also the SQL plan cache and SQL
Performance Monitors. You'll also find the index advices. If you open the
index advices it is also possible to get the SQL statements that caused this
advices (at least as long as there was no IPL).
iSeries Navigator Database is IBM's strategical product for database
creation, administration and analysis.
IMHO all programmers who work with (embedded) SQL and have to create
database objects, need to have access on the iSeries Navigator Database.
(Long ago it also took me more than one hour of discussion with the system
administrator and my manager to allow me to use the iSeries Navigator
Mit freundlichen Grüßen / Best regards
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
Gesendet: Monday, 14. September 2009 19:58
Betreff: RE: Advised index not used but still advised
Unfortunately, I am 'denied using application administration' for the work
management parts of iNav. Maybe our operations people can get to it for me.
Thanks for the tip.
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Monday, September 14, 2009 11:13 AM
To: Midrange Systems Technical Discussion
Subject: Re: Advised index not used but still advised
You've always got access to the statement.
If you know which job was servicing the request, and know that the request
was just issued, there's a "Show Last SQL" statement option you can use from
Otherwise, there's the SQL Plan cache or as a last resort, start an SQL
Once you have the statement displayed, Visual Explain will tell you all
about it including which query engine was used and why it didn't use the
Privileged and Confidential. This e-mail, and any attachments there to, is
intended only for use by the addressee(s) named herein and may contain
privileged or confidential information. If you have received this e-mail in
error, please notify me immediately by a return e-mail and delete this
e-mail. You are hereby notified that any dissemination, distribution or
copying of this e-mail and/or any attachments thereto, is strictly
This thread ...
RE: Advised index not used but still advised, (continued)
This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact