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 is deadlock in db2?
What is runstats and reorg in db2?
how we will do null data selection in cobol-db2 program
How does db2 sample database connect?
What's the maximum number of volumes that can be added to a STOGROUP?
What is query for your birthday date should be in hours,minute and seconds format?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How will you return the number of records in table?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Explain about mirror activator disk mirroring?
How to check sequence on a table in db2?