RE: Who has a big QTEMP?

["Jenkins, Joseph" <joseph.jenkins@xxxxxxx>]

Terry, what release are you at?  And do you do a lot of stuff with SQL?

Joseph Jenkins
EDS

* phone: 248-377-3964
* mailto:joseph.jenkins@eds.com
www.eds.com



-----Original Message-----
From: Ingram, Terry (USE) [mailto:Terry.Ingram@uescape.com]
Sent: Friday, August 25, 2000 3:13 PM
To: 'MIDRANGE-L@midrange.com'
Subject: Who has a big QTEMP?


We ran a disk RTVDSKINF and noticed 17% (about 50G) is being tied up in
"temporary space" as referred to on the PRTDSKINF.  In an IBM manual it said
this is due to objects in QTEMP.  

What made me look at the PRTDSKINF is that we were at 92% ASP use.  We IPL'd
and it went down to 67%.  After 3 weeks, we are up to 87%.  

The big question is, which of these jobs has the big QTEMP?  I'm wondering
if we can bounce a subsystem, better yet end and restart a job instead of
IPL'ing to get the space back.

TIA
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---