Strapped spool space although users already logoff from the Teradata system

Database
Enthusiast

Strapped spool space although users already logoff from the Teradata system

Hi,

We noticed that we have had a few users having strapped spool space although they have already logoff from the TD system completely.

This issue rarely happened prior the upgrade of the RDBMS v16.10.

 

We are using this stored procedure to release the strapped spool space for interim solution.

CALL SYSLIB.FixCurrentSpace('S','N','N','xxxxx',outcount,errinfo);

We are not sure if it is RDBMS v16.10 related issue.

We are not sure why it has happened like this.

Thanks a lot for your help in advance.

Regards,

Vianh