Re: Performance solutions through hardware -- BPCS-L

Please accept big THANK-YOUS for everyone who responded to my ECM problem.
I have yet to implement the solutions, and I will let you know how I go.

Apologigies to anyone I offend in advance for the following.

<SOAPBOX MODE ON>
Hey,  Just a minute here.
Do you have any idea how much we have spent on hardware upgrades for BPCS V6
already.
It really boggles the mind.
I am not sure if we are an AS400e box or not.  Certainly we are a RISC box mdl
640-2237.
We are still running PRMS(our previuos system) and where jobs took hours to
run this new donk is running them in minutes.
In the old PRMS system had slow order loads, allocations, MRP , etc. etc.  now
it is so fast that processing time is no longer part of the equation,  AND WE
ARE REPLACING PRMS WITH BPCS THAT NOW TAKES
2 HOURS TO LOAD 120 CUSTOMER ORDERS.
7 HOURS to update nightly  GL transactions

Now I know just how much I/O and resources the PRMS and SALESTRACKER jobs
needed,
BPCS is taking ORDERS OF MAGNITUDE more resource.
This is only possible way this can be the case is for SQL to be reading the
database so inefficently that
TO UPDATE A SINGLE RECORD,  THE ENTIRE FILE IS BEING READ.
THE ENTIRE FILE IS THEN READ THOUSANDS OF TIMES IF THERE ARE THOUSANDS OF
RECORDS TO UPDATE.

Please shoot me down in flames if I am wrong.

SalesTracker loads that took half the night now take half an hour.  We have
another site running on our AS400 in the S36ee enviromnent.  The old S36 took
4 hours to do BPCS V4 MRP now it takes 5 MINUTES their Month-End takes 7
minutes Day End is negligible,  boy are they in for a shock when we cut them
onto V6.
We have thrown so much hardware at BPCS that IT IS NOT FUNNY.

<SOABOX MODE OFF>

<NORMAL MODE RESTORED>

Mac are you saying that this is just IBMs way of getting us to upgrade. ?:)


MacWheel99@aol.com wrote:

> Here's an idea for folks doing a BPCS version upgrade, in which there is a
> strong suspicion that a bigger box is needed & that management might be
> downplaying expectations due to sticker shock - hope you don't mind me
> passing on this news item.
>
> IBM GUARANTEES ERP PERFORMANCE ON AS/400E
> http://www.news400.com/nwn/StoryBuild.cfm?ID=705
> IBM is so confident in the performance of the AS/400e for enterprise
> resource planning (ERP) that it will upgrade for free any new system
> that doesn't perform as predicted.

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