Interested to Buy Any Domain ? << Click Here >> for more details...
What is an intent lock?
- 3 Answers
- 10832 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 copy pending status in db2?
What are the isolation levels possible ?
On which levels locks can be applied?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
What is the difference between nvl and coalesce?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
What is the syntax of SELECT statement when embedded in a COBOL program?
db2 restart logic ?
What is isolation level in db2?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
COBOL 
