What is an intent lock?
Answers were Sorted based on User's Feedback
Answer / s
Intent lock is a lock taken at the tablespace or table
level and indicates the type of locks are held at the lower
levels, page or row.
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / vat
When using Page or Row locks, the table or tablespace lock
will be IS/IX/SIX
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / mahesh
In Intent locking only the intention of locking is
expressed at the ancestor node of the required resource and
the resource at the lower level is locked explicitly only
when required.
| Is This Answer Correct ? | 4 Yes | 2 No |
What is isolation level?
Define buffer pool.
What's The Error Code For Unique Index Voilation?
Describe major components of db2?
What is the difference between cursor and select statement?
Is db2 a programming language?
What is image copy?
Can you access the DB2 Directory table using SQL?
What is dclgen (declaration generator)?
Which catalog tables contain authorization information?
Is Cursor exicutable ?
What is the difference between Primary key and unique index?