What is deadlock in db2?



What is deadlock in db2?..

Answer / Yatendra Kumar Shakya

A deadlock in DB2 occurs when two or more database transactions are waiting for each other to release resources, leading to a standstill. To resolve deadlocks, you can use the 'DB2DEADLOCK' command, which allows you to monitor and kill deadlocked processes.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

How is deadlock resolved?

1 Answers  


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


What is a precompiler?

2 Answers  


DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,


How to execute stored procedures?

1 Answers  


What is dclgen (declaration generator)?

1 Answers  


how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,


How do I import a csv file into db2?

1 Answers  


Which catalog tables contain authorization information?

1 Answers  


What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,


What is temporal table in db2?

1 Answers  


What is a page?

2 Answers  


Categories