JR62458: DB2 Connector fails to connect to DB2 secured with SSL when used in DTS non-XA mode

APAR status

• Closed as program error.

Error description

• In case of SSL connection to Db2, DTS fails to work in non-XA
  mode and reports error in the job log:
  The connector could not establish a connection to DB2 database
  using the default user. SQLConnect reported: SQLSTATE = 08001:
  Native Error Code = -30,082: Msg = [IBM][CLI Driver] SQL30082N
  Security processing failed with reason "3" ("PASSWORD MISSING").
  SQLSTATE=08001 (CC_DB2Connection::connect, file
  CC_DB2Connection.cpp, line 945)
  The issue is caused by inaccessible GUI configuration for DTS
  alternate connection settings of non-conductors (agents).
  

Local fix

• N/A
  

Problem summary

• In case of SSL connection to Db2, DTS fails to work in non-XA
  mode and reports error in the job log: The connector could not
  establish a connection to DB2 database using the default user.
  SQLConnect reported: SQLSTATE = 08001: Native Error Code =
  -30,082: Msg = [IBM][CLI Driver] SQL30082N Security processing
  failed with reason "3" ("PASSWORD MISSING"). SQLSTATE=08001
  (CC_DB2Connection::connect, file CC_DB2Connection.cpp, line
  945).
  

Problem conclusion

• The issue is caused by inaccessible GUI configuration for DTS
  alternate connection settings of non-conductors (agents).
  The settings are accessbile in the patch provided.
  

Temporary fix

• N/A
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels