Answer Posted / vasuki🐍
Concurrency is the ability of more than one application process to access the same data at essentially the same time.
However, DB2 use locks to control concurrency to prevent lost updates and such possibly undesirable effects as unrepeatable reads and access to uncommitted data.
locks ensure that no process accesses data that has been changed, but not yet committed,
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Mention some fields that are a part of sqlca.
What action db2 takes when a program aborts in the middle of a transaction?
Is ibm db2 free?
Explain dclgen.
What is load utility in db2?
How do I connect my db2 database to ibm?
What are the various data types available in db2?
Mention the location where the output received from explain statement is stored.
Give the name of some fields form sqlca.
How do you stop a db2 database in linux?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is rebind in db2?
What is the use of reorg in db2?
How to rename a table in DB2 ?