Re: Sanity check

[Chuck Lewis <CLEWIS@xxxxxxxxxx>]

Roger,

If it used to work fast, then this wouldn't explain it BUT if you aren't sure it
could be that the file has REALLY grown in size (?) and a poorly written program
is doing a SETLL and READ rather than a SETLL & READE to the key and kicking out
?

Chuck

Roger Boucher wrote:

> I have a user (controller) who swears up and down that an invoice inquiry on
> our legacy system (an old AS/400 kept around for inquiry purposes only) is
> taking much longer than it used to.  I tested it and found that it works
> quickly if record is found and takes about 30 seconds when record not found.
> The problem point (debug) seems to be a SETLL statement on a multi-record
> format LF38.  The logical is not damaged, the physicals on which it is based
> are not damaged.  The Edit Rebuild of Access Paths screen shows nothing
> pending.
>
> Does anyone know anything else to look for?
> Or Is this just a case of selective memory on the part of our friendly
> neighborhood user?
>
> Any help would be appreciated...
> Thanks.
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---