NoDot0Backdown - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

Commits Teradata Database to a point release (for example, xx .10), allowing certain release-specific features to be enabled. This prevents the system from being backed down to the corresponding major release (xx .0) without re-initializing the system on the major release.

Field Group

General

Valid Settings

Setting Description
TRUE Allows certain point-release-specific features to be enabled which will preclude backing down the system to the previous major release of Teradata Database.
When this setting is TRUE, it cannot be changed to FALSE.
FALSE Prevents certain point release features from being enabled, but allows the system to be backed down from the currently-installed point release to the corresponding major release, without requiring a system initialization (sysinit).

Default

On systems that have been initialized on a major release, the default setting is FALSE, and cannot be changed.

On systems that have been upgraded from a major release to a point release without a new system initialization, the default setting is FALSE, and can be changed. After this setting has been changed to TRUE, it cannot be reset to FALSE.

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

Certain new features, if enabled in a point release, would preclude the system from being backed down to the corresponding major release. These feature cannot be enabled unless NoDot0Backdown is explicitly set to TRUE. After NoDot0Backdown has been set to TRUE, it cannot be modified, and the system cannot be backed down without a system re-initialization. For information on the features that require NoDot0Backdown to be TRUE, see the Teradata Vantage™ - Advanced SQL Engine Release Definition, B035-1725 for this release of Teradata Database.