error while loading db2

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
raji33
Premium Member
Premium Member
Posts: 151
Joined: Thu Sep 23, 2010 9:21 pm
Location: NJ

error while loading db2

Post by raji33 »

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
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
raji33
Premium Member
Premium Member
Posts: 151
Joined: Thu Sep 23, 2010 9:21 pm
Location: NJ

Re: error while loading db2

Post by raji33 »

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.
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

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
raji33
Premium Member
Premium Member
Posts: 151
Joined: Thu Sep 23, 2010 9:21 pm
Location: NJ

Post by raji33 »

yes its the same user.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: error while loading db2

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

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?
raji33
Premium Member
Premium Member
Posts: 151
Joined: Thu Sep 23, 2010 9:21 pm
Location: NJ

Post by raji33 »

we are writing the named pipe files to scratch location as we have more space there.
Post Reply