DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic is not resolved, but there is a WORKAROUND.
Author Message
mmaric



Group memberships:
Premium Members

Joined: 30 Nov 2009
Posts: 20

Points: 221

Post Posted: Fri Dec 18, 2009 10:19 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Server
OS: Unix
Additional info: and UVTEMP is changed
Hi all,
I am running into another problem with DB2 Bulk Load.
If pipe is used as method it appears that datastage creates one fifo file for all loads and it is created in /tmp folder by default. File is called udbpipe.
The problem is that file is created and owned by user that runs first datastage job. If another user runs the same or different job it fails.
It looks like datastage is trying to delete and recreate fifo file but /tmp folder has sticky bit and it can not be deleted by different user. I did change UVTEMP in uvconfig to point to another folder but udbpipe file is still being created in /tmp folder.
Ideally I would like to set this up on the project level but do not know if that is possible at all.
Any help on this would be appreciated.

Regards
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 51954
Location: Las Vegas
Points: 282080

Post Posted: Fri Dec 18, 2009 2:50 pm Reply with quote    Back to top    

I don't think /tmp can be changed (but do feel free to issue an enhancement request). Try changing the value of the TMPDIR environment variable in Administrator client. If you make users' umask ...

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



Group memberships:
Premium Members

Joined: 30 Nov 2009
Posts: 20

Points: 221

Post Posted: Wed Dec 23, 2009 1:34 pm Reply with quote    Back to top    

Thanks Ray,
I did try to change TMPDIR environment variable in Administrator client.
but it did not make any difference. I guess I will have to leave with tmp folder. UVTEMP changes some things but not this one. I am in contact with IBM now and if any relolution is found I will post it here.

Marinko
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