Kbase 21960: PROSTRCT ADD and Variable-length Extents in Version 9
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/12/2002 |
|
SUMMARY:
PROSTRCT ADD will exhibit different behavior depending on what kind of extent is being added.
EXPLANATION:
In a Version 9 Database, there can be only one Schema area (containing schema area .dn extents) and only one Primary Recovery area (containing before-image .bn extents). Only one variable-length extent can be defined for each of these areas. Multiple application data areas (also .dn extension) can be defined, and again only one variable-length extent can be defined for each of these areas. You can define as many variable-length ai (.an) extents as required, on the other hand.
PROSTRCT ADD will show different behavior depending on what kind of extent is being added.
bi: PROSTRCT ADD will not fix the size of an existing variable bi
extent. The variable bi extent has to be removed first of all.
.dn: PROSTRCT ADD will fix the size of the variable extent.
ai: PROSTRCT ADD won't fix the size of an ai extent, and any
variable extent remains variable.
Transaction log extents (.tn) will always be of fixed size.
References to Written Documentation:
Progress Database Administration Guide and Reference, Version 9
Progress Knowledge Base Solutions:
17492, "What PROSTRCT ADD Does With the Variable Length Extent"
21460, "How To Add AI Extents in an Existing V9 Progress Database"