How to define a subsystem to Db2 ODBC

You can define a Db2 subsystem in two ways. You can use MVSDEFAULTSSID, or you can use the default that is specified in the DSNHDECP load module.

You can identify the Db2 subsystem by specifying the MVSDEFAULTSSID keyword in the common section of initialization file. 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. Therefore, you should ensure that Db2 ODBC can find the intended DSNHDECP when your application issues the SQLAllocHandle() call (with HandleType set to SQL_HANDLE_ENV).

The DSNHDECP load module is usually link-edited into the DSN1310.SDSNEXIT data set. In this case, your STEPLIB DD card includes:

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