Re: V5R3 Performance Issue

[Evan Harris <spanner@xxxxxxxxxx>]

Hi Rick

I've seen three systems with problems that sound similar to yours that 
occurred after V5R3 upgrades. 2 were running BPCS (different versions) and 
1 was running JDE. In each case the problem seems to relate to SQL but only 
for certain jobs. The latest DB Groups have helped and we have had a couple 
of PTF's advised for specific issues via IBM (don't have the numbers handy 
right now). We are still working through this for one of the BPCS systems 
but I seem to recall the other two systems are now mostly OK.

You may want to log a call with IBM, but you will need the PTF Group 
details to do that :)

Regards
Evan Harris


> We installed V5R3 a couple of weeks ago.  Since then one of our nightly 
> critical path jobs has more than doubled in run time.  Operations has been 
> working with another team member on finding the issue but they haven't 
> been successful yet.  It appears to be in an RPG program with embedded 
> SQL.  I know there is at least one other job using QM queries that has 
> also seen a two fold increase in run time.  It's not in the critical path 
> so it isn't an issue at this time.  Has anyone else experienced anything 
> like this with V5R3?
>
> Rick Chevalier
>  <<ole0.bmp>>