Kbase P110695: How to add new areas to a DB.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/02/2009 |
|
Status: Verified
GOAL:
How to add new areas to a DB.
GOAL:
Example on how to add new area to a DB.
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
Follow these steps to define a new area:
1) Create a .st file like this:
The following uses the Sports database and add.st as an
example:
# add.st
#
# This .st adds a new area with a
# fixed extent of aprox. 500 MB and a variable one
# in the current directory
#
d "Area_xyz" . f 512000
d "Area_xyz" .
2) Add the new three areas using the command:
prostrct add <db name> <.st file>
For example:
prostrct add sports add.st
3) To move the tables to the new area use the command:
proutil <db name> -C tablemove <table name> <area name>
For example:
proutil sports -C tablemove customer Area_xyz