Re: RE: Performance on Unix platforms

[Richard Payne <Richard.Payne@xxxxxxxxxxxxxx>]

Title: Re: RE: Performance on Unix platforms

There is a performance issue with 6.04 running on OS/400 V4.2 and above. From 4.2 IBM tried to optimise the SQL access plan code. Unfortunately this had a major detrimental effect on our implementation (Particularly RMS500 and BIL501). An APAR was raised and after 2 attempts the problem was resolved with PTF's (I have a list if required).

-----Original Message-----
From: fkolmann@revlon.com.au [mailto:fkolmann@revlon.com.au]
Sent: 20 August 1999 3:03 AM
To: BPCS-L@midrange.com
Subject: Re: Performance on Unix platforms

We are running 6.04 on and AS400 DB2 box and we got similiar problems.
eg in ECM there is and 'orphan check' routine.  This process checks that every
record in the TPEB file has a matching TPEH (I think).  If you have orphan
checking turned on then this process is done for every order.  Our TPEB had
30000 records, processing 50 orders meant it did 1500000 reads.  The point I am
making is the utmost inefficiency of this process.  If one was to design a
function so that it would be as slow as possible then that is exactly what SSA
have done.  This entire scenario repeats all throughout the 6.04 processes.
They have used SQLs that require reading of entire files to process one record.
They have used SQLs that read every record in a file (IPP) when they will get
only 1 record for a SUM.
We are slowly replacing the SQLs with native AS400 DB gets etc.  In your case
you will need to see how you can use Indexes to file to help Oracal to get to
only those records it actually needs. I dont know about 6.1, I hear it has some
improvements.  We have gone thru at least 2 hardware upgrades and now are
looking at another $.5M to IBM.  Even so it will only make us twice as fast and
that does not really help.

Johan De Smet wrote:

> We are running BPCS version 6.0.0.4 on a HP9000 Unix platform with Oracle
> database and experience serious performance problems. Are their other people
> who have this problem also? Is their anyone who works with version 6.1 and
> how is the performance on that version?
>
> +---
> | 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
+---