Answer Posted / vish

Unfortunately nonoe of the above answers are completely
correct. Answer posted by Nawal Kishore is partly correct
but not the complete answer. Answer from Vani may be partly
correct depending upon the DSSiZE and the page size. Let me
try to answer the question:

DB2 alllows a maximum of 4096 partitions of a partitioned
table space. Actually, the maximum number of partitions in
a table space depends on the data set size (DSSIZE
parameter) and the page size. Thus the partitions can range
from 1 to 4096 depending upon the above parameters (DSSIZE
ands the page size).

You can refer to IBM documentations to confirm the
same...suggesstions are welcome...!!

What is the use of reorg in db2?

1068

---

What is the physical storage length of timestamp data type?

1072

---

What is a db2 schema?

1209

---

What is a db2 table?

989

---

What is nvl in db2?

1084

---

What is the role of the data page in the db2 database?

1009

---

What is schema in db2?

1006

---

what are bind concepts in db2 cobol?

1071

---

What is buffer pool and list some of them?

1006

---

How will you return the number of records in table?

915

---

What are concurrency issues?

1071

---

How do I delete a table in db2?

1052

---

Why do we need reorg in db2?

968

---

What are db2 objects?

1032

---

What is dbrm? What it contains? When it will be created?

1030

---