IBM Support

ODBC connection fails in DataStage job with general network error.

Troubleshooting


Problem

main_program: Fatal Error: Could not connect to datasource?? (-1; ods_owner; CON_PAEMS328; [IBM(DataDirect OEM)][ODBC SQL Server Driver][libssclient24]General network error. Check your network documentation.)

Resolving The Problem

This might indicate a genuine network issue, or a configuration problem.
Test the connectivity outside of DataStage:

a) cd $DSHOME
b) . ./dsenv
c) cd ../branded_odbc/example
d) ./example

This starts a simple program that prompts you for datasource name, user, and password, and tries to connect. Note the results -- does this succeed, or does it fail to connect?

Also try using telnet from the DataStage engine to the database host, using the hostname and port from the DSN:

telnet host port

If telnet comes back with a message like "Could not open connection to the host, on port nnnnn" then there is a network problem that will need to be investigated, or your .odbc.ini is not configured correctly for hostname and port.

Try using IP address in the DSN definition to see if this resolves the issue.

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

Document Information

Modified date:
16 June 2018

UID

swg21624491