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 |
What is a db2 collection?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What are the isolation levels possible ?
What is the significance of DB2 free space and what parameters control it?
How do I copy a table in db2?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
How to create backup table in db2?
Why do chiropractors use drop table?
What is data manager?
What is a Database Request Module(DBRM)?
What are the disadvantages of PAGE level lock?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?