Re: Finding reason for high temp storage maximum -- MIDRANGE-L

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

On Thursday 04 December 2003 20:38, ouuch@xxxxxxxxxxx wrote:
> On 4 Dec 2003 at 18:03, Martin Rowe wrote:
> > We have lots problems with these sort of jobs, so I wrote this -
> > http://www.dbg400.net/download/extras/CHKTMPSTG.txt - to help
> > pinpoint them. It's a simple RPGLE program that lists jobs using over
> > 50Mb temp storage. I've put in a background job[1] now, that
> > automatically holds jobs using over a preset amount of temp storage,
> > as we had a rogue SQL job use over 30Gb recently (which did push us
> > over 90% DASD).
>
> Absolutely lovely. Will be first thing tomorrow I'll compile and
> adjust. You're a champ!

Hope you like it :) The background monitor that can take pre-emptive 
action is now on my site - http://www.dbg400.net/extras.html#dasdmon

Regards, Martin
-- 
martin@xxxxxxxxxx  AIM/Gaim: DBG400dotNet  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  / \

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.