Re: ACR900 Job

["CompTech Solutions, Inc." <cts@xxxxxxxxxx>]

I'd be interested in your recommendations.  I am in the process of modifying
the ACR900 job stream now.

-----Original Message-----
From: GaryWWest@aol.com <GaryWWest@aol.com>
To: BPCS-L@midrange.com <BPCS-L@midrange.com>
Date: Tuesday, November 17, 1998 1:38 PM
Subject: Re: ACR900 Job


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