Interested to Buy Any Domain ? << Click Here >> for more details...
What is concurrency in db2?
- 1 Answers
- 2120 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 does db2 blu stand for?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What is query_cache_limit?
What are the contents of a dclmgen?
What is cascading rollback?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
When DB2 connection fails, will online program work or give errors.
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Comment whether the cursor is closed during commit or not.
What is a page?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What are foreign keys?
COBOL 
