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 contains any data.
• If a database is in use, and in a data storage area, use PROSTRCT REMOVEONLINE instead of PROSTRCT REMOVE. See PROSTRCT REMOVEONLINE qualifier.
• You must truncate the before-image file before removing an extent.
• Before you remove extents from the transaction log area, you must disable two-phase commit.
• You must disable after-imaging to remove variable or fixed-length after-image extents.
• You can verify that the deletion occurred and update the structure description file using the LIST qualifier with the PROSTRCT utility.
• See Maintain Database Structure for more information about the REMOVE qualifier with the PROSTRCT utility.