Interested to Buy Any Domain ? << Click Here >> for more details...
What is an intent lock?
- 3 Answers
- 10689 Views
- I also Faced
- E-Mail Answers
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 db2 restart?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
how to fetch first 100 rows in db2
What are the 4 environments which can access DB2 ?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
What is view db2?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is a recovery log?
How to take backup of table in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
COBOL 
