Interested to Buy Any Domain ? << Click Here >> for more details...
Mention and explain the contention situations caused by locks?
- 1 Answers
- 1481 Views
- I also Faced
- E-Mail Answers
Answer Posted / ereshwari
Lock Contention can lead to:
1. Suspension
2. Timeout
3. Deadlock
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is runstats and reorg in db2?
How do I change the column size in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
When reorg is used?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is db2 bind process?
What is a db2 table?
What is rct?
List out the three types of page locks that can be held.
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How to create backup table in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is a db2 package?
What is a dbrm in db2?
can we view the access paths created by dbrm ? how ? thx
