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

Define db2.

1121

---

can all users have the privilage to use the sql statement select * (dml)?

1180

---

How is the value function used?

1159

---

What is ibm db2 client?

948

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1448

---

What is db2 connect?

1082

---

What is host variable?

1065

---

How to check sequence on a table in db2?

1069

---

What are the prerogatives?

1088

---

What is image copy in db2?

1024

---

What are the contents of dclgen?

1115

---

When do you specify the isolation level?

1040

---

What is database reorganization?

1135

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1088

---

what is the role of the cursor in db2?

1072

---