we are having difficulties loading to DB2 .
seq file --DB2
The error message is
DB2load,6: Failed to prepare buffer for writing record #3265. Reason: write() failed: Broken pipe
DB2load,6: The runLocally() of the operator failed.
any help is appreciated.
thanks
write failed : broken pipe
Moderators: chulett, rschirm, roy
I've seen the same problem when doing loads into Oracle. The "broken pipe" message usually comes up when Oracle's SQL*Loader has problems doing its work (a full tablespace, for example).
I would imagine that the DB2 equivalent is having similar problem during the load in your case.
To troubleshoot the specific cause, I look in the directories that we've set up for parallel scratch space. Oracle SQL*Loader control and log files will be in that directory. DB2 log files will probably be in the same place. Try taking a look there. The log file may give you an indication of what went wrong.
I would imagine that the DB2 equivalent is having similar problem during the load in your case.
To troubleshoot the specific cause, I look in the directories that we've set up for parallel scratch space. Oracle SQL*Loader control and log files will be in that directory. DB2 log files will probably be in the same place. Try taking a look there. The log file may give you an indication of what went wrong.