2.06 - Overriding Session Properties - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.06
Published
September 2018
Language
English (United States)
Last Update
2018-11-26
dita:mapPath
blo1527621308305.ditamap
dita:ditavalPath
ft:empty
Designating a Teradata connector property as overridable in the QueryGrid portlet allows users to override configured Teradata connector properties when starting queries during an individual processing session.

When you override a Teradata connector property, the servername in the syntax statement indicates the foreign server to which the listed, overridable Teradata connector properties apply. The designated foreign server uses the value of the properties listed in the syntax statement until the occurrence (if any) of another servername.

  1. Under Fabric Configuration, select Fabrics.
  2. Select the fabric.
  3. Do one of the following:
    Option Description
    To override a Teradata connector property in the Connectors tab
    1. Click the Connectors tab.
    2. Click next to the connector that has a property you want to override.
    3. Select Edit.
    4. Click next to Connector Software.
    5. Find the Teradata connector property you want to override and click the Overridable check box.
    6. Click OK.
    7. Click Save.
    To override a Teradata connector property in the Links tab
    1. Click the Links tab.
    2. Click next to the link that has a property you want to override.
    3. Select Edit.
    4. Click next to Initiating Connector or Target Connector.
    5. Find the Teradata link property you want to override and click the Overridable check box.
    6. Click OK.
    7. Click Save.
  4. Use the following syntax when running Teradata Database 16.00 and later to override the Teradata connector property during a session:
    set foreign server attr = ‘servername=<fs1>;<prop1>=<overrideVal1>;…;servername=<fs2>
    <prop1>=<overrideVal1>;…;’ for session volatile;
    For example:
    Set foreign server attr = ‘servername=fs1;readtimeout=500000;writetimeout=200000;servername=fs2;
    responsetimeout=250000;’ for session volatile;
  5. [Optional] To clear Teradata connector property overrides without closing a session, use the following syntax.
    Set foreign server attr = NONE for session volatile;