|
ROB, That doesn't work because V4R2 doesn't use the QAQQINI file. Ron > -----Original Message----- > From: rob@dekko.com [SMTP:rob@dekko.com] > Sent: Friday, September 14, 2001 3:56 PM > To: midrange-l@midrange.com > Subject: RE: Can't find QAQQINI > > > Try doing a DSPPFM on QAQQINI on both machines and compare the > differences. > > Rob Berendt > > ================== > A smart person learns from their mistakes, > but a wise person learns from OTHER peoples mistakes. > > > > "Klein, Ron" > <ron.klein@brctsg.c To: > "'midrange-l@midrange.com'" <midrange-l@midrange.com> > om> cc: > Sent by: Fax to: > midrange-l-admin@mi Subject: RE: Can't find > QAQQINI > drange.com > > > 09/14/2001 03:29 PM > Please respond to > midrange-l > > > > > > > Rob, > That is the whole problem, it is sort of a runaway job. But, as soon as > the > job is ended it goes back to 41% disk utilization. It is somewhere within > this SQL that the jobsucks up all the disk. We are trying to do some > analysing of the statements but that is no easy task. We are trying to > see > why the SQL does not like the way the statement is built and see if we can > change the way it is constructed. We have a report modeler that builds > these SQL statements and then passes parts of those statemnts to SEQUEL as > parmameters and then SEQUEL finishes putting the statement together and > executes the SQL. Its messy, I printed out the SQL statement and it is > about 2 1/2 pages long. > > By the way it does work on our box and we are at V4R2. > > Ron > > > -----Original Message----- > > From: rob@dekko.com [SMTP:rob@dekko.com] > > Sent: Friday, September 14, 2001 3:19 PM > > To: midrange-l@midrange.com > > Subject: RE: Can't find QAQQINI > > > > > > If they were telling you the truth, based on recent data; they had a > heck > > of a runaway job there. Better start cleaning up disk space. You can > > change the threshold from 90% by the following: > > STRSST > > 3. Work with disk units > > 2. Work with disk configuration > > 3. Work with ASP threshold > > > > I would change it back down after the crisis. Actually I prefer 80%. > > This > > gives you a little more time to react and order more disk space. > > > > Rob Berendt > > > > ================== > > A smart person learns from their mistakes, > > but a wise person learns from OTHER peoples mistakes. > > > > > > > > "Klein, Ron" > > <ron.klein@brctsg.c To: > > "'midrange-l@midrange.com'" <midrange-l@midrange.com> > > om> cc: > > Sent by: Fax to: > > midrange-l-admin@mi Subject: RE: Can't > find > > QAQQINI > > drange.com > > > > > > 09/14/2001 02:44 PM > > Please respond to > > midrange-l > > > > > > > > > > > > > > You are right they should be in Gigs and Not Megs. No LPARs, Multi ASPs > I > > have to check on. The 41% is what is being reported as being used > before > > this SQL program is run. > > > > Ron > > > > > -----Original Message----- > > > From: rob@dekko.com [SMTP:rob@dekko.com] > > > Sent: Friday, September 14, 2001 2:22 PM > > > To: midrange-l@midrange.com > > > Subject: RE: Can't find QAQQINI > > > > > > > > > There has to be something wrong with your numbers. You can't even buy > > > disk > > > drives that only hold 64MB. > > > > > > Let's assume that this number is GB instead of MB. > > > > > > Are you running LPAR's? > > > > > > Are you running multiple ASP's? > > > > > > Where are you getting that their disk space is at 41% when this says > > > otherwise? > > > > > > > > > Rob Berendt > > > > > > ================== > > > A smart person learns from their mistakes, > > > but a wise person learns from OTHER peoples mistakes. > > > > > > > > > > > > "Klein, Ron" > > > <ron.klein@brctsg.c To: > > > "'midrange-l@midrange.com'" <midrange-l@midrange.com> > > > om> cc: > > > Sent by: Fax to: > > > midrange-l-admin@mi Subject: RE: Can't > > find > > > QAQQINI > > > drange.com > > > > > > > > > 09/14/2001 02:03 PM > > > Please respond to > > > midrange-l > > > > > > > > > > > > > > > > > > > > > The exact Message is CPF0907, it says that the threshhold has been > > > exceeded, > > > that 64 Meg is the capacity, that 57.1 Meg is used, the threshold is > > 90.00 > > > percent and that auxillary storage of 9.9999 meg is available. > > > > > > Ron > > > > > > > -----Original Message----- > > > > From: rob@dekko.com [SMTP:rob@dekko.com] > > > > Sent: Friday, September 14, 2001 1:38 PM > > > > To: midrange-l@midrange.com > > > > Subject: Re: Can't find QAQQINI > > > > > > > > > > > > Make sure you get the exact message id that they are getting. > Several > > > > people on this list have misunderstood various threshold messages. > > Once > > > > you get the message id then you can do the DSPMSGD to get the > > > description. > > > > I think we've had this threshold message battle just in the last > week > > or > > > > two. > > > > > > > > Rob Berendt > > > > > > > > ================== > > > > A smart person learns from their mistakes, > > > > but a wise person learns from OTHER peoples mistakes. > > > > > > > > > > > > > > > > "Klein, Ron" > > > > <ron.klein@brctsg.c To: > "''MIDRANGE-L'" > > > > <MIDRANGE-L@midrange.com> > > > > om> cc: > > > > Sent by: Fax to: > > > > midrange-l-admin@mi Subject: Can't > find > > > > QAQQINI > > > > drange.com > > > > > > > > > > > > 09/14/2001 01:21 PM > > > > Please respond to > > > > midrange-l > > > > > > > > > > > > > > > > > > > > > > > > > > > > We have recently run into this error CPI433A, Unable to retrieve > query > > > > options file QAQQINI. I looked in the archives and it tells me that > > > > merely > > > > duping it to QUSRSYS is all I need to do. That is fine, I can do > > that. > > > > However, what it doesn't tell me in the archives is why do I need to > > do > > > > this > > > > and with the push from IBM to use SQL, why have they not placed the > > > > template > > > > there themselves instead of the customer having to do it themselves. > > > > > > > > The reason that this just came up: we just shipped for BETA testing, > a > > > > rewrite of a system and that system uses RPGIV ILE and SQLRPGLE > > > > extensively. > > > > One particular client is having a problem running one of the > programs > > > and > > > > eventually gets error messages that the threshold on storage has > been > > > > exceeded. Their disk space is at 41%, they are on a 820, and they > are > > > on > > > > V4R5. So we are chasing error messages. And since this is the > first > > > > message to come up, I thought I should deal with it first. > > > > > > > > TIA > > > > _______________________________________________ > > > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) > mailing > > > > list > > > > To post a message email: MIDRANGE-L@midrange.com > > > > To subscribe, unsubscribe, or change list options, > > > > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > > > > or email: MIDRANGE-L-request@midrange.com > > > > 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@midrange.com > > > > To subscribe, unsubscribe, or change list options, > > > > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > > > > or email: MIDRANGE-L-request@midrange.com > > > > 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@midrange.com > > > To subscribe, unsubscribe, or change list options, > > > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > > > or email: MIDRANGE-L-request@midrange.com > > > 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@midrange.com > > > To subscribe, unsubscribe, or change list options, > > > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > > > or email: MIDRANGE-L-request@midrange.com > > > 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@midrange.com > > To subscribe, unsubscribe, or change list options, > > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > > or email: MIDRANGE-L-request@midrange.com > > 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@midrange.com > > To subscribe, unsubscribe, or change list options, > > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > > or email: MIDRANGE-L-request@midrange.com > > 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@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > or email: MIDRANGE-L-request@midrange.com > 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@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > or email: MIDRANGE-L-request@midrange.com > 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.