2.06 - Migrating 1.0x Teradata Foreign Server Definitions to 2.0x Teradata Connectors - 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
QueryGrid 2.0x Teradata connectors are compatible with the SQL data manipulation language used for QueryGrid 1.0x Teradata-to-X connectors. In 2.0x, if you want to use the same SQL you use with your 1.0x connectors, you can migrate your 1.0x foreign server definitions for use with 2.0x connectors.

The following procedure preserves the FOREIGN SERVER grants and access rights for users.

  1. Stop all queries running on the QueryGrid 1.0x foreign server.
  2. For the FOREIGN SERVER used on QueryGrid 1.0x, type the following to display the FOREIGN SERVER description, the list of custom clauses, and the import and export functions used for the FOREIGN SERVER:
    SHOW FOREIGN SERVER bock_classic2;
    CREATE FOREIGN SERVER TD_SERVER_DB.bock_classic2
    EXTERNAL SECURITY INVOKER TRUSTED UT1PROXY3 USING
    Hosttype  ('Teradata')
    remotehost  ('bock1.labs.teradata.com')
    ip_device  ('byn1')
    port  ('5000')
    read_timeout  (200 )
    listen_timeout  (60 )
    concurrentstreams  (1 )
    DO IMPORT WITH SYSLIB.LOAD_FROM_TD ,
    DO EXPORT WITH SYSLIB.LOAD_TO_TD ;
    
  3. Drop all old NVPs from the QueryGrid 1.0x foreign server.
    ALTER FOREIGN SERVER TD_SERVER_DB.bock_classic2 DROP hosttype, drop remotehost, drop ip_device, drop port, drop read_timeout, drop listen_timeout, drop concurrentstreams, drop IMPORT, drop EXPORT;
  4. Add the new NVPs to the QueryGrid 1.0x foreign server.
    AALTER FOREIGN SERVER TD_SERVER_DB.bock_classic2 ADD link(‘bock_ng’), add IMPORT WITH TD_SYSFNLIB.QGINITIATORIMPORT, add export with TD_SYSFNLIB.QGINITIATOREXPORT;
  5. Show the new 2.0x FOREIGN SERVER.
    SHOW FOREIGN SERVER bock_classic2;
    CREATE FOREIGN SERVER TD_SERVER_DB.bock_classic2
    EXTERNAL SECURITY INVOKER TRUSTED UT1PROXY3 USING
    LINK(‘bock_ng’)
    DO IMPORT WITH TD_SYSFNLIB.QGINITIATORIMPORT,
    DO EXPORT WITH TD_SYSFNLIB.QGINITIATOREXPORT;
    
    For more information about configuring the 2.0x foreign server with QueryGrid 2.0x name value pairs, see: