Re: query killing system

Blatant product suggestion in response to stated need--

I recently did preliminary development of such a product for Centerfield
Technology, called disk/HUNTER. You can see it on their site,
www.centerfieldtechnology.com. Look at the insure/Tools link. It regularly
checks disk free space. If reduction exceeds your configured threshold,
messages and/or reports are generated that attempt to tell you what jobs
and users and objects caused the excess usage.

At 04:29 PM 3/22/02 +0000, you wrote:

>Mike,
>      You could try monitoring disk/storage usage at regular intervals, or
>buy software to do this & page you.
>
>We have a morning menu that issues this command below to show ASP threshold
>errors;
>
>DSPLOG ??PERIOD((*AVAIL *CURRENT) (*AVAIL *CURRENT))
>        ??OUTPUT(*)
>        ??MSGID(CPI0953 CPI0954 CPI1138 CPI1139)
>
>I check this twice daily & if an ASP has exceeded threshold - or overflowed
>into the system ASP,
>it lists these occurences.
>
>I then have to run a few utilities to identify the overflowed objects &
>challenge the programmer
>to justify the size or clear it down.
>
>It is Always a large outfile... & they have always taken too large a subset
>of a live file.
>Just as a program dump here is almost always subscript-out-of-range.
>What Are they teaching them these days ?
>"If your car breaks down, just put it in your pocket & carry it home " ?
>
>Fiona
>
>_______________________________________________
>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.