Re: ACR900 Job

[GaryWWest@xxxxxxx]

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