MVSFORUMS.com

[jctgf]

hi,

I have a db2 table that is partitioned and contains 254 partitions. I am not sure why the table is partitioned. I think it's because it's a large table, with more than 3 billion lines.
The table primary key is a cluster index and it determines the partitioning criteria. My intention is to change the primary key index so that it won't determine the partitioning criteria anymore. Another index, a secondary one, will determine the partitioning criteria.

Summing up, follows a few questions:
1) when a table must be partitioned?
2) when an index must be partitioned?
3) what happens with my primary key, that is very large, if the table grows too much? will my primary key index burst? how does db2 manage the size of the index? what happens when the index gets too big?

thanks a lot.
jc