Answer / mohammadanis

DB2 Isolation is locking technqiue for tables.It can given
while binding the programs. There are several Isolation
levels are there,

1 CS(cursor stability)
2 RR(repeatable read)
3 RS(READ Stability)
4 UR(Uncommited read also known as Dirty read

Answer / bala

Isolation by its name explains the level by which two or more concurrent transactions are isolated from each other to maintain the data integrity in the database.

for example transaction A and transaction B are concurrent transactions, then it defines if A can read/update the data being modified by B or not and vice versa.

These Isolation levels will be used based on the business logic.

Explain package in db2 and its advantages?

0 Answers  

---

How to find last record before record through SQLRPGLE?

1 Answers   IBM,

---

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

1 Answers   TCS,

---

How to fetch the last row from the table in SQL (db2)?

0 Answers  

---

In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,

---

---

What is meant by a unit of recovery?

1 Answers  

---

What is the purpose of the QUIESE Utility?

1 Answers  

---

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

---

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

1 Answers  

---

What is a base table?

2 Answers  

---

What is a db2 collection?

0 Answers  

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---