Page 1 of 1

DB2 Connector Bulk Load failure

Posted: Wed Mar 01, 2017 1:54 pm
by pavankvk
Hi

We are facing with DB2 Bulk load issue with the jobs failing with a SQL2019N error. We are moving from 9.1 to 11.5 and the same jobs work fine in 9.1 environment running to the the same remote database,but they fail in 11.5

We have opened a ticket with IBM, but they haven't been able to diagnose the issue. We did bind all the utilities suggested by IBM.

Has anyone seen a 2019 failure with db2 connector? One other behavior i see is the db2 connector is supposed to create a message file, that doesnt get created. the data files and .sh, .clp files are created though.

please let me know if you have seen such behavior

Posted: Wed Mar 01, 2017 4:03 pm
by PaulVL
well that is a bind issue, did you also bind the odbc drivers?



http://www-01.ibm.com/support/docview.w ... wg21617594


/somethingsomething/IBM/InformationServer/Server/branded_odbc/bin/bind00

Posted: Thu Mar 02, 2017 9:18 am
by pavankvk
tried your suggestion, didn't help