Kbase P65208: What to do with last non fixed extent prior to adding new extent?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
What to do with last non fixed extent prior to adding new extent?
FIX:
Prior to adding a new extent to [an area within] a database, it is recommended to remove the last none fixed extent if it has not started to fill.
The command
prostrct remove <database_name> <extent_token> [<storage_area>]
will either remove the last extent or return a message as
The last extent of area <area number> is in use. (6960)
The last extent of area <area name> is in use. (8565)
if the last non fixed extent has started to be filled.
Not removing a none-fixed not-used makes that extent become a small fixed extent (32K in many cases).