Re: Pick Release (ORD550)

With that kind of volume, you may be choking on sheer volumes of data.  Have you
tried purging the files?  There's a purging and archiving utility that works 
with
BPCS called ARCTOOLS that will help in getting the data out of the way of the
production database and into an archive environment.

Obviously, you would only want to archive older data, but if you could archive
from a year back (or tighter) you'd see a substantial improvement in response
times.  For inquiry purposes, selected logical files could be modified to allow
inquiry access to the archived data while keeping the order entry programs
humming.

Check out http://www.ziplink.net/~dcsoft

Or you can call me at (508) 435-8243.

+++++++++++++++++++
Purge and Archive Without Programming with ARCTOOLS (tm)
http://www.ziplink.net/~dcsoft
mailto:dcsoft@ziplink.net
P.O. Box 473
Ashland, MA  01721
Ph:   (508) 435-8243
Fax: (508) 435-4498

Dslic 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
+---