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 |
Give the name of some fields form sqlca.
What is the purpose of using commit?
Is it possible to precompile if db2 goes down?
Which are the db2 tools to protect integrity of the database?
what is static sql? what is dynamic sql? Give me details
is it possible to get -811 error when you use cursors. why?
What is a collection?
What is EXPLAIN?
what is difference between Plan and Package
Is DECLARE TABLE in DCLGEN necessary? Why it used?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
What is the maximum No of rows per page?