Re: ACR900 - too long

Look in archives for sql tuning in general. Lots of advice.

In a nutshell; use IBM command PRTSQLINF to look at long running sql statements.
Also - watch the job while it runs and find out which statement it is 
"sticking" on.
Consider indexes for long running sql's.

Not the end  all to end all's, but may bring you to a solution.


-----Original Message-----
From: bpcs-l-bounces+ssegerstrom=intermatic.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+ssegerstrom=intermatic.com@xxxxxxxxxxxx]On Behalf
Of Al Mac
Sent: Wednesday, March 15, 2006 7:45 AM
To: SSA's BPCS ERP System
Subject: Re: [BPCS-L] ACR900 - too long


We run SYS120 and other BPCS reorg each weekend after a backup when no one
on BPCS.  Do you run some BPCS reorgs regularly?

ACR900 is lightning fast for us, it is INV900 which can take forever,
depending on size of ITH file.

When you fill in screen of end fiscal tasks, what it is to do, have you
changed that, or person who does it?  Or is this an automated task where
the parameters today may not be identical to years ago?

>Hi all,
>BPCS v 6.0.04
>we are unlucky with ACR900 - month end close. Before 3 years it took 1700
>s CPU time, now it consumes about 8000 s.
>Have you any tip how to improve it?
>
>We don't use fields like corporate parent, promotion cust.nr., sales
>organization parent and so on in RCM - they are filled with RCM.CCUST. I
>think ACR900 spends much time with working with these "superior" customer
>levels.  Is there a way here?
>I don't think we have much more data there, but time keeps on rising.
>Thanks for your advice
>           oTTo


--
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: SSegerstrom@xxxxxxxxxxxxxx

-