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 |
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
On which levels locks can be applied?
how to copy the host variables from ps file into cobol program other than include statement
What is runstats utility in db2?
How to see the structure of db2 table??
What is ibm db2 used for?
What is the meaning concurrency in the db2 database?
How to compare data between two tables in db2?
Can you search give an array in the WHERE clause of a db2 query?
What are the four lockable units for DB2?
What is db2 bind?