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: 151
Location: NJ
Points: 1245

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: 54287
Location: Sydney, Australia
Points: 294450

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: 151
Location: NJ
Points: 1245

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: 2798
Location: USA
Points: 21145

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
raji33



Group memberships:
Premium Members

Joined: 23 Sep 2010
Posts: 151
Location: NJ
Points: 1245

Post Posted: Mon May 28, 2018 4:09 pm Reply with quote    Back to top    

yes its the same user.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42677
Location: Denver, CO
Points: 219803

Post Posted: Mon May 28, 2018 5:52 pm Reply with quote    Back to top    

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.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1249

Points: 8216

Post Posted: Tue May 29, 2018 8:40 am Reply with quote    Back to top    

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?
Rate this response:  
Not yet rated
raji33



Group memberships:
Premium Members

Joined: 23 Sep 2010
Posts: 151
Location: NJ
Points: 1245

Post Posted: Wed May 30, 2018 12:12 pm Reply with quote    Back to top    

we are writing the named pipe files to scratch location as we have more space there.
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