Progress OpenEdge 10.1A introduces the option to create new Storage Areas or add extents to existing Storage Areas while the database is online.
The "PROSTRCT ADDONLINE" utility allows administrators to add data areas and extents, before-image extents, and after-image extents without incurring downtime.
Restrictions:1. Only one instance of
prostrct addonline can execute at a single moment in time.
2. All connected users must have sufficient privileges to access the newly created extents. If currently connected users don't have sufficient privileges to access those new extents, these users must be disconnected before the addonline can be completed. Refer to Article
Why does prostrct addonline check connected users? Procedure:Adding extents is essentially the same as adding extents offline:
A. Create a structure file (
add.st) file describing the new Storage Area/extent information.
B. Run the following command :
prostrct addonline dbname add.st [-validate]Important Notes:
- The -validate option can be used to determine if the amount of space in the file system is sufficient to handle those newly added extent files. Prior to OpenEdge 10.1B01 the -validate parameter must not be used. Refer to Article Adding Areas online fails with error 12867
- There is no functionality to REMOVE extents online, even if the last variable extent is empty. This is an offline operation.
- Existing variable extents will become FIXED extents at their current size. Refer to Article What happens to the variable-length extent when a new extent is added
- It worth mentioning that before-image and after-image extent files can also be added online
- Additional considerations are needed when adding extents to Replication Enabled databases. Refer to Article What are the rules for adding extents online to replicated databases?
