Release 10.1A: OpenEdge Data Management:
Database Administration

> ## 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 PROSTRUCT ADDONLINE, see the "OpenEdge Structure Add Online utility" section.

> | 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. For example:

>     # 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. For example:

>     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.

>     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.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095