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"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21995271