An Index Is Reaching A Limitation On The Number Of Pages It Has, Can

1.	An Index Is Reaching A Limitation On The Number Of Pages It Has, Can You Explain Why This Limitation Exists And What Work You Would Do To Get Around It?
Answer» A dbspace can have one or more partitions. Each partition has a special “HEADER” info in the first extent. The partition header keeps a list of the partition’s extents. If the object HOLDING the space in the partition (table / index) has a great number of extents, the header MAY not be able to keep the full list. Workarounds: increase first / next extent size and recreate the object change the PAGE size -> will result in a LOWER number of extents recreate the index in a dbspace having a larger page size

An Index Is Reaching A Limitation On The Number Of Pages It Has, Can You Explain Why This Limitation Exists And What Work You Would Do To Get Around It?

Answer»

A dbspace can have one or more partitions. Each partition has a special “HEADER” info in the first extent.
The partition header keeps a list of the partition’s extents. If the object HOLDING the space in the partition (table / index) has a great number of extents, the header MAY not be able to keep the full list.
Workarounds:
increase first / next extent size and recreate the object
change the PAGE size -> will result in a LOWER number of extents
recreate the index in a dbspace having a larger page size