Teradata Database Message 9786 - 17.10 - 9786 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
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.