Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Maintaining Database Structure : Using the OpenEdge Structure Add utility
 

Using the OpenEdge Structure Add utility

Use the Structure Add (PROSTRCT ADD) utility to add storage areas and extents to an existing database. The database must be offline before you can use PROSTRCT ADD, however PROSTRCT ADDONLINE is available for use with an online database. For information on PROSTRCT ADDONLINE, see OpenEdge StructureAdd Online utility.
To add storage areas to an existing database using PROSTRCT ADD:
1. Back up your database.
2. Create a new structure description file that contains only information about the areas you want to add.
The following is an example structure description file:
# add.st
#
d "chris",128 . f 1024
d "chris" .
Note: To avoid overwriting the .st file for your existing database, the name of this .st file must be different from the existing .st file for the database. For example, name the new structure description file add.st.
3. Use the PROSTRCT Utility with the ADD qualifier, specifying the .st file you created in Step 2.
The following is a sample command:
prostrct add service add.st
PROSTRCT ADD adds the new extents or storage areas and extents to the existing database control area, and outputs descriptive information, such as:
Formatting extents:
   size              area name           path name
   1024                chris        /user/joe/service_9.d1  00:00:00
     32                chris        /user/joe/service_9.d2  00:00:01
4. Generate an update structure definition file for your database with PROSTRCT LIST.
The following is a sample command:
prostrct list service service.st
After you modify the structure of your database (adding or removing extents), run PROSTRCT LIST. PROSTRCT LIST automatically creates a structure description file for your database if one does not exist, or overwrites an existing .st file of the same name to reflect the changes you just made to the structure of your database.
* PROSTRCT ADD and pathnames
* Adding extents to existing storage areas