RE: V5R3 Performance Issue

I seriously doubt that an index was deleted.  Once a file, index, view, etc, is 
created they tend to stay around.  The files in use are for the application I 
support so I'm sure I would have heard something if one was deleted.  There is 
also a second embedded SQL program that has experienced an increase of run time.

I can't say about the cache.  Memory pools are changed prior to nightly 
processing by a CL program so that shouldn't have changed.  I do know that 
operations has been watching it almost every night and has been making 
adjustments to try and improve the run time.  Any change to cache would 
probably have been caught and if not it may be impossible to tell at this point.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Jim Franz
Sent: Wednesday, May 18, 2005 11:32 AM
To: Midrange Systems Technical Discussion
Subject: Re: V5R3 Performance Issue


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


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