Kbase P37020: What to do if you run out of space on the disk that contains your variable data extent.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/17/2006 |
|
Status: Verified
GOAL:
What to do if you run out of space on the disk that contains your variable data extent.
FIX:
If you run out of space on the disk that holds your variable data extent you have several options on how to handle the situation.
A) If you have sufficient space in another location of your file system you may be able to procopy to a new location.
procopy <path to old db>/<db name> <path to new db>/<db name>
B) You could choose to probkup the database and restore to a new location which has more space:
1) probkup <dbname> <backup file/device>
2) prorest <new location
ame> <backup file/device>
C) If the disk which holds the variable extent has 0k free space then you can:
1) move the variable extent alone to a new location which has more space (at least 32k free)
2) run prostrct list <dbname> to get an st file which has the old information of where all the files were.
3) edit that st to modify it with the newer location you have moved the variable data extent to
4) use prostrct repair <dbname> <modified st file>
to imprint the new information from the modified st into the database