ds_ipcflush() - Error in mutex_unlock() - Not owner

devanars · Post by **devanars** » Mon Jan 12, 2009 9:41 am

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

chulett · Post by **chulett** » Mon Jan 12, 2009 10:55 am

Turn off row buffering? Also, did you try searching for your error message here? You're not the first to encounter it...

devanars · Post by **devanars** » Mon Jan 12, 2009 11:30 am

Throughput went 3 rows per sec if turn off row buffering. Is there any other way to know.

Thanks

chulett · Post by **chulett** » Mon Jan 12, 2009 12:00 pm

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?

ray.wurlod · Post by **ray.wurlod** » Mon Jan 12, 2009 1:39 pm

Server job (as posted) or parallel job (as marked)? In either case a Search should reveal some useful information.

devanars · Post by **devanars** » Mon Jan 12, 2009 1:44 pm

source as db2 api --- Transformer --- target as oracle enterprise.just a simple transformation.

chulett · Post by **chulett** » Mon Jan 12, 2009 1:50 pm

Yes, but what are you doing in the Oracle Enterprise stage?

ray.wurlod · Post by **ray.wurlod** » Mon Jan 12, 2009 2:06 pm

Moderator: please move to parallel forum

devanars · Post by **devanars** » Mon Jan 12, 2009 2:41 pm

Doing Upsert

also the error coming like ds_ipcput() - timeout waiting for mutex

Please give me an advise to rectify this.

Thanks