Re: High AS400 Storage

Hey Martin,
 
The QZDAOINIT jobs were running at the time the storage was increasing.I can recall now.
 
In such circumstances can we kill or hold the QZDAOINIT jobs .Will it impact anything on the system.
 
Many Thanks
Darell

--- On Sun, 18/7/10, Martin Rowe <dbg400.net@xxxxxxxxx> wrote:


From: Martin Rowe <dbg400.net@xxxxxxxxx>
Subject: Re: High AS400 Storage
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: Sunday, 18 July, 2010, 6:42 PM


On 18 July 2010 14:53, Darell Wheeler <darellwheeler@xxxxxxxx> wrote:

Hi,

Yesterday the storage level increased drastically to 96%.At that time I could not see any extract job running on the system.After the developers cleared some files and storage was brought down I did an outfile of all journals in user libraries.What I saw was that there were around 160 GB of Journals created on the system the previous night.

I have a question here:

Is there a way on the AS400 system/iTera HA to check at any point of time if large Journals are being created .Any specific AS400 command /iTera menu or iTera job which will help locating this.Also in such scenarios when the storage is increasing quickly,which command can actually help me in locating the exact reason for the rise in storage

This would be very helpful since if the storage  is on the rise we can check if this is happening due to creation of large journalled files/user running extracts interactively etc .

Hi Darell

We've had similar issues with journals and HA software user spaces
(both in OMS & MIMIX) but mainly with runaway SQL requests (QZDAOINIT
jobs) chewing up large amounts of storage. I wrote a little background
monitor to notify QSYSOPR if there is an unexpected rise in storage
use. It does a check on job temporary storage too, reporting jobs over
a pre-defined amount. I'm sure you could tailor it to your specific
use case. Code & info at
http://www.dbg400.net/foswiki/bin/view/DBG400/DasdMon

Regards, Martin