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



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.