0 - 2 of 2 tags for Spoolspace

I was wondering if there were any recommendations on spool space limits imposed on users.  We currently use Profiles in our Teradata systems to enforce a 200GB spool limit on the end users.  This has been in place for years and we have rarely seen an issue.

We had an issue recently where in an attempt to build fairly small Join Indexes on a fairly large table (2TB), the build would blow out the spool limit.  even after increasing the spool limit to 5TB, we still had issues.  We finaly gave in and rebooted the 4 node 5500 system running 13.10.04.01b.