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
Bulk load in db2
Moderators: chulett, rschirm, roy
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.
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.
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 42
- Joined: Wed Dec 26, 2012 1:13 pm
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....
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.
Choose a job you love, and you will never have to work a day in your life. - Confucius