Progress
Database Administration
Guide and Reference


Progress Structure Add Utility

Use the Progress Structure Add (PROSTRCT ADD) utility to add storage areas and extents to an existing database. Note that the database must be offline before you can use PROSTRCT ADD. To add storage areas to an existing database using PROSTRCT ADD, follow these steps:

  1. Back up your database.
  2. Create a new structure description (ST) file that contains only information about the areas you want to add. For example:
  3. # 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.

  4. Use the PROSTRCT Utility with the ADD qualifier, specifying the ST file you created in Step 2. For example:
  5. prostrct add db-name incremental-description-file 
    

    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 
    

    NOTE: After you modify the structure of your database (adding or removing extents), run PROSTRCT LIST. PROSTRCT LIST automatically creates a structure description (ST) 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 © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095