Setting Up the Teradata PT Job JCL for ODBC - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
Product Category
Teradata Tools and Utilities

To define a subsystem to DB2 ODBC:

  • Specify the MVSDEFAULTSSID keyword in the common section of the initialization file identified by the DDNAME “DSNOAINI”.
  • If the MVSDEFAULTSSID keyword does not exist in the initialization file, DB2 ODBC uses the default subsystem name specified in the DSNHDECP load module that was created when DB2 was installed.

    The DSNHDECP load module is usually link-edited into the *.SDSNEXIT data set. See the example below:

    //STEPLIB DD DSN=DSN910.SDSNEXIT,DISP=SHR
    //        DD DSN=DSN910.SDSNLOAD,DISP=SHR

To set up a Teradata PT Job JCL for ODBC:

  • Add the DB2 library to the JOBLIB/STEPLIB, as in the following example:
    //JOBLIB DD ( …  )
    //       DD DSN=DB2910.SDSNLOAD,DISP=SHR
  • (Optional) Add the DB2 Initialization Dataset with the Teradata PT jobstep/procstep override, as in the following example:
    //TPT.DSNAOINI DD DSN=DB2910.INIT(DB2INIT)
    
    DB2INIT:
    [COMMON]
    MVSDEFAULTSSID=SSID