Progress
Database Administration
Guide and Reference


Progress Structure Remove Utility

Use the Progress Structure Remove (PROSTRCT REMOVE) to remove extents from storage areas. After all the extents are removed from a storage area, PROSTRCT REMOVE removes the storage area. Follow these steps to remove storage areas:

  1. 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:
  2. proutil db-name -C truncate bi 
    

    If the storage area to be removed is an application data area, remove all tables and indexes, then 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. You must also disable two-phase commit before you can remove a transaction-log (TL) extent.

    For more information about truncating areas, see the "PROUTIL TRUNCATE AREA Qualifier" section in Database Administration Utilities."

  3. Use PROSTRCT REMOVE to remove extents from the storage area. For example:
  4. prostrct remove db-name extent-type-token [area-name] 
    

    NOTE: Use the area-name parameter only to remove application data extents. If the area name contains a space, supply double-quotes around the area name. 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 outputs descriptive information such as:

    solaris:90a$ prostrct remove service d chris 
    /user/joe/service_9.d3 successfully removed 
    solaris:90a$ prostrct remove service d chris 
    /user/joe/service_9.d2 successfully removed 
    solaris:90a$ prostrct remove service d chris 
    /user/joe/service_9.d1 successfully removed 
    

  5. Run PROSTRCT LIST after removing any areas. PROSTRCT LIST will overwrite your existing ST file to reflect the changes made to the structure of your database.

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