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 a dbrm in db2?

1007

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1170

---

Mention the various locks that are available in db2.

1024

---

What is the syntax for FETCH in DB2 ?

1187

---

What does runstats do in db2?

1082

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

1042

---

What is cloudant database?

1077

---

Who uses db2?

1024

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2311

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2904

---

Define db2.

1096

---

What is ibm db2 database?

989

---

What is buffer pool in the db2 database?

1080

---

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

1108

---

What are the contents of a dclmgen?

1103

---