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

What is the use of db2 optimizer?

611

What is null value in db2?

567

B37 abend during spufi?

982

what is diffrence b/w file-aid tool and file-aid utility???

4182

What is an instance database?

602

What is a db2 tablespace?

602

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

651

Explain how can you do the explain of a dynamic sql statement?

654

What is the result of open cursor statement?

638

Explain the contents that are a part of dclgen.

661

What is meant by explain?

662

Explain what are the various isolation levels possible?

610

What do you mean by cursor?

586

List some fields from sqlca?

613

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2279