Data Mover jobs execute much faster if multiple Ethernet ports are used when copying data between database systems. Teradata recommends increasing network throughput on the Data Mover multi-purpose server by setting up specific network routes for all of the COP entries on the source and target database systems in the Data Mover jobs. A COP entry is the IP address of a database node. These specific network routes allow the Data Mover Agent to connect TCP sessions to the source and target systems using different Ethernet ports on the Data Mover multi-purpose server. This improves performance by distributing data across all available network ports.
The topics in this section describe how to set up the routes using a 2-node database system called dmdev as a source and a 2-node database system called dmtest as target. The examples in this section assume the network ports eth4 and eth5 are connected and available for use on the Data Mover multi-purpose server.
- Add the IP addresses for all source and target COP entries in the /etc/hosts file on the Data Mover multi-purpose server.
- Define the specific routes for the COP entries in the /etc/sysconfig/network/routes file on the Data Mover multi-purpose server.
- Restart the network on the Data Mover multi-purpose server.
- Verify the route changes are in place on the Data Mover multi-purpose server.