Allocate space for tables being partitioned

Allocating space properly is very important. It ensures that the partitions have adequate space for current usage and future growth. In OpenEdge table partitioning, you must use Type II storage areas for table partitions and their associated indexes and LOBs.

When you create new storage areas for partitions, you can control how a storage area is defined for each partition. For each partition, you must determine:

• The number of extents in each storage area
• The number of fixed extents in each storage area
• The correct size for each fixed extent
• The optimal number of records per block
• The appropriate number of blocks per cluster

To allocate space for tables being partitioned, you first create and populate a .st file that implements the desired space allocation for the partitions. Then, you validate the .st file for accurate syntax and valid content and add the space to the database. Since a database with very large tables is meant to work with large amounts of data, you should ensure that large files support is enabled.