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.