Kbase P120202: How to add a database extent as well as change the size of the extents without a dump and load.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/08/2009 |
|
Status: Verified
GOAL:
How to add a database extent as well as change the size of the extents without a dump and load.
GOAL:
How to add a database extent as well as change the size of the existing extents
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
1) Make a full backup of the database using probkup utility.
probkup db db.bk1
2) Modify the current .st file adding and changing the extent block sizes as desired and place it in the directory where the .db will reside.
(see examples below)
3) Restore the database using the prorest utility.
prorest db db.bk1
ie:
current .st file
#
b .
#
d "Schema Area":6,32;1 .
#
d "Employee":7,32;1 . f 320
d "Employee":7,32;1 .
New .st file
#
b .
#
d "Schema Area":6,32;1 .
#
d "Employee":7,32;1 . f 128
d "Employee":7,32;1 . f 128
d "Employee":7,32;1 . f 128
d "Employee":7,32;1 . f 128
d "Employee":7,32;1 .