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
What is db2 command?
What happens in bind step in a db2 program?
What do you mean by cursor?
What are the two types of logging in the db2 database? Explain them.
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How to find the number of rows in db2 tables?
What is the purpose of rollback and commit?
What is the physical storage length of the data types date, time, and timestamp?
Is schema the same as database?
What is the physical storage length of date data type?
Give the name of some fields form sqlca.
How to find primary key of a table in db2?
Is the primary key a clustered index?
What is blu acceleration in db2?
Define data page.
