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
How can we read records for specific member in CL? AND rpg?
What are the various isolation levels possible?
What types of tables are there in the db2 database?
Define sqlca.
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What's The Error Code For Unique Index Voilation?
What is the physical storage length of timestamp data type?
Explain in brief how does db2 determine what lock-size to use?
What is the advantage in De-normalizing tables in DB2?
What are the different types of base tables?
is it compulsory commitment control in journal?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How to create db2 table in mainframe?
Define db2.
What is the clustering index in the db2 database?