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

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

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