About Teradata Database MAPS Architecture Feature Support - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
kmo1482331935137.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
Data Mover supports the Teradata Database MAPS Architecture feature (MAPS) map and colocate parameters when copying the following objects:
  • Table
  • Index (hash or join)
  • Foreign server – data transfers using the following utilities:
    • JDBC
    • TPTAPI
    • T2T
    • T2H
    • TDCH
  • ARC – ARC chooses the first contiguous map that spans across all AMPs in the target system
The following table describes where you can specify the map and colocate parameters. They are listed in the order of parameter priority:
Level Description
Object Uses the map and colocate parameters for the specified object (table, index, or foreign server).
Database Uses the map and colocate parameters for all specified objects within the database.
Job Uses the map and colocate parameters for all objects in the specified job.
System Uses the system-level map for all jobs, which uses the specified system as the target system.

Rules and Restrictions

  • When using ARC with Teradata Database 16.10 or later, you must set the DBS control internal flag EnableARC4MHM to true. The default is false.
  • ARC cannot specify map or colocate details while moving objects or databases at any level.
  • ARC requires that the source database and its objects use an all-AMP contiguous map for a full database copy; ARC overwrites the object map on the target database and uses the all-AMP contiguous map.
  • Aster does not support Teradata Database 16.10, and therefore does not support the map and colocate parameters.
  • The map and colocate parameters are not supported in databases prior Teradata Database 16.10.
  • The target user must have permissions on target maps.
  • The target default map is the help session map when the object owner and target login user are the same, or the map is null for the target owner. When the target object owner and the login user are different, the system uses the map of the target owner as the target default map. The help session is a query which displays information on the current session, see the Teradata Database Tools and Utilities guide.
  • Creating a Colocate name is only allowed for sparse maps and can be any valid name, the default name is DatabaseName_TableName.

XML Examples

Specify system level map parameters through configuration.xml and save using the save_configuration command:
<property>
	<key>map</key>
	<value>false</value>
	<maps>
		<systemLevelMap>
			<system>prodSystem1</system> 
			<map>sparsemap4amp</map>
		</systemLevelMap>
	</maps>
</property>
Specify job level map and colocate parameters for create or edit jobs:
<dmCreate>
	. . . . . .
	<log_to_even_table><log_to_event_table>
	<map>TD_SparseMap</map>
	<colocate>ColocationName2</colocate>
	. . . . . .
</dmCreate>
Specify database level map and colocate parameters as shown in the following example:
<database selection="unselected">
	. . . . . .
	<compare_dll></compare_dll>
	<map>TD_SparseMap</map>
	<colocate>ColocationName2</colocate>
	. . . . . .
</database>

To specify table, index (hash and join) and foreign server level map and colocate parameters, refer to their respective sections in this guide.