Determining the Size of the Database › General Database Sizing Considerations › Overflow Conditions

Overflow Conditions

Overflow conditions occur when entities must contend for storage space in the database. In some instances, overflow can cause performance degradation. Therefore, you need to understand the causes of overflow and know how to minimize it.

You should try to predict the effectiveness of segregating entities in the planning stage and then fine tune the database in a test environment.

Note: You can use the database analysis utility (IDMSDBAN) to determine the total number of overflows in a database.

Types of overflow

There are two types of overflow:

• CALC overflow
• Cluster overflow

Each of these types of overflow is discussed separately below.