Re: Index/LF question

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

David,

As a new SQL index ( or DDS logical ) for that matter would only
effect SQL statements or an RPG program that used them directly (via a
f-spec), I'd have to say you are incorrect in saying that no other
part of the job used SQL ( and/or for example OPNQRYF, query/400 or
query manager reports)

Otherwise there's something else coming into play.

Charles

On Tue, Sep 23, 2008 at 4:50 AM, David FOXWELL <David.FOXWELL@xxxxxxxxx> wrote:
> Hi,
>
> I had a complaint that a job was taking nearly 3 hours to run at night in certain circumstances. In fact I'd added an SQL request on a PF without realizing the consequences. The job already took a long time before I added it, maybe half as long.
>
> Anyway, I used the iNav index advisor to create the necessary index. Now, the job runs in 5 minutes! I am wondering why it is so much faster than before I added the lengthy SQL request?
>
> I can't find any other SQL references in the job. RPG programs are using the PF with a CHAIN operation. I have replaced the index I created with iNav with an LF and it runs just as fast. The same PF with about 2 million records now has 7 LF.
>
> Also, as my new LF is only currently used in my SQL request, there are no references it. How should I prevent someone from cleaning up and removing it ?
>
> TIA.
> --
> 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.