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>;
- To grant the use of TDMaps procedures: