What is an intent lock?

Answers were Sorted based on User's Feedback



What is an intent lock?..

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

What is an intent lock?..

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

What is an intent lock?..

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

Post New Answer

More DB2 Interview Questions

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  


what is the responsibility of the construction superintendent

0 Answers   Almco,


insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,


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.

0 Answers   IBM,


How to select the duplicate rows from a table?

4 Answers  






What is PRIME TABLE and what are the uses of it

1 Answers  


What does an outer join do?

1 Answers   CTS,


What is REORG? When is it used?

4 Answers  


What is page size in db2?

0 Answers  


What is DB2 (IBM Database 2)?

3 Answers  


How to update more then one record using update?

5 Answers   IBM,


What is a plan and package in db2?

0 Answers  


Categories