What is concurrency in db2?
- 1 Answers
- 1783 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 is + sign and -ve sign for sql code ?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
Define predicate?
What is the physical storage length of time data type?
Explain packages.
Where do you specify them?
What is pagespace?
How do you find the maximum value in a column in db2?
What is the picture clause of the null indicator variable?
What is the use of predicate?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
What is the connection string to connect to the DB2 Database ?
COBOL 
