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


  1.  Home
  2. MIDRANGE-L
  3. September 2001

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.

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.