Report it to IBM:
https://www14.software.ibm.com/webapp/set2/ssr/slprob
IBM has never charged me for any PMRs, intelligent or not.
As far as I know, they only charge for consulting services, but you need to
consent to those.
Elvis
Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com
-----Original Message-----
Subject: RE: Is this an SQL problem or quirk
Thanks for your reply Duane
That is in fact what is causing the problem, however, the difference
between his and the system version does not make any sense as to the
difference in the results
Here is what I posted in an earlier e-mail
we were thinking it was something to do with
IGNORE_DERIVED_INDEX being changed from the default of *NO to *YES.
According to the text in the file, it says....
Allows SQE to process the query even when a mapped key index or select omit
index exists over a table in the query. SQE will ignore the derived index
(s) and continue. QQVAL: *DEFAULT--The default value is set to *NO.
*YES--Allow the SQE optimizer to ignore the derived index and process the
query. The resulting query plan will be created without any regard to the
existence of the derived index(s). *NO--Do not ignore the derived index. If
a derived index exists CQE will process the query.
Once this was changed back to the default, the results for BOTH of us was
what was expected.
Alan Shore
midrange.com
