2.10 - Adding a Link - 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
  1. Under Fabric Configuration, select Fabrics and click a fabric to which you want to add a link.
  2. Click the Links tab.
  3. Click "" next to Links.
  4. Type a name, up to 256 characters.
  5. Type a description, up to 1,000 characters.
  6. From Bridge configuration, select one of the following:
    Option Description
    No bridges A bridge is not used for this link. The hop is between the initiator and target.
    Single bridge A single bridge is used for this link. A query is sent from the initiator to the bridge (Hop 1), and from the bridge to the target (Hop 2). A query is returned in the reverse order.
    Dual bridge A dual bridge is used for this link. A query is sent from the initiator to bridge 1 (Hop 1), from bridge 1 to bridge 2 (Hop 2), and from bridge 2 to the target (Hop 3). The query is returned in the reverse order.
  7. From Initiating Connector, do the following:
    1. In the Connector name list, select an initiating connector that sends the queries.
    2. In the Threads per query box, type a number for the number of query tasks to be used during data transfer at the initiating system. The default is 1. Supported values are 1 to 5.
  8. Click "" next to Initiating Connector.
  9. In Select Initiating Connector Properties, do one or more of the following:
    Option Description
    Customize
    1. Select the check box to customize the values for an initiating connector property.

      When the check box is cleared, it designates that QueryGrid should use the default values for a property

    Overridable
    1. [Optional] Select the check box to designate that the normal configured values for the initiator connector property can be overridden when a user executes queries during individual processing sessions.

      Once you select the check box, it cannot be cleared.

      Once you designate a property as overridable at the connector level (on the Connectors tab), it stays in effect even if you do not designate it as overridable at the link level.

      In order to disable the setting for an initiator or target connector, you must clear the check box at both the link level and connector level.

      For these reasons, it might be preferable to designate a property as overridable only at link level, depending on the requirements specific to the link.

  10. Click OK to save the configuration. Under Initiating Connector, all properties you set to customize appear.

    Each property is required until you clear the check box.

  11. Modify each setting to govern how the initiator connector operates in this link pairing. For complete descriptions of all properties for each connector type, see:
  12. If you selected a Single bridge or Dual bridge configuration, do the following for each bridge:
    1. In the Bridge name list, select the bridge system.
    2. In the Threads per query box, type a number for the number of query tasks to be used during data transfer at each bridge system. The default is 1. Supported values are 1 to 5.
  13. For each hop, add an Initiating network:
    Option Description
    Select an initiating network
    1. Select an existing network from the list.
    Add a new initiating network and select it
    1. Click "" next to Initiating network to add the network you want this link to send queries over.
    2. Type a name, up to 256 characters.
    3. Type a description, up to 1,000 characters.
    4. In the Matching rules list, select one of the following:
      • CIDR notation
      • Interface name
    5. [Optional] Click "" next to Matching rules to add more rules.
    6. [Optional] You can click "" to remove an existing rule.
    7. Click Save.
    8. Select the network from the list you just added.
  14. For each hop, add a Target network. Do similar steps performed to add an initiating network.
  15. For each hop, do one of the following to add a Communication policy:
    Option Description
    Select a communication policy
    1. Select a policy from the list.
    Add a communication policy and select it
    1. Click "" next to Communication Policy.
    2. Type a name, up to 256 characters.
    3. Type a description, up to 1,000 characters.
    4. Type an integer from 1 and 5 to set the number of data transfer streams that can run simultaneously.

      The default value is 1.

    5. Select the combination of authentication, integrity and encryption checks you want to use. The choices appear in order of increasing security level, with the choice that provides the greatest level of security listed last. Fill in values, if requested. For more information, see Adding a Communication Policy.
    6. Click Save.
    7. Select the policy you just added for Communication policy.
  16. From Target Connector, do the following:
    1. In the Connector name list, select a target connector to receive queries from.
    2. In the Threads per query box, type a number for the number of query tasks to be used during data transfer at the target system. The default is 1. Supported values are 1 to 5.
  17. Click "" next to Target Connector.
  18. In Select Target Connector Properties, follow the same process as noted for the Initiating Connector.
  19. Click OK to save the configuration. Under Target Connector, all properties you selected to customize appear.
  20. Modify each setting to govern how the target connector operates in this link pairing.
  21. [Optional] Select a User mapping to use over this link. User mapping enables a specific user on an initiating system to submit queries as a specific user on a target system.
  22. [Optional] Select Enable debug logging for initiating user if you have a query or set of queries that are failing or not performing correctly for a particular database user for an unknown reason. If you enable this option and have the user run the query again, detailed logging is captured by the Teradata QueryGrid Manager.

    Use Info for debugging performance issues and Debug for debugging incorrect or failing behavior. A Teradata Technical Support Specialist can then use this information to troubleshoot the issue.

  23. Click Save.