RE: ORD900 - Order Purge

[Wes Reinhold <WesR@xxxxxxxxxxx>]

RUN A ACCES PATH ANALYZER SUCH AS CENTERFIELD.  WE HAVE HAD EXAMPLES OF
MONTH END JOBS GOING FROM 3-4 HOURS TO 20 MIN.

-----Original Message-----
From: RickCarter@holley.com [mailto:RickCarter@holley.com]
Sent: Monday, November 13, 2000 9:34 AM
To: BPCS-L@midrange.com
Subject: ORD900 - Order Purge


BPCS 6.1.01 Mix Mode As400 E730

We continue to have problems with the ORD900 Purge job taking days to run
and complete.  We converted to version 6.1 last November and have had
continued problems with the time it takes ORD900.  Last week we converted
to version 6.1.01 and as of now ORD900 has been running for a 25.0 hrs. and
has removed only 9000 records from ECL.  Does anyone know of a performance
booster for this job has it ran most of this 25.0 hrs on a dedicated
machine.

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@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 subscribe to this list send email to BPCS-L-SUB@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
+---