Use the Structure Remove (PROSTRCT REMOVE) utility to remove extents from storage areas. After all the extents are removed from a storage area, PROSTRCT REMOVE removes the storage area.

To remove storage areas:

  1. Truncate the area, based on its type:

    • If the extent to be removed is in the BI area, use the PROUTIL TRUNCATE BI utility to truncate the primary recovery area to be removed. For example:

       proutil db-name -C truncate bi

    • If the storage area to be removed is an application data area, use the PROUTIL TRUNCATE AREA utility to truncate the application data area. For example:

      proutil db-name -C truncate area area-name
    Note: You must disable:
    • After-imaging before you can remove an AI extent.
    • Two-phase commit before you can remove a transaction-log (TL) extent.

    For more information about truncating areas, see PROUTIL TRUNCATE AREA qualifier.

  2. To remove extents from the storage area, use PROSTRCT REMOVE, for example: 
    prostrct remove db-nameextent-type-token [area-name]
    Note: Use the area-name parameter only to remove application data extents. If the area name contains a space, place the area name within double quotation marks. For example: "test data."

    You can remove one extent at a time. After you have removed all of the extents from a storage area, PROSTRCT REMOVE removes the storage area and displays descriptive information such as:

    solaris:100a$ prostrct remove service d chris
/user/joe/service_9.d3 successfully removed
solaris:100a$ prostrct remove service d chris
/user/joe/service_9.d2 successfully removed
solaris:100a$ prostrct remove service d chris
/user/joe/service_9.d1 successfully removed
  3. After removing the areas, run PROSTRCT LIST to overwrite your existing .st file and reflect the changes made to the structure of your database.