Obtaining Database System Identity Information - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities
The following information, used by the Teradata PT ODBC operator, must be provided by a DB2 DBA or z/OS system programmer:
  • Because the IBM DB2 database is a subsystem, knowing the subsystem ID (SSID) is required.
  • Knowing the data source name of the database, referred to as the “connection name” or the “location name,” is in most cases required. The connection or location name is defined in SYSIBM.LOCATIONS when DDF is configured in the DB2 subsystem.

    In many applications, when DDF is not being used, a local database is accessed. In these cases, the local database name is the name that was set during DB2 installation as DB2 LOCATION NAME on the DSNTIPR installation panel for the DB2 subsystem.

    When the data source name is not provided, the default local database will be used. The local database is identified by the SSID.