- Under Fabric Configuration, select Fabrics and select the fabric you want to add a link.
- Select the Links tab.
- Select
next to Links.
- Enter a name, up to 256 characters.
- Enter a description, up to 1,000 characters.
-
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. -
From Initiating
Connector, do the following:
- In the Connector name list, select an initiating connector that sends the queries.
- In the Threads per query box, enter 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.
- Select
next to Initiating Connector.
-
In Select Initiating Connector
Properties, do one or more of the following:
Option Description Customize - Select the check box to customize the values for an initiating connector property.
When the check box is cleared, QueryGrid is designated to use the default values for a property
Overridable - [Optional] Select the check box to designate that the normally configured values for the initiator connector property can be overridden when a user starts queries during individual processing sessions.After you select the check box, it cannot be cleared.After designating a property as overridable at the connector level (on the Connectors tab), the designation 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.
- Select the check box to customize the values for an initiating connector property.
- Select 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.
-
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:
- If you selected a Single bridge or Dual bridge configuration, do the following for each bridge:
- In the Bridge name list, select the bridge system.
- In the Threads per query box, enter 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.
-
For each hop, add an Initiating
network:
Option Description Select an initiating network - Select an existing network from the list.
Add a new initiating network and select it - Select
next to Initiating network to add the network you want this link to send queries over.
- Enter a name, up to 256 characters.
- Enter a description, up to 1,000 characters.
- In the Matching rules list, select one of the
following:
- CIDR notation
- Interface name
- [Optional] Select
next to Matching rules to add more rules.
- [Optional] Select
to remove an existing rule.
- Select Save.
- Select the network from the list you just added.
- For each hop, add a Target network.Do similar steps performed to add an initiating network.
-
For each hop, do one of the following to add a Communication policy:
Option Description Select a communication policy - Select a policy from the list.
Add a communication policy and select it - Select
next to Communication Policy.
- Enter a name, up to 256 characters.
- Enter a description, up to 1,000 characters.
- Enter an integer from 1 and 5 to set the number of data transfer streams to run simultaneously.
The default value is 1.
For more information, see Adding a Communication Policy.
- Select Save.
- Select the policy you just added for Communication policy.
-
From Target Connector,
do the following:
- In the Connector name list, select a target connector to receive queries from.
- In the Threads per query box, enter 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.
- Select
next to Target Connector.
- In Select Target Connector Properties, follow the same process as noted for the Initiating Connector.
- Select OK to save the configuration.Under Target Connector, all properties you selected to customize appear.
- Modify each setting to govern how the target connector operates in this link pairing.
-
[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.
-
[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 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.
- [Optional] Select Enable acknowledgements to have QueryGrid re-establish connections that break due to transient network errors.
- Select Save.