Deadlock situation

reddy · Post by **reddy** » Thu Jul 14, 2005 5:34 am

Hello Sirs,

Can i avoid Deadlock situation with Transaction Isolation levels.

Please help me on different Isolation levels when and where to use.

Thanks
Narasa

ray.wurlod · Post by **ray.wurlod** » Thu Jul 14, 2005 6:09 am

Not really. Deadlocks are avoided by disciplined programming practices.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 14, 2005 6:21 am

Deadlock requires stremlining your data access. You can control your job but cannot control other areas in the Org that will lock the db.

Isolation levels are ansi standard mechanism to handle data access.

reddy · Post by **reddy** » Thu Jul 14, 2005 6:42 am

Hello Sirs,

Suppose somebody else updating table with table lock or record lock
then Datastage job waits for some time or aborts.
one morething is if it is record lock what i observed is datastage job
rejecting locked rejects.

Please explain me still i am confusing state

Thanks a lot
Narasa

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 14, 2005 7:03 am

Those configurations are set by your DBA. Ask your DBA for the answers.