Step 1-Creating a .st file to add new extents

The .st file you create to add new extents only needs to contain one line for each extent you want to add.

The simplest way to create a .st file to add new extents is to open the existing .st file of the database, and then copy and paste the lines representing the storage area to which you want to add extents into a text editor. Next, modify the lines to define the new extents. Then, save the file as a .st file.

Follow these guidelines:

  • Use the same records per block value as in the existing storage area or leave the value blank.

  • Use the same blocks per cluster value as in the existing storage area.

  • Specify the size and location of your choice for the new extents.

  • Ensure that the last extent is a variable extent.

  • Do not name the extents explicitly; let OpenEdge RDBMS do it for you.

Suppose the Order storage area of the sports database currently has two fixed extents and a variable extent as seen in the sports.st file below:
...
d "Order":11,64;64 . f 51200
d "Order":11,64;64 . f 51200
d "Order":11,64;64 .
...
Suppose you want to add two new fixed extents of 102400K each and a variable extent to the Order area and store them in the data directory. This is what the .st file to add the new extents should look like:
# .st file for adding extents to the Order storage area
d "Order":11,64;64 ../data f 102400
d "Order":11,64;64 ../data f 102400
d "Order":11,64;64 ../data

Note that the new extents have the area name, area number, records per block, and blocks per cluster as the existing extents. But the location of the new extents is different, and the size of the new fixed extents is also different.