Re: Finding reason for high temp storage maximum

[rob@xxxxxxxxx]

I tried using iSeries Navigator, Work Management, Active Jobs, View, 
Customize this view, Columns, but temporary storage was not in the 
selection list.  Bummer.

Rob Berendt
-- 
"All creatures will make merry... under pain of death."
-Ming the Merciless (Flash Gordon)




Martin Rowe <martin@xxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/04/2003 01:03 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange-L" <Midrange-L@xxxxxxxxxxxx>
cc

Fax to

Subject
Re: Finding reason for high temp storage maximum






On Thursday 04 December 2003 08:44, oliver.wenzel@xxxxxxxxxxxxxxxxxxxxxxx 
wrote:
> Hiya,
>
> on our 820 the wrksyssts shows a very high temp storage maximum number:
> 35247M.  Current temp storage is at 5921M.
>
> The 35GB would have put as close to the danger line at 90% DASD. Any
> chance to find out now which job has used up so
> much temp storage?

Hi Oliver

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

Regards, Martin
[1] Takes snapshots every so long and monitors overall DASD usage, 
increase in DASD and current temp storage per job, sending warnings to 
nominated users when preset thresholds are exceeeded. If anyone's 
interested I could bundle it up sometime.
-- 
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 is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.