Re: Can a Query fill the system?

[vhamberg@xxxxxxxxx]

Pam

Please pardon the blatant commercial. We have a tool (I
wrote most of it) that could warn you of this situation
sooner than the "serious storage" message does - a
realtime monitor of disk space. If the runaways are
frequent, it might be helpful. It's called disk/HUNTER,
you can see info at <www.centerfieldtechnology.com>. It
sends messages with IDs, so things like Robot/CONSOLE
and MessengerPlus could monitor for the condition and
give you good notice.

It's not too expensive, I think. A few thousand ($4000
for P40?, maybe).

Regards

Vern Hamberg
507 287-8119 x111
>
> I'm running a Model 720 with 400 GB, which is usually about 75% full. Last
> night, it suddenly went to 90%. When I dialled in to check it, the only
> suspicious job I could find was a query that had been running for over three
> hours and still hadn't created output. So I killed it, and like magic, I was
> back at 75%.
>
> Now that I've had a chance to look at yesterday's performance graphs, I find
> that three times, this query and similar ones filled the disk to the
> threshhold in the course of two hours. These queries link four files, one of
> which is huge. Clearly, there's something wrong with the joins. I've seen this
> sort of thing cause queries to run for ages to no effect, but I've never seen
> them chew up disk space like that.
>
> 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.
>