Re: BPCS Performance GUI - after Operating System upgrade -- BPCS-L

Some general tips:

If you experience BPCS performance changes after upgrading your OS/400
release, please report those to both the SSA GT and IBM Support Centers,
after first checking Info APAR II12963 and making sure you have all listed
PTFs applied to your system. There have been some reported issues, which can
be resolved via PTFs and occasionally some new access paths, due to
optimiser behavior changes between OS releases.

Please be prepared to give details of the programs involved and changes in
times you have noticed.

If you have any performance data which you saved from prior to the OS
upgrade, that is also helpful for comparison. For instance, a backup of the
program objects taken on your old OS/400 release will show the SQL access
plans saved with that objects, and this will show the access paths and join
methods used by the SQL optimiser prior to the upgrade (via PRTSQLINF).

Restore the object(s) in question to separate library (from the backup
tape), and run the PRTSQLINF command on them (do NOT run them on the new OS
level before you do this!). You can compare this information to a PRTSQLINF
of the program after running on the new OS level, and see if the access
method has changed to the detriment of the program performance. This could
help identify a PTF or workaround to the issue.

If a new problem not covered on the Info APAR II11293 is discovered, please
be sure to ask the SSA GT or IBM Support Center to add the resulting PTF or
workaround to the Info APAR.

Thanks,

Genyphyr Novak
SSA GT

----- Original Message -----
From: <RickCarter@holley.com>
To: <bpcs-l@midrange.com>
Sent: Thursday, November 29, 2001 6:29 PM
Subject: BPCS Performance GUI - after Operating System upgrade


> As400 E730  Mix mode 6.1.01
> Recently upgraded operating System on AS400 from V4R4 to V4R5.  I can't be
> sure this happened after the upgrade due to the frequency of when the jobs
> run but it's possible that my GUI jobs slowed after the upgrade.   THere
> were a few weeks after the upgrade with no complaints but no one can seem
> to remember whether any of the GUI posting jobs were run during that
> period.
>
> We use to have 20 second response time and now it appears to be 4-6
minutes
> consistently.
>
> I've misplaced the link to IBM showing the various  PTF levels and SQL
> updates that are recommended for BPCS with certain Operating Systems.  I
> suspect I need some PTF or upgrade patch for SQL or something to regain
the
> performance I had prior to the upgrade.  Could someone send me the link or
> information on this.
>
> A few weeks ago I received seveal messages about clearing all the record
> locks, log files, etc as that doesn't appear to be my problem as I have
> some of those functions built into my nightly schedule already.
>
> _______________________________________________
> 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.
>
>