I use CS and update a page. Will the lock be released after
I am done with that page?
Answer Posted / 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 |
Post New Answer View All Answers
Is schema the same as database?
What is coalesce in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Which component is responsible for processing sql statements and selecting access paths?
How do we specify index to include or not during bind process.
How to retrieve rows from a db2 table in embedded sql?
How to restart a DB2 program?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is explain plan in db2?
Can one database have multiple instances?
How will you return the number of records in table?
Is ibm db2 free?
What is difference between rollback and commit?
What does a deadlock mean in DB2?
List some fields from sqlca?