DSXchange

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

Not really. Deadlocks are avoided by disciplined programming practices.

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.

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

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