|
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. > >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.