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

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
I learn a lot from all of you. Eric

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by 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 [javascript protected email address].