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 |
How to take backup of table in db2?
How many clustering indexes can be defined for a table?
what is copy pending and check pending ?
What technique is used to retrieve data from more than one table in a single SQL statement?
What is the use of commit in db2?
What is the difference between static and dynamic SQL?
How do you find the maximum value in a column in db2?
What are foreign keys in db2?
how to get duplicate records from tables?write qurey for this?
what is cursor stability?
wht r the requirements for writing a cobol-db2 pgm ?
What is referential integrity?