Re: Finding reason for high temp storage maximum

[ouuch@xxxxxxxxxxx]

On 4 Dec 2003 at 8:29, R. Bruce Hoffman, Jr. wrote:

> >    To get the memory back the QZDASOINIT jobs need to be ended as yours
> > apparently have although that still doesn't give back 100%, eventually
> > an IPL is required.
> >
> >    At the heart of it, SQL seems always to be invlolved someplace.
> 
> 
> and I would echo those sentiments about SQL, however, on the platform where
> I see this, the culprit is SMTP.
> 
> Ending SMTP and MSF and restarting them frees up 12 to 15 GB in this
> case.... which gets consumed by temp storage over the next couple of days...

My guess is it was an interactive query building an temporary index. After the 
job ended, temp
storage is now back to the normal 6GB.

After IPL, we normally are around 2GB and will build up to 7-8GB until next 
week IPL.

I guess it was just a one-time problem, that only happens every other odd month.

Regards,

Oliver