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

RE: Can a Query fill the system?

On Wednesday 02 October 2002 4:51 pm, pam@medisense.com wrote:
> >A query can be creating temporary files that can indeed use up a lot
> > of space.  I have seen a machine halt due to running out of disk
> > space due to a runaway query.  When the job is running you can look
> > at how much temporary storage it is using to determine if this is
> > happening.
> >
> >Scott Mildenberger
>
> I found it under Job Run attributes. Thanks.

Hi Pam

You may be interested in a routine that identifies jobs using large
temporary storage. I posted the code here in April -
http://archive.midrange.com/midrange-l/200204/msg00073.html

Regards, Martin
--
martin@dbg400.net  jamaro@firstlinux.net  http://www.dbg400.net    /"\
DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open    \ /
Source free test environment tools and others (file/spool/misc)     X
Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news  / \

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
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.