fifo file always in /tmp

mmaric · Posted: Fri Dec 18, 2009 10:19 am

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 · Posted: Fri Dec 18, 2009 2:50 pm

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 ...

What's this?

mmaric · Posted: Wed Dec 23, 2009 1:34 pm

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