RE: Who has a big QTEMP?

["Richard Jackson" <richardjackson@xxxxxxxxxxxxxxxxxx>]

If you use ODBC via client access then get a bunch of QZDASOINIT jobs
running, they will use quite a bit of temporary space.  You can set the max
uses parm to a smaller value, like 1 or 5.  The default is 200.  You can end
host servers and drop the subsystem every night.  You can IPL more often.
There are probably some other choices that I haven't thought of.

You can monitor the amount of storage tied up this way.  In the header part
of the WRKSYSSTS screen, press help on the second field from the bottom on
the right side.

Richard Jackson
mailto:richardjackson@richardjackson.net
http://www.richardjacksonltd.com
Voice: 1 (303) 808-8058
Fax:   1 (303) 663-4325

-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Ingram, Terry (USE)
Sent: Friday, August 25, 2000 1: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
+---