Teradata Database Message 9789 - 17.10 - 9789 - 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
The request to assign new default map option is invalid.
Explanation
The default map with OVERRIDE option specified in the database or user modification statement is not contained in the map of the owner database/user. Space allocations cannot be set for AMP VPROCs with such modification and hence the statement results in this error. The modified map for the database/user is causing the AMP VPROC permanent space limit to go below the actual current usage already on the AMP.
Generated By
Parser modules.
For Whom
End User.
Notes
None
Remedy
1) The user should modify the user/database to increase perm/spool/temp space as indicated in the alert. 2) Check and increase the permanent space limit or adjust the skew when modifying the default map.