IBM Support

DataStage V9.1 ODBC Connector stage errors with "Connection Dead"

Troubleshooting


Problem

Utilizing the DataStage V9.1 ODBC Connector with the Oracle Wire Protocol Driver to connect to an Oracle instance, the job would fail the ODBC connection with the error "Connection Dead"

Symptom

ODBC function "SQLConnect" reported: SQLSTATE = 08001: Native Error Code = -4: Msg = [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead. (CC_OdbcConnection::connect, file CC_OdbcConnection.cpp, line 578)

Cause

ODBC V7,1 07 June 2016 (ODBC V71 160607)

Resolving The Problem

Upgrading to ODBC V7,1 24 Nov 2016 (V7.1 161124) resolved the problem.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.1;9.1.0.1;9.1.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21995271