× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.