Job Hang up, Update Oracle query Problem

[gnan_gun]

My Job design flow is:
Extract the records from Oracle table.
Lookup the source records to DOM_DATA table where DOM='FIN'.
If any records matches then update the record in DOM_DATA column FLAG to 'N'. and Insert the same record in DOM_DATA table with DOM column value 'RET'.
If Unmatched then have to check data in DOM_DATA table with DOM='RET' and see is there any updates/inserts/deletes. For this Before set data extracting from RET_DATA table WHERE DOM='RET'.

I am doing all these tasks in one job. But the job is going to hangup. When i am deleting update stage of FLAG to 'N' with datastage stage its working fine. there are multiple records with same id in target table.
and again created another job for updating the DOM_DATA with FLAG='N'
But it is also hangup.

Please help me to solve the problem.

Thanks in Advance

[richdhan]

Hi,

This type of hangs usually happens when there is some kind of record locking. You do a delete. You do not commit and you issue an update command.

Did you try to sepearte the Delete and Update streams?

HTH
--Rich