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 the physical storage length of the data types: date, time, timestamp in the db2 database?
What is clone table?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
When is the authorization check on DB2 objects done - at BIND time or run time?
What is the connection string to connect to the DB2 Database ?
what are extents?
What can the Locate option of the Repair Utility accomplish?
explain about index with examples
Where are plans stored?
Can we delete records from view?
What is db2 instance?
How to connect to db2 database from windows command line?