2.10 - Adding a Dedicated Bridge System - 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
A dedicated bridge system contains a set of nodes that act as routers for data movement and can perform CPU-intensive operations such as compression or encryption. A dedicated bridge system does not contain data source nodes.
  1. Under Fabric Components, select Systems.
  2. Click "" next to Systems.
  3. Type a name, up to 256 characters.
  4. Select the Bridge only system check box.
  5. Type a description, up to 1,000 characters.
  6. From the Data center list, do one of the following:
    • Select the data center where this system is located.
    • If the data center where this system is located is not in the list, click "" to add the data center.
  7. From the Node software list, do one of the following:
    • Select the version of the node software that runs on this system.
    • If the version of the node software that runs on this system is not in the list, click "" to upload the software version file.
  8. Under Resource Allocation, to set the maximum amount of memory needed to support applicable concurrent queries, do one of the following:
    Option Description
    Max memory per node
    1. In the box, add the maximum amount of memory needed.
      Depending on the available memory on the nodes, certain settings might need to be tuned (for example, FSG Cache) to make sure memory is available for QueryGrid.
    Estimate Use the Estimate tool to help you estimate the amount of memory you need.
    1. Click Estimate.
    2. In Max query concurrency, enter the maximum number of QueryGrid queries expected to run concurrently for all connectors on the system.
    3. In Max link buffer size, do the following:
      • Enter the size of the buffers for the communication channels.
      • Select the unit of measurement.

      Valid values range from 1 to 999. The default is 1 MB.

    4. In Max link buffer count, enter the maximum number of buffers that any link or connector is configured to use per communication channel.

      Valid values range from 1 to 999. The default value is 4.

    5. In Max workers per node, enter the number of threads that participate in a query on a given node.

      For example, enter the number of AMPs per node on the Teradata Database system. For more information, refer to KCS008587.

    6. Click Set Value.

      The value that appears in the Max memory per node box is calculated from the values you entered in the tool.

  9. Click Save. The dedicated bridge system is listed under Fabric Components, in Bridges, but you must add non-data-source nodes to it.