Progress
Database Administration
Guide and Reference


Adding Extents to Existing Storage Areas

To add extents to an existing area use the PROSTRCT utility with the ADD qualifier.

NOTE: You can only add after-image (AI) extents when after-imaging is disabled. You can only add transaction-log (TL) extents when the database is offline.

To add extents 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 .  
    

    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 
         0               chris        /user/joe/service_9.d3  00:00:01 
    

    NOTE: After you modify the structure of your database (such as adding or removing extents), run PROSTRCT LIST. It 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