OBDC failure - View Data works but Job fails

[oddhobbes]

Hi guys,

We're having a strange error while trying to connect via ODBC to a DB2 instance. This is a code migration to new environment, consequently the code itself is tested (we have no odbc errors in the source environment).

On first instance both View Data (VD) and Job (and example odbc program) failed, on following error messages:

VD:

[####]

[0001]Error executing View Data command:‑‑##E IIS-DSEE-TDOD-00007 16:06:55(000) <DWCMPDATE_DB2,0> [IBM(DataDirect OEM)][ODBC 20101 driver]1248

Job:

Resource bundle corresponding to message key return code {0} from SQLConnect(handle, {1}, ****, {2}) with message {3} not found! Check that DSHOME or APT_RESPATH is set.

main_program: Fatal Error: Could not connect to datasource?? (-1; SIT5RDNDTA; Test_db2; [IBM(DataDirect OEM)][ODBC 20101 driver]8276)

Following suggestion of the last error msg, here the values of the environment variables (looks right and mirrors source environment):

$ echo $DSHOME
/opt/ibm/InformationServer/Server/DSEngine
$ echo $APT_RESPATH

$

The VD and example program issue turned out to be driver version difference between the two environments. We then updated the driver version to that of the source environment. After that, VD works (and the exemple program), but the job still aborts on same error message.

Any information about common datastage odbc driver issues (and errorcode 1248 in particular), or any information regarding known situations where VD works but job fails on odbc are highly appreciated.

Kind regards,

Pedro