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 would the varchar column remarks defined?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
How are write I/Os from the buffer pool executed?
What is the physical storage length of time data type?
What is multi row fetch in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What information is used as input to the bind process?
What is ibm db2 database?
What is QUIESCE?
how can u retrieve the data from null values using applicaion program.
Can SQL statements/queries be included in a copybook?