What is concurrency in db2?
Answer / 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 |
What are the full forms of spufi and dclgen and why are they used?
How and when does the db2 enforces the unique key?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
Request to database but database is not available so what is was abend is raised?
What is ibm db2 client?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
Is ibm db2 open source?
What is the difference between Primary key and unique index?
What is the difference between dbm cfg and db cfg file in db2 ?
On which levels locks can be applied?
how to copy the host variables from ps file into cobol program other than include statement
Give a brief description of db2 isolation levels?