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 run db2 command in windows?
What information is held in SYSIBM.SYSCOPY?
When is the results table for the query in a DECLARE CURSOR statement created?
What are simple, segmented and partitioned table spaces ?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What is an inner join, and an outer join ?
Explain db2.
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What is the database descriptor?
What is the STOSPACE Utility used for?
Describe the elements of the SELECT query syntax?
What is a base table?