media/image5.png

When you add extents to a database, keep in mind the following:

OpenEdge RDBMS adds the extents to the end of a storage area. For example, if the Order area currently has three extents, .d1, .d2, and .d3, and you want to add three more, the new extents would be .d4, .d5, and .d6.

When you add extents, OpenEdge RDBMS caps off the last variable extent and turns it into a fixed extent. It then adds the new extents. For example, if your variable extent currently contains 10160K of data and your database has an 8K block size, then OpenEdge RDBMS would cap it off at 10240K (the multiple of 16 times 8 that is nearest to and greater than 10160K), and would not write any more data to it.

If you add extents offline, you should remove the variable extent, if it is empty, before you add new extents.