I use CS and update a page. Will the lock be released after
I am done with that page?
Answers were Sorted based on User's Feedback
Answer / m4io
No.
An update takes an exclusive lock. These persist until
commit.
Only shared locks will be released when you move away from
the page.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / s
Yes, the CS lock is held until the application locks the
next page.
| Is This Answer Correct ? | 2 Yes | 4 No |
Q3. How will you fetch duplicate values from a DB2 table?
What is bind in db2?
How do you do the EXPLAIN of a dynamic SQL statement?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
What is the error code -803 ?
What is REORG? When is it used?
What is db2 and what is the use of db2 optimizer?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is subquery ?
What is syscat in db2?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
How to resolve -917 sql code in DB2?