How to add an extent to a multi-volume database?

How to add data extents?
How do I add extent(s) to a database?
How to add an extent to a multi-volume database?
How to add a database extent to the database structure?

Database extents need to be added from time to time in order to accommodate database growth and allow sufficient space for storing database records.

Before changing the database structure, backup the database.   The following procedure is extremely low-risk, but it's always a good practice to back the database up before any change.  

Run 'prostrct list dbname' command to generate the Control Area's current reflection of the database structure before starting the process. The resulting dbname.st file should be renamed for later reference.

Steps

1. Create a new structure description (.st) file that contains only information about the extents(s) being added. Be sure to avoid overwriting the .st file for the existing database, by giving the .st file a unique name that is different from the existing "dbname.st" file, for example name it "add.st" file.

• Multiple extents can be added to multiple storage areas at the same time and extents need not be in the same directory as the Control Area (.db file)
• For all extent types, except after-image extents, there can be only one variable length extent defined and it must be the last extent of the Storage Area. If the current last extent ends with a variable extent, it will become a fixed extent when adding another extent.
• Additional areas can be added to a database by using a new storage area name.  Those new storage areas would be empty and new tables could be added or existing tables and/or indexes could be moved into those areas as required.  

2. Shut down the database and stop all batch jobs running against the database. If you require adding extents while database is running, then please refer to Article  How to add database extents online ?

3. Use the prostrct utility with the add qualifier, specifying the .st file that is created in step 1.

 $ prostrct add dbname add.st

4. After the extent(s) have been added, use the prostrct utility with the list qualifier to display and verify the new database structure. This will include storage area information: name, number, records per block, blocks per cluster (for OE10 and above) and extent information: type, path, size, number and name to screen. This information is also written to a text file which is named dbname.st by default (unless another name is specified)

 

References to Other Documentation:

Progress Database Administration Guide and Reference, Chapter 9 "Maintaining Database Structure".
Progress Database Administration Guide and Reference, Chapter 19 "Database Administration Utilities".