Answer / s

Only one clustering index can be defined.

Answer / mehdee

Yes Only one clustering index can be defined.And reason is
Clustered indexe is created to order the rows in the
DB2 table in the same physical order as the desired result
from the indexe. And if we do not use this option, DB2 will
come up with one to do this ordering rows.

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  

---

what is the use of cursors?

3 Answers   iGate,

---

What is the use of runstats in db2?

0 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

Why might full image copies be faster to implement than an incremental image copy?

4 Answers  

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

What is DCLGEN ?

3 Answers  

---

Which catalog table stores referential constraints?

1 Answers  

---

Give a brief description of db2 isolation levels?

0 Answers  

---