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 |
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
what is the responsibility of the construction superintendent
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How to select the duplicate rows from a table?
What is PRIME TABLE and what are the uses of it
What does an outer join do?
What is REORG? When is it used?
What is page size in db2?
What is DB2 (IBM Database 2)?
How to update more then one record using update?
What is a plan and package in db2?