DB2 Connector Bulk Load failure

pavankvk · Post by **pavankvk** » Wed Mar 01, 2017 1:54 pm

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

PaulVL · Post by **PaulVL** » Wed Mar 01, 2017 4:03 pm

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

pavankvk · Post by **pavankvk** » Thu Mar 02, 2017 9:18 am

tried your suggestion, didn't help