2.06 - Configuring Virtual IP Addresses - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Teradata QueryGrid
Release Number
September 2018
English (United States)
Last Update
If your system is configured with Network Address Translation (NAT), each node has one or more unique virtual IP addresses associated with it. You can use the virtual IP addresses of a node to communicate with Teradata QueryGrid target systems that are on a public network.
To use virtual IP addresses, each NAT-configured node that runs Teradata QueryGrid node software must have a text file containing its virtual IP addresses.
You can use virtual IP addresses on data source nodes, bridge nodes, or both. However, to reduce the number of virtual IP addresses that need to be configured, Teradata recommends using virtual IP addresses only on bridge nodes.
  1. On each node in your system, log on and go to the following directory: /etc/opt/teradata/tdqg/node
  2. In the directory, create a text file called virtual_ips.
  3. Using one virtual IP address per line, populate the text file with the virtual IP addresses of the node. The virtual IP addresses must be valid IPV4 or IPV6 addresses. The file should look similar to the following:
  4. Save the file.
  5. Restart the node by typing the following: service tdqg-node restart

    During QueryGrid operations, the IP addresses in each line of the file are read, validated, and used as virtual IP addresses. If the file does not exist in the /etc/opt/teradata/tdqg/node directory, a file not present message is logged in /var/opt/teradata/tdqg/node/<version>/logs/ tdqgnode-boot-<version>.log.