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 |
How and when does the db2 enforces the unique key?
What are the prerogatives?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What is the maximum size of a char data type in db2?
What is dclgen (declaration generator)?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
How to execute stored procedures?
What do you mean by NOT NULL? When will you use it?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What is the syntax of SELECT statement when embedded in a COBOL program?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
is it possible to get -811 error when you use cursors. why?