DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
raji33



Group memberships:
Premium Members

Joined: 23 Sep 2010
Posts: 149
Location: NJ
Points: 1237

Post Posted: Sun May 20, 2018 7:44 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54200
Location: Sydney, Australia
Points: 293961

Post Posted: Sun May 20, 2018 10:09 pm Reply with quote    Back to top    

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?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
raji33



Group memberships:
Premium Members

Joined: 23 Sep 2010
Posts: 149
Location: NJ
Points: 1237

Post Posted: Mon May 21, 2018 4:20 am Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2748
Location: USA
Points: 20598

Post Posted: Mon May 21, 2018 4:49 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours