× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi,

I've been making an effort to go through our advised indexes and add them to help our system out. However I don't understand why after putting the index out there it is not being used and the system continues to advise for that very index I just added.

In this particular case, the SQL is in an embedded SQL RPG program.
When I copy that SQL (an update) and run it in STRSQL with STRDBG on, I see that it uses the new index. (I thought it might be hanging onto a MTI, as was the case in a previous index implementation). However when the program runs, it's not using the new indexes (and as I said, is asking for them) - and I see the TimesAdv value go up in SysIxAdv.

A little background: we have clients and each client has their own library. 4 of our clients run this particular process. For one of them it did use the new index, for the others it didn't.
I recreated the module & service program that has the embedded SQL in it (which is used by all clients).

The last time I put an index in that wasn't getting used (due to a MTI being used), the issue got resolved by an IPL. But in that case I could see it using the MTI when I ran STRSQL with debug mode on.
Other notes: It's not a library list issue. These are actual indexes (vs being logical files). We're at v7.2.

Short of attempting an IPL, does anyone have any suggestions?

Thanks,

Kurt Anderson
Sr. Programmer/Analyst - Application Development, Service Delivery Platform
[cid:image002.jpg@01CD16F9.25D27630]
web: www.customcall.com<http://www.customcall.com/> | email: kanderson@xxxxxxxxxxxx<mailto:kanderson@xxxxxxxxxxxx>

A Division of Enghouse Systems Ltd.<http://www.enghouse.com/> (TSX:ESL)

Join us for the 2015 CustomCall Users Forum, Oct 7-9 in Madison, WI. For more information or to register - click here<http://events.r20.constantcontact.com/register/event?oeidk=a07eatvdpg47dd505f3&llr=pmm6kddab&showPage=true>.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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

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

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.