2.10 - Installing Teradata QueryGrid Manager - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K
Install Teradata QueryGrid Manager software on one or more dedicated physical or virtual machines other than the data source nodes of your Teradata QueryGrid environment. For system requirements, see Prerequisites.
When you install Teradata QueryGrid Manager software on more than one machine, you can cluster the Teradata QueryGrid Manager instances. A database can only be managed by a single QueryGrid Manager cluster, all systems in your environment must be managed by that same cluster to communicate through QueryGrid. Therefore, Teradata recommends creating one QueryGrid Manager cluster to enable all systems across the enterprise to exchange information using QueryGrid.
  1. Install the latest version of Java 8 on each dedicated physical or virtual machines.
    If the correct version of Java is not automatically detected, you can set the path to the Java home directory in /etc/opt/teradata/tdqgm/setenv.sh.
    For example:
    export TDQGM_JAVA_HOME=/usr/java/jdk1.8.0_101

    For more information, log in to https://access.teradata.com and search for KAP314E23E.

  2. Download the latest Teradata QueryGrid Manager package (file name tdqg-manager-version.rpm).
  3. Log on to the TMS, VM, or server.
  4. From a console window, install Teradata QueryGrid Manager by typing the following: rpm -ivh tdqg-manager-version.rpm

    Installation takes approximately one minute.

  5. Verify the installation.
    1. Open a browser.
    2. Access the Teradata QueryGrid Manager instance by typing the following: https://hostname:9443
  6. If you are unable to access Teradata QueryGrid Manager, do the following:
    1. Review the following logs.
      • /var/opt/teradata/tdqgm/logs/tdqgm-boot.log
      • /var/opt/teradata/tdqgm/logs/tdqgm-main.log
      • /var/opt/teradata/tdqgm/logs/init.log
    2. Fix all identified problems.
    3. From the console window, restart the Teradata QueryGrid Manager by typing the following: service tdqgm restart
  7. If this is the first Teradata QueryGrid Manager instance installed, confirm that the default value for the publicAddress is appropriate for your environment.
    1. Open the /etc/opt/teradata/tdqgm/server.properties file.
    2. If the default value is not appropriate, see Modifying the publicAddress, bindAddress, and clusterAddress for a QueryGrid Manager Instance.
      You can also edit the bindAddress and clusterAddress.
  8. If the publicAddress is a hostname (not an IP Address) and cannot be resolved from the data source nodes using DNS, add the QueryGrid Manager server or servers to the /etc/hosts file of each node in the data source system.