16.20 - Always Fallback - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Release Notes
Publication ID
B035-1098-162K
Language
English (United States)
Last Update
2019-05-03

Fallback behavior and defaults have become platform-specific. Newer platforms now always use fallback. All newly created databases, users, indexes, and tables are set to FALLBACK, even if you specify NO FALLBACK in the CREATE request. All databases or users are set to FALLBACK even if you specify NO FALLBACK in the ALTER TABLE or MODIFY DATABASE/USER request.

Older platforms that upgrade to this release still allow the NO FALLBACK option, and the default is NO FALLBACK for CREATE TABLE, ALTER TABLE, CREATE JOIN INDEX, CREATE HASH INDEX, CREATE DATABASE, MODIFY DATABASE, CREATE USER, and MODIFY USER requests.

Benefits

Platforms that are optimized for fallback can recover quickly from data corruption.

Considerations

The SYSINIT default for all platforms is now ALWAYS FALLBACK. However, the Parallel Upgrade Tool (PUT) will use the fallback setting appropriate to the platform.

Additional Information

For more information, see Teradata Vantageā„¢ - Database Administration, B035-1093.