When I try the Load / Import method I get the following error:
DB2 bulk loader did not start successfully. Please notify Customer Support.
after processing 4,000,000 rows.
If I use the CLI method I just get:
CLI0150E Driver not capable.
I am using an ODBC connection to connect to the DB2 target from an Oracle source.
I’ve set the Datastore properties to use the same user name and password for the bulk loader as for the schema. I’ve also entered a location for the files: /home/db2m3dv6
I have the same issue.
After proceeding 2’000’000 rows, I get the message “DB2 bulk loader did not start successfully” with the “Load” bulk method and replace mode.
When I use “CLI Load”, I get an access violation error in BODS.
I am using BODS 12.2.3 and DB2 9.x with ODBC DB2CLI driver 9.05.400.576.
Any idea ?
According to the DB2 DBA, the correct rights are set in the target database.
Does anybody know the resolution
I am using SAP BODS 4.2.9 and DB2 version 11
(14.2) 05-07-19 18:01:03 (W) (20259:395433728) DBS-120604: |Data flow New_DataFlow6|Loader Query_JACOB_TEST
Warning: DB2 bulkloader used datastore using name and password.
(14.2) 05-07-19 18:01:03 (E) (20259:395433728) DBS-070401: |Data flow New_DataFlow6|Loader Query_JACOB_TEST
ODBC data source error message for operation : <[IBM][CLI Driver] CLI0150E Driver not capable.
SQLSTATE=S1C00>.
(BOB member since 2003-06-27)
(BOB member since 2011-07-20)