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

Note: You can only add transaction-log (TL) extents when the database is offline.

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

    PROSTRCT ADD converts your previous variable-length extent to a fixed-length extent at its current size.

  4. Generate an update structure definition file for your database PROSTRCT LIST.

    For example:

    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.