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.
options msglevel=i sastrace=',,,d' sastraceloc=saslog nostsuffix;
It might give you some more hints in the log.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
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.