How to resolve deadlock issue

Answer Posted / bala

Dead lock occurs when two jobs/transactions are waiting for the resources from each other and gets locked up.
Transaction A cannot proceed further until Transaction B is complete
similary Transaction B cannot proceed until Transaction A is complete.

To solve this issue, one of the transaction should be stopped for other transaction to proceed successfully.

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cloudant database?

641


What is a db2 package?

597


Explain the contention situations caused by locks?

589


How to execute stored procedures?

618


What is dclgen in db2?

674






What is the syntax for creating a table in the db2 database?

626


what is db2 restart?

1689


How do I import a csv file into db2?

558


What is cursor stability in db2?

805


Where do you specify them?

678


How can the duplicate values be eliminated from db2 select?

621


How can you do the explain of a dynamic sql statement?

635


How to run db2 command in windows?

643


How do I add a column to a table in db2?

616


Where can you declare a cursor in a cobol-db2 program?

602