Re: BPCS 6102 Performance

["Clare Holtham" <Clare.Holtham@xxxxxxxxxxxxxx>]

Hi Bill,

Another thought - since you just upgraded BPCS it is the programs that have
changed, not the data. The SQL Optimizer stores its Access Plan with the
program object. So it will need to recreate all the access plans. To check
whether this is happening, you can use PRTSQLINF on each of the programs you
mention (making sure you get the correct environment and library). This will
tell you when the access plans were created, as well as giving other clues.

Also, Al is right you need the Database Group PTFs from IBM, latest version.
To check that you have these, look for a data area called SF99xxx where xxx
relates to your OS/400 version - if I remember this could be 105 for V4R5.
In the data area it will tell you which version you have, or no data area
means no Group PTFs. These contain the very important SQL PTFs!

If the programs are slow because it is recreating access plans, then the
problem should go away.....although a performance review is recommended
after a BPCS or OS/400 upgrade.

good luck,

Clare

Clare Holtham
Director, Small Blue Ltd - Archiving for BPCS
Web: www.smallblue.co.uk
IBM Certified AS/400 Systems Professional
E-Mail: Clare.Holtham@btinternet.com
Mobile: +44 (0)7960 665958
----- Original Message -----
From: "Moy, Bill" <bill.moy@appliance.invensys.com>
To: <bpcs-l@midrange.com>
Sent: Friday, December 20, 2002 12:01 AM
Subject: BPCS 6102 Performance


> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> Dear BPCS Expert,
>
> We just upgraded from BPCSv6.1 to BPCSv6102 (mix mode OS400 V4r5) and the
> performance is horrible. It is taking us minutes to bring up programs like
> PUR500, CST100, PUR640..etc.  Any suggestions to overcome this issue will
be
> greatly appreciated.
>
> Regards
> Bill Moy
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
> or email: BPCS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>