Re: ACR900 - too long

Hello, 

If you are on BPCS CD, the suggestion mentioned below by Davide is
irrelevant, as there is no SQL in that release of BPCS (unless you put
some in yourselves), it only works SQL releases. Have you checked for
duplicate records in all the affected files? Sometimes if these are
present it will cause jobs to run a lot longer and have abnormally high
I/O counts on the affected or related files. I suppose if you had SSA
support you would have already called this in to the support center for
analysis? So, if you do not have support and you do not have duplicate
records, you can always try using the AS/400 performance tools to
analyze the program to find the bottle neck, do some analysis and try to
change the code to suit yourselves. Or hire an SSA consultant to come
out to analyze the program for you to improve it.

Thanks,
Genyphyr Novak
Senior System Software Engineer
SSA Global R&D

-----Original Message-----
From: bpcs-l-bounces+genyphyr.novak=ssaglobal.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+genyphyr.novak=ssaglobal.com@xxxxxxxxxxxx] On
Behalf Of bpcs-l-request@xxxxxxxxxxxx
Sent: 18 March 2006 19:00
To: bpcs-l@xxxxxxxxxxxx
Subject: BPCS-L Digest, Vol 4, Issue 65

Send BPCS-L mailing list submissions to
        bpcs-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/bpcs-l
or, via email, send a message with subject or body 'help' to
        bpcs-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
        bpcs-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific than
"Re: Contents of BPCS-L digest..."


*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

   1. Re: ACR900 - too long (Davide Roveda)


----------------------------------------------------------------------

message: 1
date: Sat, 18 Mar 2006 17:22:13 +0100
from: "Davide Roveda" <Davide.Roveda@xxxxxxxxxxxxx>
subject: Re: [BPCS-L] ACR900 - too long

Hello

The way to make a real check of SQL performance is: Let Iseries do for
you: 

In this way:


-----Original Message-----
From: bpcs-l-bounces+davide.roveda=ssaglobal.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+davide.roveda=ssaglobal.com@xxxxxxxxxxxx] On
Behalf Of DeeDee Virgei
Sent: gioved? 16 marzo 2006 14.29
To: SSA's BPCS ERP System
Subject: Re: [BPCS-L] ACR900 - too long

That really isn't that many records.  We have 1,041,661 RAR records and
our ACR900 job ran between 5 and 6 minutes last close...  We are on
V4.05 CD, haven't added any user logicals over the RAR, haven't
customized ACR900 (Al, we did remove the RGZPFM ITH command from INV901C
to make it run much faster).  ACR900 use to run a lot longer (around an
hour I think) before we got our i5 (520) hardware; prior iSeries was a
270...  

My guess is that it may be the release of BPCS and/or an older iSeries
that may be causing it to run so slow...  Just a guess; hope this helps.


Best Regards,

DeeDee Virgei
Project Leader

Nelson Stud Welding, Inc.

-----Original Message-----
From: bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx] On
Behalf Of Otto Hason
Sent: Wednesday, March 15, 2006 11:45 PM
To: SSA's BPCS ERP System
Subject: Re: [BPCS-L] ACR900 - too long

Hallo Steve,
there are about 150000 records in RAR, 2 deleted (today).
Otto
  ----- Original Message -----
  From: Steve Segerstrom
  To: SSA's BPCS ERP System
  Sent: Wednesday, March 15, 2006 8:58 PM
  Subject: Re: [BPCS-L] ACR900 - too long



  How many records are on the rar file?

  -----Original Message-----

  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.