fifo file always in /tmp
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
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