Re: SQL query results in CPI432F

Dennis,

What happens if you create a SQL index? Same message? Also, I seem to
remember that sometimes the optimizer "times out" and does not have the time
to examine every index, so it can advise an already created index (at least,
this seems to apply to the Index Advisor in Visual Explain)

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Mon, Feb 1, 2010 at 9:20 AM, Dennis Lovelady <iseries@xxxxxxxxxxxx>wrote:

I have a somewhat complex query that resulted in CPI432F (suggested access
path, essentially). This query joins two files, and the suggestion is to
add an index over the first file (TAPTC) using keys of TCER and TCSTGE.



I then created a DDS-based logical over the TAPTC file using the suggested
keys since there are other applications that can take advantage of this.
Then I ran my query again.



Oddly, the same message appears in the joblog (with debug active), and the
same suggestion of TCER and TCSTGE. Is this an expected behavior at V5R3?
I don't think I've run into it before. (Note: I did ensure that the file
I
created actually exists, and that it's over the right table, and so on. In
fact, it is listed as the second "access path considered" in CPI432C
message.)



Thanks,

Dennis E. Lovelady
AIM: delovelady MSN: fastcounter@xxxxxxxxxxxx
<http://www.linkedin.com/in/dennislovelady>
www.linkedin.com/in/dennislovelady --
"Everything is funny as long as it is happening to somebody else."
- Will Rogers



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.