Try OpenEdge Now
skip to main content
Database Administration
Reference : PROSTRCT Utility : PROSTRCT REMOVE qualifier
 

PROSTRCT REMOVE qualifier

Removes storage areas or extents within storage areas.

Syntax

prostrct remove db-name extent-token storage-area

Parameters

db-name
Specifies the database where you want to remove a storage area or extent.
extent-token
Indicates the type of extent to remove. Specify one of the following:
*d — Removes a data extent
*bi — Removes a before-image extent
*ai — Removes an after-image extent
*tl — Removes a transaction log extent
storage-area
Specifies the name of the storage area to remove.

Notes

*You cannot remove an extent if it is in use or contains any data.
*You must truncate the bi file before removing an extent.
*Before you remove extents from the TL area, you must disable two-phase commit.
*You must disable after-imaging to remove variable, or fixed-length AI extents.
*You can verify that the deletion occurred and update the structure description file using the LIST qualifier with the PROSTRCT utility.
*See Maintaining Database Structure for more information about the REMOVE qualifier with the PROSTRCT utility.