All Forums Database
GianTD 47 posts Joined 11/14
01 Dec 2014
User Spool Limit

Hello !
How to check/decide about correct Spool limit one user should have?

teradatauser2 236 posts Joined 04/12
01 Dec 2014

Usually individual users dont have a spool limit assigned. Users are gropued into profiles e.g ETL profile, User profile etc and these profile has a spool space assigned to it. So, all users have that much max spool space assigned to them. Now, how to decide how much of spool can a profile have ? Usually, this will be done at the enterprise level and can't be generally changed. But, we had a situation in which our ETL jobs were failing with spool space error, then we had TD GSC suggest to increase the spool space.
You can check spool space used in dbqllog table for the profile and try to find a average value used. I don't have an exact idea about how to come to a final figure, but this is the way you can start exploring.

teradata_chela2 18 posts Joined 10/13
01 Dec 2014



GianTD 47 posts Joined 11/14
02 Dec 2014

Thanks Samir.
Thats surely a good way to start.
Any other inputs welcome...

You must sign in to leave a comment.