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,

what are the SQL codes u freequently got?

2 Answers   Logica CMG,

---

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

---

What is the role of the data page in the db2 database?

0 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

What is netezza database?

0 Answers  

---

Explain what a plan is?

3 Answers   CTS,

---

What is check constraint in db2?

0 Answers  

---

Can any one tell me about Restart logic in DB2.

2 Answers  

---

How many types of page locks can be held in db2?

0 Answers  

---

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?

8 Answers  

---

What is difference between isnull and coalesce?

0 Answers  

---