No. An update takes an exclusive lock. These persist until commit. Only

I use CS and update a page. Will the lock be released after
I am done with that page?

Question Posted / m4io

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

Please Help Members By Posting Answers For Below Questions

Explain in detail about buffer manager and its functionalities?

993

How does a cursor work?

929

What is ibm db2 database?

951

Define sqlca.

1055

How to resolve deadlock issue

19864

What is image copy in db2?

944

What does a deadlock mean in DB2?

1095

What is netezza database?

959

What are the uses of db2 optimizer?

1223

How to fetch the last row from the table in SQL (db2)?

1588

What is multi row fetch in db2?

986

Is db2 a database?

911

Explain various types of locks in db2?

1081

Where can you declare a cursor in a cobol-db2 program?

995

Outputs of explain are with matchcols = 0. What does this signify?

991