Re: Pick Release (ORD550)

David,

Agreed with Jeff 100%.  You might also want to look into using SETOBJACC to
place frequently called modules (like SYS003B, SYS900B, SYS903B, SYS006B, and
SYS007B, etc.) into a shared memory pool.  I realize the latter two examples
won't help a batch program, but they _will_ improve interactive response.
With _thorough_ analysis and enough memory, files like ZPA can be included as
well...

In a message dated 98-03-31 10:09:02 EST, you write:

> 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?

Regards!

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@aol.com

"I wish people who have trouble communicating would just shut up." -- Tom
Lehrer
+---
| 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
+---