Peak Spool exceeded for "USERID"

Database

Peak Spool exceeded for "USERID"

We just implemented Teradata 2550, and now we are getting these massages from DBCMGR even though the user does not have an active session.

Alert for LogSpool - Peak Spool exceeded for "UserID"

Does anyone know how to clear up ghost spool??

Thanks,
Jennifer
3 REPLIES
Enthusiast

Re: Peak Spool exceeded for "USERID"

BUMP!

I'd like to know what this message means as well. I can't seem to find the setting in Viewpoint that generates this alert. We also had no query running for the user at this time. There was a gap of a number of hours either side of the alert time when no query was logged for this user.

Does anyone know?
Enthusiast

Re: Peak Spool exceeded for "USERID"

FYI - I've requested info from Teradata via @ Your Service so hopefully I'll have an answer for this soon.
Enthusiast

Re: Peak Spool exceeded for "USERID"

Oh - and I believe this error (generated by Viewpoint) to be reporting that a user ran out of spool since the last alerting time (in my case in the past 24 hours). I don't think it's alerting of a problem at the specific point in time. It might be nice if it also provided a time so you could look up the query!

You could search the DBQLogTbl for error code 2646 (No more spool space in %DBID).