Answer / s

Isolation level can be specified at BIND time using the
ISOLATION parameter or in the SQL statement using the WITH
clause

WITH UR;

Which component is responsible for db2 startup and shutdown?

0 Answers  

---

What is the clustering index in the db2 database?

0 Answers  

---

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

what are the bind parameters?

5 Answers   IBM,

---

---

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  

---

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,

---

Name the different types of Table spaces.

5 Answers   IBM,

---

Explain the function done by data manager?

0 Answers  

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

Why do we need reorg in db2?

0 Answers  

---

What does runstats do in db2?

0 Answers  

---