Answer Posted / sonu

Nice answer!!!!!!!!!!

What is syscat in db2?

983

---

How and when does the db2 enforces the unique key?

1068

---

How connect db2 database to datastage?

1218

---

Can one database have multiple instances?

1035

---

If I have a view which is a join of two or more tables, can this view be updateable?

1126

---

What are the full forms of spufi and dclgen and why are they used?

1061

---

What is db2 plan table?

1023

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1221

---

How to view db2 table structure?

1001

---

What is the physical storage length of timestamp data type?

1071

---

Are view updateable?

1020

---

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

1042

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1092

---

What is the difference between plan and package in db2?

1095

---

What is node in db2?

1033

---