Re: Pick Release (ORD550)

["Jeffrey L. Scott" <jlscott@xxxxxxxxxxxxxx>]

David,

There are a lot of things that you can look at to improve performance.  One
of the major increases in performance is to do a PRTSQLINF over the ORD550
program itself.  This will give you a summary of the SQL access plan and
times associated with each one.  You can then go in and create permanent
access paths based on the recommendations.  You can also run DB Monitor to
check which steps are taking a long time.  Based on that you can see what is
taking a while.

Jeff

At 08:07 PM 3/30/98 EST, you wrote:
>I have a client live on V6.0.02 PLF Mixed Mode AS/400.  They pick about 5000
>order lines per / day and have typical customer orders of 150 - 200 order
>lines.  They have multiple, concurrent users generating pick slips through
>Pick Release (ORD550) throughout the day.  Response time could be better.  Has
>anyone else faced this issue and if so, any suggestions?
>
>Thanks in Advance,
>
>David Slicker
>DS Solutions
>+---
>| This is the BPCS Users Mailing List!
>| To submit a new message, send your mail to BPCS-L@midrange.com.
>| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: dasmussen@aol.com
>+---
>

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---