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



We have a 720 and had the same problem last week.  It was caused by a user
query and it filled the box up overnight.  Our disk space is usually 68% but
goes up anyway overnight as we save to save file overnight.  It goes down
again when we save to tape and clear them. This meant that the problem was
compounded, the file doubled in size, plus the extra space used by the save
files.  The box filled to 100% and we got an error saying that the system
couldn't find 16 disks!  We deleted the file and save file IPL'd and it was
okay. The problem is at it's worst if a user joins a file to another with
what I think is called a Cartesian join, someone joins all the records in
one file to all the records in the other. For example all our files are
chained by company but all the records have a company number of '20'.  The
company number has to be in the join but there has to be another field also
like order number.

Jenny M.

-----Original Message-----
From: Scott Mildenberger [mailto:Smildenber@Washcorp.com]
Sent: 02 October 2002 15:01
To: 'midrange-l@midrange.com'
Subject: RE: Can a Query fill the system?


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

> -----Original Message-----
> From: pam@medisense.com [mailto:pam@medisense.com]
> Sent: Wednesday, October 02, 2002 7:57 AM
> To: midrange-l@midrange.com
> Subject: Can a Query fill the system?
>
>
> What could it be doing that would fill 60GB in 2 hours?
>
> Pam Phillips
>
>
_______________________________________________
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.