Page 1 of 1

Facing issue in DB2 connector in 8.7 bulk load

Posted: Thu Sep 11, 2014 1:32 pm
by srini27
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..

Posted: Thu Sep 11, 2014 1:43 pm
by chulett
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.

Posted: Thu Sep 11, 2014 2:22 pm
by PaulVL
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.