Explain db2.

0 Answers  

---

What is Reorg Recovery? when will you run it?

2 Answers  

---

Is there any advantage to denormalizing DB2 tables?

1 Answers  

---

What is the function of logging in the db2 database?

0 Answers  

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

Is the primary key a clustered index?

0 Answers  

---

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,

---

What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---