What is concurrency in db2?
- 1 Answers
- 1065 Views
- I also Faced
- E-Mail Answers
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 is the name of the default db2 catalog database?
What is copy book?
What are the 4 environments which can access DB2 ?
What is a composite index and how does it differ from a multiple index?
How do I connect my db2 database to ibm?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
is there any restrictions for unions ?
On which levels locks can be applied?
Which transaction use a command thread ?
What is a lock?
COBOL 
