topic DB2 Bulk table loader in sas di error in SAS Data Management

DB2 Bulk table loader in sas di error

Riteshdell — Thu, 16 Mar 2017 07:10:08 GMT

Hello DI Experts,

I am getting an error to load data by Db2 bulk table loader to Db2 tables.

If some body has experience on DB2 bulk loader table transformation.

Can you Please help me prerequisites using DB2 Bulk table loader.

error: [IBM] [CLI Driver] An error occured while utilities were being bound to the database. results for CLI load operation 0.

0 rows loaded,0 rows skipped,0 rows rejected.

Re: DB2 Bulk table loader in sas di error

LinusH — Thu, 16 Mar 2017 08:16:56 GMT

Have you properly configured and verified the SAS/ACCESS to DB2 connection?
Have this worked before?
Can you manage to this outside DI Studio?
Full code/log is required to see what's going on.
What does your DB2 DBA have to say?
Don't know if it's applicable to bulkloading, but try

options msglevel=i sastrace=',,,d' sastraceloc=saslog nostsuffix;

It might give you some more hints in the log.

Re: DB2 Bulk table loader in sas di error

JBailey — Thu, 16 Mar 2017 12:46:55 GMT

Hi @Riteshdell

This is definitely a client side configuration problem. Upgrading the DB2 server and failing to do the BIND step can cause a working connection to fail like this. DB2 client side configuration can be rather complicated. Here is a doc describing DB2 binding:

DB2 Connect - Binding Applications and Utilities

I used to be a DB2 DBA in a previous life and I think it is safe to say that getting your DB2 DBA to handle this issue is the way to go.

Best wishes,

Jeff