Answer / s

You do not want to define an index on such a small table
because, its an overhead to maintain the index and
tablespace scan will only result in 1 I/O.

When do you use the IMAGECOPY?

4 Answers  

---

what are stage one indexable predicates?

1 Answers  

---

What is concurrency?

0 Answers  

---

When can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,

---

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

0 Answers  

---

---

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 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,

---

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

1 Answers   IBM,

---

what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---