DSXchange

Hello,

We have a error while doing bulk load to db2 table.
Any suggestions please.

Error 2 occured from mkfifo while creating named pipe.
same job is working fine in other project.

Job Design

Dataset-------db2udb

i checked the space and also looked at permissions everthing looks good. i tried creating and deleting a pipe manually in that location and i can. Not sure what i am missing here.


Thanks

Are you able to verify the pathname of the directory in which mkfifo was attempting to create the named pipe file? And whether the executing process (that is, the user specified in Engine Credentials) has read, write and execute permission there?

Yes. i checked the path and it exists. The user has all the required permissions. If i point the location somewhere else , the job run successfully.

If you open the job with the error in Director and go to the log and double click a log entry and look at the value in the User field, is it the same user account you were expecting to find there? In some setups the users are mapped to other accounts.

yes its the same user.

raji33 wrote:The user has all the required permissions. If i point the location somewhere else , the job run successfully.

Those two statements seem a bit contradictory to me.

And what path would that be that the named pipe is using?

I believe it would be using whatever is defined in the TMPDIR project variable.

Are you sure that your APT file which may be using other hosts has a proper path and permission for all of the potential hosts?

we are writing the named pipe files to scratch location as we have more space there.