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
What db2 400?
What is blu acceleration in db2?
what is the sqlcode -501
What action db2 takes when a program aborts in the middle of a transaction?
How can you count the number of rows from a table tab?
What is reorg?
What are the two types of logging in the db2 database? Explain them.
What is a collection in db2?
Discuss about db2 bind?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is cursor with hold option in db2?
What are the various data types available in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
what is db2 restart?
Outputs of explain are with matchcols = 0. What does this signify?