Teradata Database Message 2507 - 2507 - Analytics Database - Teradata Vantage

Message

Out of spool space on disk.

Explanation

Insufficient disk space was available on the AMP to allow an operation to complete.

Generated By

File System

For Whom

End User

Notes

This indicates that a request has exceeded the physical storage limits imposed by a given configuration without exceeding the logical limits imposed by PERM or SPOOL space allocations for a given database. Or, this indicates that a request for SPOOL space allocation failed due to DBS CONTROL File System field CylindersSavedforPERM.

Remedy

If out of SPOOL space, resubmit the request, preferably when there is less activity on the system. If out of PERM space, reduce permanent space usage by archiving journals or user tables where possible. Check if DBS Control File System field CylindersSavedforPERM is set too high.