Facing issue in DB2 connector in 8.7 bulk load

srini27 · Post by **srini27** » Thu Sep 11, 2014 1:32 pm

Hi all,

while executing the job in datastage 8.7 .while loading the data into DB2the below errors are coming

Error 9 occurred while closing the named pipe.
The DB2 Load API call failed with SQLCODE -668.
Error 88 occurred while writing to the name

Looking forward for your help

Thanks
Srini..

chulett · Post by **chulett** » Thu Sep 11, 2014 1:43 pm

Did you look up that error code? Seems a strange one to be coming from a bulk load, are you certain you have all of your metadata correct?

Note that I'm not familiar with DB2 so perhaps it will make more sense to others out there.

PaulVL · Post by **PaulVL** » Thu Sep 11, 2014 2:22 pm

Do you have a cluster environment or grid?

What is your TEMPDIR Project Level environment variable set to?
Do you have write permission to that path on each server defined in your APT file?

Please tell me it's local SAN rather than NAS or some other Clustered File System mount.