16.10 - Initial Setup for Managing Maps - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)
There are several prerequisites for using maps to distribute table data across AMPs:
  • User DBC must grant the LOGON privilege to user TDMaps. TDMaps is a system database that contains the information and SQL stored procedures used for managing maps.
  • After the first login to TDMaps (the initial password is tdmapsadmin), change the password for TDMaps.
  • Give TDMaps enough space to store rows in the ActionsTbl and ActionHistoryTbl. A rough guideline is the size of TVM. The following example determines the size of TVM:
    SELECT SUM(CurrentPerm) FROM DBC.TableSizeV WHERE TableName='TVM';
  • Grant DBAs privileges on TDMaps:
    • To grant the use of TDMaps procedures:
      GRANT EXECUTE PROCEDURE ON TDMaps TO <User>;
    • To grant the ability to query TDMaps tables:
      GRANT SELECT ON TDMaps TO <User>;
    • To grant the ability to modify TDMaps tables:
      GRANT INSERT, UPDATE, DELETE ON TDMaps TO <User>;