Teradata Database Message 9786 - 9786 - Analytics Database - Teradata Vantage

Message

AMP VPROC %VSTR is close to running out of physical disk space.

Explanation

The database file system component has detected a condition where the physical disk space is getting close to the permissible limits. A request for any database/user that is adding space will result in error to avoid excessive usage under these boundary conditions.

Generated By

AMP Modules.

For Whom

DBA.

Notes

None

Remedy

Please monitor the space usage and either make space available by deleting data no longer required. The problem may also occur as most of the data is skewed on the AMP that raised the error condition. If tables with MAP definitions are present, check to see if they can be located in different MAPs such that the data from the AMP can be moved. Alternately, check if too many concurrent users are using up the spool space due to which this condition may be hit. If problem repeats it is time to do capacity planning and increase the system sizing to handle the additional data or workload.