16.20 - Journal Tables and the Default Map - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Modifying the default map of the database does not change the map being used for the journal table.

If the MODIFY DATABASE statement specifies a journal table and a default map, the journal table is created using this default map. The journal table map must be a contiguous map with the same AMPs as TD_GlobalMap.

If the MODIFY DATABASE statement specifies a journal table without specifying a default map, the system determines the map for the journal table in the following order of precedence:
  • Default map, if defined, for the profile of the database creator. See the DEFAULT MAP option for CREATE PROFILE.
  • Default map, if defined, for the database creator. See the DEFAULT MAP option for CREATE USER.
  • System-default map.