Configure Multi-Purpose Server with Increased Throughput | Teradata Data Mover - Configuring Data Mover Multi-Purpose Server to Increase Network Throughput - Teradata Data Mover

Teradata® Data Mover Installation, Configuration, and Upgrade Guide for Customers - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
jvt1700556161677.ditamap
dita:ditavalPath
stp1591127384938.ditaval
dita:id
pqq1467243714524
Product Category
Analytical Ecosystem
All network traffic coming into and out of the Data Mover multi-purpose server goes through the default Ethernet port for the server unless it is specifically routed. If the default Ethernet port is used for all network communication, the other network ports on the Data Mover multi-purpose server are wasted. This could cause the network to slow down when processing Data Mover jobs, which could lead to poor performance when copying data.

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.

More than two ports on the Data Mover multi-purpose server could be available in a customer environment. The examples in this section use only 2-node source and target systems and two available network ports on the Data Mover multi-purpose server.
  1. Add the IP addresses for all source and target COP entries in the /etc/hosts file on the Data Mover multi-purpose server.
  2. Define the specific routes for the COP entries in the /etc/sysconfig/network/routes file on the Data Mover multi-purpose server.
  3. Restart the network on the Data Mover multi-purpose server.
  4. Verify the route changes are in place on the Data Mover multi-purpose server.