Kbase P59868: How to avoid a data exceeding the area limit?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/30/2004 |
|
Status: Unverified
GOAL:
How to avoid a data exceeding the area limit?
GOAL:
How to avoid an area exceeding the file size limit?
FACT(s) (Environment):
Progress 9.1C
Progress 9.1D
FIX:
Before proceeding with the following, backup the database. The following procedure is extremely low-risk, but it's always a good practice to back the database up before any change.
1) Create a new structure description (.st) file called an incremental description file. This file should contains only information about the extents(s) being added. Multiple extents can be added to multiple storage areas at the same time and extents need not be in the same directory as the .db file.
Example of .st file that adds 1 fixed data extent and 1 variable length extent.
#
# V9 add.st
#
d "<new area name>",32 /fsys2/data/ f 1048576
d "<new area name>",32 /fsys2/data/
2) Shut down the database.
Be sure to avoid overwriting the .st file for your existing database, by giving the .st file a unique name that is different from the existing database st file.
3) Use prostrct utility with the add qualifier, specifying the .st file you created.
syntax of the prostrct add is as follows:
prostrct add db-name incremental-description-file
After the extent(s) have been added use the prostrct list utility to display storage area names and extent information including the extent type, size, number and name syntax of prostrct list utility is as follows:
prostrct list db-name
4) Move tables from the area that is close to the limit to the new area.
5) Use the PROUTIL TABLEMOVE utility to move a table and its associated indexes from one storage area to another. This command can be run online or offline.
Command syntax example:
proutil dbname -C tablemove <table name> <area name>
To move the indexes with the tables:
proutil dbname -C tablemove <table name <area name> <area name>
The second area names specifies to the move the indexes as well.