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 |
How to resolve -917 sql code in DB2?
how can i pull up a query which was previously stored in qmf
How do you Load a table ?? and what is Load replace ?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is a bind card?
What is difference between alias and synonym in db2?
What is catalog database in db2?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What is clone table?
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....
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is plan in cobol db2?