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

How to check sequence on a table in db2?

1073

What's The Percentage Free Space ?

1236

What is the result of open cursor statement?

1092

Why do we need reorg in db2?

1001

What is the role of schema in the db2 database?

1286

List down the types of triggers in the db2 database?

1040

Can we delete records from view?

974

What is blu acceleration in db2?

1085

Are views updateable?

1169

How to find the number of rows in db2 tables?

1078

Is the primary key a clustered index?

1161

How can the duplicate values be eliminated from db2 select?

1113

What kind of database is db2?

1047

Define sqlca.

1120

What is the default page size of buffer pools?

1131