Re: V43 and BPCS Performance

[gmihajlo@xxxxxxxx]

Without the intention of questioning the usefulness of various PTFs
mentioned previously, I just thought some things should be mentioned with
regards to applying various SQL/performance PTFs:

Instead of ordering any individual SQL/performance related PTFs, it is
highly recommended, by both IBM and SSA, that entire SQL pack (SF99103) is
ordered, in order to avoid any problems caused by missing pre-requisite
and/or co-requisite PTFs. When you order PTF SF99103, you ensure that you
have ALL pre-reqs and co-reqs required, but also that you always get LATEST
version of SQL fixes, i.e. any superseding PTFs for PTFs you were told
would fix your problem.

Once you have installed them, you should look in IBM info APAR II11801 for
any PTFs listed in it for your OS/400 release and check whether they were
applied on your system as a part of SQL pack SF99103. If they were not, you
should order only those PTFs individually.

Experimenting with only some SQL PTFs (even though you have all of their
pre-reqs and co-reqs applied correctly), has shown to be quite risky in
many cases, primarily because of the complexity of the query optimizer
decision-making logic.

Regards,
Goran

---------------------- Forwarded by Goran Mihajlovic/SSA/US on 10/28/99
03:30 PM ---------------------------


"Mike Gillette" <mgillette@gssolutions.com> on 10/28/99 02:27:09 PM

Please respond to BPCS-L@midrange.com

To:   BPCS-L@midrange.com
cc:    (bcc: Goran Mihajlovic/SSA/US)
Subject:  Re: V43 and BPCS Performance




For V4R3 try SF57455, SF57245, SF56817, SF56394, SF56691, SF54847, SF51733,
SF57583, SF57456, SF57774, SF57780, and MF21190.

Good Luck!
----- Original Message -----
From: <gjayasun@hella.com.au>
To: <BPCS-L@midrange.com>
Sent: Wednesday, October 27, 1999 3:09 AM
Subject: V43 and BPCS Performance


>
>
>
>
> We had our system upgraded from V4R1 to V4R3 during the weekend. Since
then we
> found performance of the   BPCS applications
> degraded. Can anyone tell me whether there were any performace PTF's for
BPCS .
>
> Thanks in advance
>
> Gehan Jayasundera
> Hella Australia
>
>
>
> +---
> | 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
+---


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