Re: [BPCS-L] BPCS 604 x V5R2 OS/400

[Al Mac <macwheel99@xxxxxxxxxxx>]

Several suggestions
   * 1. Note that as OS/400 adds more stuff, it needs more hardware gas to 
sustain the same performance, in which from time to time you may need to 
consider getting more 400 memory (for cache) or a faster processor.
   * 2. One reason why some BPCS programs go slow is the sheer mass of 
records in files being accessed ... like we have 1 year of inventory 
history, but 99% of our users only need to see the last few weeks worth ... 
there are archiving solutions such that you have access to the data you 
need, but not have millions or records clogging up inquiries.
   * 3. We took a hard look at what we were running interactive vs. batch 
when our BPCS 405CD moved from Os/400 V4 to V5 and moved some interactive 
functions to batch.
   * 4. There is such a thing as studying the reccommendations given by 
SQL messages when you running programs that are going slow, and thanks to 
that adding some more logicals that will help those jobs run more efficiently.
   * 5. IBM pricing is pushing pricing on certain kinds of processing way 
up relative to other kinds of processing ... there is programming 
modification that can be done to move workload from the artificially high 
IBM pricing to the artificially low IBM pricing ... not my favorite 
solution, but I just giving you alternatives.
:
> Hi Everybody,
>
> We'd changed the OS/400 version from v5r1 to v5r2 and after that our BPCS
> programs had a performance problem in several applications.
>
> We are in BPCS 6004 MM.
>
> Did anybody have the same problem ?
>
> We already saw the IBM APAR, PTF SI14837 apllied, and DB PTF is in 17 level.
>
> Thanks in advance.
>
> Renato