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.