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 the use of commit in db2?

1073

---

What is the difference between oracle and db2?

1099

---

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1146

---

What is runstats utility in db2?

1018

---

What are the two types of logging in the db2 database? Explain them.

1071

---

How do you eliminate duplicate values in db2?

1172

---

What is a collection in db2?

1029

---

Explain what are the various isolation levels possible?

1041

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2042

---

Can there be more than one cursor open for any program?

1166

---

What is null in db2?

1019

---

What is meant by explain?

1125

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3152

---

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

1531

---

What is access path in db2?

982

---