Journal Tables and the Default Map
If the CREATE 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 CREATE 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 of CREATE PROFILE.
- Default map, if defined, for the database creator. See the DEFAULT MAP option of CREATE USER.
- System-default map.