Kbase P35226: Changes to database physical structure (prostrct utility)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Changes to database physical structure
GOAL:
Reconsider the structure of your database
FIX:
The tool "prostrct" allows you to change your database physical structure.
Find below a V9 sample for moving from two BI extents (first extent of size 2Gig) to a non fixed BI extent.
Running "prostrct list sports" we see in sports.st:
b sports.b1 f 2096768
b sports.b2
Run:
proutil sports -C truncate bi
prostrct remove sports bi
prostrct remove sports bi
so that the two existing extents are removed.
Create a file named "sports.add" for example and have within it
b sports.b1
Run:
prostrct add sports sports.add
and you have just one BI extent of non fixed size.