Consultor Eletrônico

Status: Verified

GOAL:

How to remove a Database extent

FIX:

To Remove unused variable-length data or before-image (BI) extents from a multi-volume database. Typically, you use Prostrct Remove when you want to remove an empty variable-length extent so that you can add a fixed-length extent.
Remember to truncate the bi file before attempting to remove an extent. You also must disable after imaging to remove variable, or fixed-length AI extents.
Progress 8.x Command:
.prostrct remove <dbaname> d
this will remove the last data extent

.prostrct remove <dbaname> bi
this will remove the last bi extent

.prostrct remove <dbaname> a
this will remove the last ai extent

Progress 9.x Command:
.prostrct remove <dbaname> d [area-name]
this will remove the last data extent (of the area)

.prostrct remove <dbaname> bi [area-name]
this will remove the last bi extent (of the area)

.prostrct remove <dbaname> ai [area-name]
this will remove the last ai extent (of the area)

.prostrct remove <dbaname> tl [area-name]
this will remove the last tl extent (of the area)

Be aware that most likely when removing extents it will be left only fix extents for that area and we recommend to have last extent (of an area) as variable.