RE: Can a Query fill the system?

["Mauger, Jenny" <Jenny.Mauger@xxxxxxxxxxxx>]

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.