Page 1 of 1
ds_ipcflush() - Error in mutex_unlock() - Not owner
Posted: Mon Jan 12, 2009 9:41 am
by devanars
Hi
Can any one let me know how to resolve this error
ds_ipcflush() - Error in mutex_unlock() - Not owner
source db2 target oracle 10g collecting rejected records at the target stage. no transformation in between.
Thanks in advance
Posted: Mon Jan 12, 2009 10:55 am
by chulett
Turn off row buffering? Also, did you try searching for your error message here? You're not the first to encounter it...
Posted: Mon Jan 12, 2009 11:30 am
by devanars
Throughput went 3 rows per sec if turn off row buffering. Is there any other way to know.
Thanks
Posted: Mon Jan 12, 2009 12:00 pm
by chulett
Figure out which side is your bottle-neck, then you can (perhaps) do something to improve things. Split the job in two and land the data, that way you'll know how much of the 'slowdown' is the extract and how much is the load. My money is on the load.
What stage are you using for the Oracle side? What options there?
Posted: Mon Jan 12, 2009 1:39 pm
by ray.wurlod
Server job (as posted) or parallel job (as marked)? In either case a
Search should reveal some useful information.
Posted: Mon Jan 12, 2009 1:44 pm
by devanars
source as db2 api --- Transformer --- target as oracle enterprise.just a simple transformation.
Posted: Mon Jan 12, 2009 1:50 pm
by chulett
Yes, but what are you doing in the Oracle Enterprise stage?
Posted: Mon Jan 12, 2009 2:06 pm
by ray.wurlod
Moderator: please move to parallel forum
Posted: Mon Jan 12, 2009 2:41 pm
by devanars
Doing Upsert
also the error coming like ds_ipcput() - timeout waiting for mutex
Please give me an advise to rectify this.
Thanks