Consultor Eletrônico



Kbase P56094: Can a fixed extent be removed with prostrct remove
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   17/03/2008
Status: Verified

GOAL:

Can a fixed extent be removed with prostrct remove

FACT(s) (Environment):

Progress 9.x
OpenEdge 10.x
All Supported Operating Systems

FIX:

A fixed extent can be removed using prostrct if no data is contained in the extent.
This applies to Data, Before Image and After Image extents.
Any changes to the database structure must be made with the database shutdown.
A backup of the database should be done prior to changes to the database structure.

Note: Before running prostrct remove for bi extents, the bi files must be truncated.

ie:

proutil dbname -C truncate bi
prostrct remove db-name extent-token storage-area

proutil test -C truncate bi
prostrct remove test bi ( removes the last bi extent for database test)