Answer Posted / 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

What is ibm db2 client?

1006

---

What is the difference between dbm cfg and db cfg file in db2 ?

1591

---

Are views updateable?

1234

---

What is the difference between bind and rebind in db2?

1511

---

What r the comman abends in db2, jcl and cobol???????

2309

---

Which command is used to remove all rows from a table?

1183

---

How is deadlock resolved?

1204

---

What is dbrm? When it will be created?

1089

---

What is dpf in db2?

1167

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1788

---

How do you eliminate duplicate values in db2?

1268

---

How and when does the db2 enforces the unique key?

1143

---

What are the uses of db2 optimizer?

1358

---

What is a page in db2?

1074

---

How to retrieve rows from a db2 table in embedded sql?

1444

---