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...!!

Which is faster delete or truncate?

1177

---

How to get the ddl of a table in db2?

1170

---

What is the clustering index in the db2 database?

1047

---

What is load utility in db2?

1232

---

How many databases are there?

1112

---

What is runstats and reorg in db2?

1363

---

What language is db2 written in?

1107

---

What is the maximum length of sqlca?

1619

---

Which component is responsible for processing sql statements and selecting access paths?

1179

---

What type of database is db2?

1020

---

What is the max length of sqlca?

1273

---

How do you find the maximum value in a column in db2?

1155

---

Mention the downsides of page level lock.

1220

---

How will you return the number of records in table?

996

---

Before you give the explain statement, what are the prerogatives?

1084

---