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

Mention the location where the output received from explain statement is stored.

1174

On which levels locks can be applied?

1204

How would you find out the total number of rows in a db2 table?

1094

Explain about mirror activator disk mirroring?

1063

What is the information associated with sysibm.syslinks table?

1169

What is universal database?

1119

What is the difference between cursor and select statement?

1152

What is with ur in db2?

1384

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

1137

What is db2 instance?

1165

What is bind in db2?

1096

Is ibm db2 free?

1069

What are db2 objects?

1091

B37 abend during spufi?

1511

What is difference between alias and synonym in db2?

1198