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,

how can u nderstand the sql stmts executed successfully or not ?

1 Answers   TCS,

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

How would one remove old reorg information from the DB2 catalog?

2 Answers  

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

What is copy pending status in db2?

0 Answers  

---

What is image copy?

1 Answers   Virtusa,

---

What is an alias and how does it differ from a synonym?

3 Answers  

---

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  

---

What is a collection?

3 Answers  

---

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

---

Why db2 is called db2?

0 Answers  

---

What does db2 stand for?

0 Answers  

---