Interested to Buy Any Domain ? << Click Here >> for more details...
What is an intent lock?
- 3 Answers
- 10640 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 |
How can you quickly find out the # of rows updated after an update statement?
what are the SQL codes u freequently got?
why we go for SPUFI for creating tables or for sql queries?
What is an instance in db2?
How do you pull up a query which was previously saved in qmf?
How Plan is created while executing the query using SPUFI?
Explain the use of the WHERE clause?
What's The Error Code For Unique Index Voilation?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
Can we update view in db2?
what is the difference between where clause and having clause
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
COBOL 
