RE: V5R3 Performance Issue

Operations has been talking to IBM.  Hopefully they'll resolve it soon.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Evan Harris
Sent: Wednesday, May 18, 2005 3:31 PM
To: Midrange Systems Technical Discussion
Subject: Re: V5R3 Performance Issue



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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.