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
error while loading db2
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: error while loading db2
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.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Re: error while loading db2
Those two statements seem a bit contradictory to me.raji33 wrote:The user has all the required permissions. If i point the location somewhere else , the job run successfully.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers