Removes data storage areas or extents within storage areas, including the encryption and CDC areas, from a running database. The storage area must contain no objects.

Syntax

prostrct removeonline db-name extent-token area-name [-allExtents] -silent

Parameters

db-name
Specifies the database from which you want to remove a storage area or extent.
extent-token

Indicates the type of extent to be removed. For this utility, the only valid token is d.

area-name
Specifies the name of the storage area to be removed.
-allExtents
Removes all extents and records for the area. When this parameter is omitted, the utility removes only the last extent of the area.
-silent
Suppresses prompts with instructions when after-imaging is enabled.

Like PROUTIL TRUNCATE AREA, PROSTRCT REMOVEONLINE resets the high-water mark in the storage area back to the beginning of the storage area. This reset frees all of the space in the storage area for reuse.

Examples

Suppose an area named Table Area1 comprises multiple extents that are no longer used. To remove all extents and the area, issue this single command: 

prostrct removeonline sports2020 d 'Table Area1' -allExtents

The following command removes an extent on a replication source database:

prostrct removeonline sourcedb d area2

If the removeonline operation on the source database removes the area, and the target database enters its wait period, enter this command: 

prostrct removeonline targetdb d area2

The following example removes the storage area area3 on the target database when applying the after-image file source.a3:

prostrct removeonline source d area3 -allExtents 
rfutil target –ailist ailistfile.in     # or –a source.a3 for example

Notes

  • You cannot remove an extent if it contains any data.
  • The PROSTRCT REMOVEONLINE utility waits for connected processes to close removed files and prompts you to recheck. Answer y to continue.The checks complete quickly if you have set dbnotifytime greater than zero.
  • You can verify that the deletion occurred and update the structure description file using the LIST qualifier with the PROSTRCT utility.
  • When PROSTRCT REMOVEONLINE removes the final extent, it does not change the type (fixed or variable) of the preceding extent.
  • The phyiscal extents for the source and target databases do not need to match. Removing an extent on the source does not require removing anything on the target, especially because the target could be a single, large extent for an area, as opposed to many smaller extents on the source. However, removing an area on the source will require removing the area on the target databases.
  • PROSTRCT REMOVEONLINE does not support removal of AI and BI files or transaction logs. You must shut down the database and use PROSTRCT REMOVE to remove after-image, before-image, or transaction log storage areas or extents.
  • See OpenEdge Structure Remove Online utility for more information about PROSTRCT REMOVEONLINE.