The maximum number of partitions allowed in DB2 V8 is 4096 partitions.

what are the max. & min. no. of partitions allowed in a
partition tablespace?

Question Posted / s

Answer Posted / s

The maximum number of partitions allowed in DB2 V8 is 4096
partitions.

Is This Answer Correct ?

3 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Where do you specify them?

1165

What is cloudant database?

1032

What is difference between alias and synonym in db2?

1067

What is ibm db2 used for?

1002

What is buffer pool and list some of them?

981

What is a db2 collection?

981

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1005

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

1023

What is netezza database?

959

What is the use of value function?

1074

How can we retrieve the total number of records in RPG & CLLE?

577

What is query_cache_limit?

928

What is the difference between oracle and db2?

1031

What is the use of runstats in db2?

1022

What is a trigger in the db2 database?

1014