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:
- 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:
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:
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."
- Use PROSTRCT REMOVE to remove extents from the storage area. For example:
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:
- 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 |