BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
General Notice: No events within the next 45 days.

Getting Bulk Loader to work with DB2


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
George
Principal Member
Principal Member



Joined: 27 Jun 2003

Posts: 275
Location: London


flag
PostPosted: Fri Aug 26, 2011 8:37 am 
Post subject: Getting Bulk Loader to work with DB2

When I try the Load / Import method I get the following error:

Code:
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:

Code:
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

Are there any other settings I need to check?

Thanks in advance.

_________________
My photos - www.georgeandreou.net
Back to top
Jibc
Forum Member
Forum Member



Joined: 20 Jul 2011

Posts: 27


flag
PostPosted: Mon Feb 24, 2014 5:13 am 
Post subject: Re: Getting Bulk Loader to work with DB2

Hi,

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.

Where can I investigate ?

Tank you

Jib
Back to top
jacobpauls
Forum Member
Forum Member



Joined: 07 May 2019

Posts: 1



PostPosted: Tue May 07, 2019 4:08 pm 
Post subject: Re: Getting Bulk Loader to work with DB2

Hi I am also facing the same problem

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 <ODR> error message for operation <CLILoadOn>: <[IBM][CLI Driver] CLI0150E Driver not capable.
SQLSTATE=S1C00>.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0283 seconds using 18 queries. (SQL 0.0032 Parse 0.0009 Other 0.0242)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo