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 |
is it compulsory commitment control in journal?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
How do I optimize a query in db2?
what is db2 restart?
Define db2.
List down the data types in the db2 database.
What are the Isolation levels possible ?
What are some SQL aggregates and other built-in functions?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is runstats db2?
What is a Resource Control Table(RCT)? Describe its characteristics.
What is the difference between CS and RR isolation levels?