Re: ACR900 Job

["Rick J. Carter" <rickcarter@xxxxxxxxxx>]

Gary, I appreciate your response back on the ACR900 program but I've not 
been able to find the BMR for this.  SSA says there's been no BMR for 
ACR900.  IF you happen to know the BMR number I would appreciate it.  I also 
searched OGS and did not get any hits on ACR900 in the BMR List.
 ----------
From: GaryWWest
To: BPCS-L
Subject: Re: ACR900 Job
Date: Tuesday, November 17, 1998 12:38PM

In a message dated 11/17/98 11:01:08 AM Central Standard Time,
rickcarter@holley.com writes:

> We have a tremendous performance problem when running this job.
>
>  AS/400  E620  RISC    V4R2M0
>  BPCS MixMode   V6.0.02
>
>  This job has been taking upward  of 80 to 90 hrs to run when only running 

>  once.  per month.
>
>  Has anyone else experienced this kind of performance issues.
>

You bet. There is a horrible SQL statement that destroys perfromance. It can
be corrected easily enough with a minor code change, however SSA has a BMR 
for
the ACR900 program.

If you are using CDM,  ACR900 will also call a CDM program (CDM600B if I
remember correctly), which has performance problems that I do not think SSA
has a BMR for yet. It required an minor change to an SQL statement which I 
can
provide if you need it. Let mo know.

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