Re: V5R3 Performance Issue -- MIDRANGE-L

any chance a logical view has been deleted that the sql used, or
that the select or order by in the sql stmt has changed? Perhaps
not a v5r3 issue? Did anything change in your memory pools?
Settings for cache?
jim

----- Original Message ----- 
From: <Rick.Chevalier@xxxxxxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Wednesday, May 18, 2005 12:12 PM
Subject: RE: V5R3 Performance Issue


> Can't really give you the reason but I'm not authorized to the command.
I'm on your side and it would have come in handy several times but I can get
into enough trouble without complaining about my lack of authority.
>
> Rick
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
> Sent: Wednesday, May 18, 2005 9:57 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: V5R3 Performance Issue
>
>
> What, if you type in WRKPTFGRP it tells you to get bent???  Or is it
> really a policy that you are not even supposed to execute that command?  I
> don't want to get you in trouble but I can't see the business case for
> that.  Unless it's something weird like "Cool, Americredit isn't running
> ptf SI......  That means I can go to their website do this and DOS their
> system."
>
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> <Rick.Chevalier@xxxxxxxxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 05/18/2005 09:43 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> <midrange-l@xxxxxxxxxxxx>
> cc
>
> Subject
> RE: V5R3 Performance Issue
>
>
>
>
>
>
>
> Yea, I should have included that in the original post.
>
> I can't look at the PTF's but the operations group is pretty good at
> keeping us current, especially when we have issues like this.  I would
> presume we are current.
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
> Sent: Wednesday, May 18, 2005 9:07 AM
> To: Midrange Systems Technical Discussion
> Subject: Re: V5R3 Performance Issue
>
>
> Sorry.  Have to give the standard first question.  What does WRKPTFGRP
> show?
>
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> <Rick.Chevalier@xxxxxxxxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 05/18/2005 08:51 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> <midrange-l@xxxxxxxxxxxx>
> cc
>
> Subject
> V5R3 Performance Issue
>
>
>
>
>
>
>
> 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>>
>
> Enterprise Solutions
> Ext. 57178
>
>
>
> 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.--
> 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.
>
>
> --
> 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.
>
> -- 
> 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.
>
>
> -- 
> 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.
>
>
>
> -- 
> 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.
>
>