Searching for "deadlock"

Q:

What does a deadlock mean in DB2?

Answer

When two independent processes contend for the same resource or the resources reserved by one another, it is called a deadlock. -911 and -913 are the SQLcode for a deadlock.

Report Error

View answer Workspace Report Error Discuss

Q:

What do you mean by a deadlock?

Answer

 - When two processes are waiting to update the rows of a table which are locked by another process, the situation is called a deadlock.
 - The reasons for it to happen are:
 * lack of proper row lock commands.
 * Poor design of front-end application
- It reduces the performance of the server severely.
- These locks get automatically released automatically when a commit/rollback operation is performed or any process is killed externally.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

What is a Safe State and what is its use in deadlock avoidance?

Answer

When a process requests an available resource, system must decide if immediate allocation leaves the system in a safe state. System is in safe state if there exists a safe sequence of all processes. Deadlock Avoidance : ensure that a system will never enter an unsafe state.

Report Error

View answer Workspace Report Error Discuss

Q:

What are deadlock prevention techniques?

Answer

Mutual exclusion


Hold and wait


No preemption


Circular wait

Report Error

View answer Workspace Report Error Discuss

Q:

What is a deadlock?

Answer

Deadlock is a situation where a group of processes are all blocked and none of them can become unblocked until one of the other becomes unblocked. The simplest deadlock is two processes each of which is waiting for a message from the other.

Report Error

View answer Workspace Report Error Discuss