Re: System i Navigator: SQL Plan Cache Snapshots; using Visual Explain for Index Advisor, to improve QZDASOINIT SQLperformance

Eric, you're very kind!

If you do not have any select/omit logicals, you don't need to change the derived-index item in QAQQINI. You want to look, though, at the IGNORE_DERIVED_INDEX entry - all the entries are set to *DEFAULT, what you should do is look at the description in the file. Use RUNQRY () QAQQINI, DSPPFM doesn't show it, since the description is in unicode, I think.

The default is given in the descriptions - for IGNORE_DERIVED_INDEX before 6.1, it says that the default is *NO - you want the value to be *YES, to ignore S/O logicals. The default was changed to *YES at 6.1 of the OS.

Do NOT change the model file that is in QUSRSYS or in QSYS. Make a copy of the one in QUSRSYS (I think - what you read will tell you) and modify that.

Then you need to run the CHGQRYA command in the job to make it look at the QAQQINI you created.

Have fun!!
Vern

On 3/9/2012 10:04 AM, elehti@xxxxxxxxxxxxxxxxxx wrote:

I thank Vern Hamberg and Jim Oberholtzer for your useful comments on
this topic.
On my V5R4M5 machine most of the queries I analyzed are using SQE, not
CQE, so I am glad of that.

I will review QAQQINI parameters to make sure these are set to optimum
values.
I learn a lot from all of you. Eric