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,

Mention the location where the output received from explain statement is stored.

0 Answers  

---

What is a plan and package in db2?

0 Answers  

---

What is db2? Explain.

0 Answers  

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

What is the difference between base table and view?

7 Answers  

---

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,

---

What is the maximum length of sqlca?

0 Answers  

---

What kind of database is db2?

0 Answers  

---

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,

---

Explain the use of the WHERE clause?

1 Answers  

---

What is a predicate?

1 Answers  

---