PROSTRCT REMOVE qualifier

Removes storage areas or extents within storage areas.

Syntax

prostrct remove db-name extent-token storage-area

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.

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 MaintainingDatabase Structure for more information about the REMOVE qualifier with the PROSTRCT utility.