In previous releases, some features were enabled by default and others were manually enabled, depending on whether the Vantage system had a fresh installation (sysinit) or an upgrade.
Default enabling may cause changes in system behavior compared with previous releases. Even after enabling, some features may require additional configuration.
Teradata Vantage 1.1 and later features do not require a sysinit to be enabled. Features in earlier releases that required a sysinit still require a sysinit.
Feature Use Log (FUL) is automatically enabled with Default Logging for all license tiers, for both sysinit and upgrade. The syntax to enable or disable FUL is still supported, but will be a no-op because FUL is now always logged whenever default logging is enabled.
Feature | License Tiers | Upgrade Sysinit | Effects and Comments |
---|---|---|---|
OVERRIDE ON ERROR | Not Applicable | Upgrade: Enabled Sysinit: Enabled |
OVERRIDE ON ERROR has become the default when creating tables. If a user names an invalid map when creating a table, the system uses the default map for the user, role, or profile instead. If there is no default map for the user, role, or profile, the system default map is used. |
Always Fallback | Not Applicable | Upgrade: Disabled Sysinit: Enabled |
Fallback behavior and defaults have become platform-specific. Newer platforms always use fallback, even if you specify NO FALLBACK. 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. |
In-Memory Optimization | Developer: Not Applicable Base: Not Applicable Advanced: Not offered Enterprise: Included |
Upgrade: Disabled Sysinit: Disabled |
In-Memory Optimization is enabled when the appropriate license and memory are purchased. To enable, contact Teradata Support Center. |
Temporal | Developer: Included Base: Included Advanced: Included Enterprise: Included |
Upgrade: Disabled Sysinit: Disabled |
To enable, contact Teradata Support Center. After Temporal is enabled, it cannot be disabled.
|
Teradata Secure Zones | Developer: Included Base: Included Advanced: Included Enterprise: Included |
Upgrade: Disabled Sysinit: Disabled |
|
Teradata Database MAPS Architecture (MAPS) | Developer: Not Applicable Base: Included Advanced: Included Enterprise: Included |
Upgrade: Disabled Sysinit: Enabled |
This feature is:
When MAPS is enabled, you must use DSA for archive/recovery operations. For more information about DSA, see Teradata® DSA User Guide, B035-3150.
|
Adaptive Optimization | Developer: Includes IPE Base: Includes IPE Advanced: Includes IPE Upgrade:Enterprise: Includes Enhanced IPE |
Upgrade: Enabled for Enterprise Sysinit: Enabled for Enterprise |
Enhanced IPE provides:
|
Block loads between Row Level Security (RLS) tables and non-RLS tables | Developer: Included Base: Included Advanced: Included Enterprise: Included |
Upgrade: Disabled Sysinit: Disabled |
To enable, contact Teradata Support Center. |
IN-list Rewrite Developer | Developer: Included Base: Included Advanced: Included Enterprise: Included |
Upgrade: Enabled Sysinit: Enabled |
To disable this feature, use DBS Control fields. For more information, seeTeradata Vantage™ - Database Utilities, B035-1102 |
TASM I/O Usage Event | Developer: Not Applicable Base: Not Applicable Advanced: Not Applicable Enterprise: Included |
Upgrade: Disabled Sysinit: Disabled |
To enable, contact Teradata Support Center. The appropriate license must be purchased first. |
Intelligent Memory (TIM) | Developer: Not Applicable Base: Not Applicable Advanced: Included Enterprise: Included |
Upgrade: Disabled Sysinit: Disabled |
TIM is enabled when the appropriate license and memory are purchased. To enable, contact Teradata Support Center. |
TVS (Hybrid Storage) | Developer: Not Applicable Base: Not Applicable Advanced: Not Applicable Enterprise: Included |
Upgrade: Enabled Sysinit: Enabled |
TVS (Hybrid Storage) is enabled by default when using the hybrid storage system. |
Concurrent Query Limit | Developer: 2 Base: 15e Advanced: None Enterprise: None |
Upgrade: Enabled Sysinit: Enabled |
Appropriate license must be purchased first. |
Function Mapping | Developer: Included Base: Included Advanced: Included Enterprise: Included |
Upgrade: Enabled Sysinit: Enabled |
Function mapping simplifies executing functions on foreign servers. |
Teradata Analytic Functions | Developer: Included Base: Included Advanced: Included Enterprise: Included |
Upgrade: Enabled Sysinit: Enabled |
Some scoring and predictive analytical functions are executed natively on Advanced SQL Engine. For details see Teradata Vantage™ - Advanced SQL Engine Analytic Functions, B035-1206. |
Default DBQL Algorithm | Not Applicable | Upgrade: Enabled Sysinit: Enabled |
Changed from Alg 1 to Alg 3. |
Native Object Store (NOS) | Not Applicable | Upgrade: Enabled Sysinit: Enabled |
WRITE_NOS is also enabled when NOS is enabled. It is only enabled on SLES 12 SP3 and if certain prerequisites are met. If not enabled by default, contact Teradata Support Center. |