Interested to Buy Any Domain ? << Click Here >> for more details...
What is concurrency in db2?
- 1 Answers
- 2189 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 |
Explain about open switch business continuity software?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
how to copy the host variables from ps file into cobol program other than include statement
What is temporal table in db2?
How to update more then one record using update?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
How to restart a DB2 program?
What is scrollable cursor in db2?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
What is a dbrm in db2?
COBOL 
