Bulk load in db2

gowrishankar_h · Post by **gowrishankar_h** » Sat May 10, 2014 4:54 am

Hi Datastager,

While iam trying to do bulk load in db2 which is installed on z/os.

I have set Bulk load to db2 on z/os =yes
Load method =mvs dataset

While running the job iam getting the following error.

Db_Grouping,0: Write failed with error 32: Broken pipe (CC_DB2Utils::writeToPipe, file CC_DB2Utils.cpp, line 1,625)
550-SVC99 RETURN CODE=4 S99INFO=0 S99ERROR=38656 HEX=9700 S99ERSN code X'000003E9'.
cat: write error: Broken pipe
(CC_DB2ZLoadRecordDataSetConsumer::complete, file CC_DB2ZLoadRecordDataSetConsumer.cpp, line 3,463)

Please let me know who we can avoid this error and run our job without any issue.

Thanks,
Gowri shankar H

chulett · Post by **chulett** » Sat May 10, 2014 6:37 am

Hmmm... guessing you'll need to involve your official support provider on that one. Are you using the DB2 Connector?

Mike · Post by **Mike** » Sat May 10, 2014 7:39 am

Since you seem to be getting some kind of write failure error, make sure that you have the appropriate permissions to create that MVS dataset that you've specified in the load method.

Mike

qt_ky · Post by **qt_ky** » Sat May 10, 2014 8:56 am

How quickly does it abort? How large does the file get before aborting?

Check for possible operating system file size limits or user-imposed file size limits (i.e. 2 GB limit) on the system where the file is being written. If that's causing the abort, work with your admin to increase or remove the limits.

gowrishankar_h · Post by **gowrishankar_h** » Mon May 12, 2014 12:43 am

Yes iam using DB2 Connector stage...I couldnt see in error that says acces or permission denied the error says broken pipeline....actually we do truncate and bulk loak so takes some 1 min to truncate after that within few seconds we are getting this error and not moving further but job is not aborting unless we manually do....

qt_ky · Post by **qt_ky** » Mon May 12, 2014 6:10 am

I was assuming that the load method mentioned actually lands a temporary data file somewhere in the background. The broken pipe error can possibly be a result of an operating system imposed file size limit (i.e. 2 GB limit). If it aborts within a few seconds then it is probably caused by something else. I'm sure the broken pipe error can have many other causes too. It may still be worth verifying that you are able to create large files OK.

clarcombe · Post by **clarcombe** » Mon Nov 28, 2016 4:48 am

We had this error and it took me a week to discover the solution.

ftp was not installed. Check your ftp configuration before continuing to search