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 the command used by TSO users to invoke DB2?
What does reorg do in db2?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What are common abends
What if we fail to give values in columns declared as NOT NULL ?
What is db2 connect?
What is a DB2 access path?
What is a storage group (stogroup)?
How can record locking be achieved in those DB2 versions which do not support it?
What db2 400?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).