Teradata Database Message 1198 - 17.10 - 1198 - 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
Incremental Restore cannot be turned off because Internal GDO #553 EnableBackupsforIncrementalRestore is enabled for the whole system.
Explanation
The EnableBackupsforIncrementalRestore DBS Internal Control is enabled for the whole system, therefore the user cannot execute LOGGING INCREMENTAL ARCHIVE OFF SQL command.
Generated By
BAR.
For Whom
End user.
Notes
None.
Remedy
User needs to modify DBS Internal Control #553 EnableBackupsforIncrementalRestore and set it to either 0 or 1. For disabling backups for Incremental Restore, set this to 0. For enabling Incremental Restore logging at the object level, set it to 1.