|
On Wednesday 02 October 2002 4:51 pm, pam@medisense.com wrote: > >A query can be creating temporary files that can indeed use up a lot > > of space. I have seen a machine halt due to running out of disk > > space due to a runaway query. When the job is running you can look > > at how much temporary storage it is using to determine if this is > > happening. > > > >Scott Mildenberger > > I found it under Job Run attributes. Thanks. Hi Pam You may be interested in a routine that identifies jobs using large temporary storage. I posted the code here in April - http://archive.midrange.com/midrange-l/200204/msg00073.html Regards, Martin -- martin@dbg400.net jamaro@firstlinux.net 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 / \
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.
midrange.com
