Kbase P5884: How to convert a version 7 or 8 single-volume database to multi-volume
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/08/2009 |
|
Status: Verified
GOAL:
How to convert a version 7 or 8 single-volume database to multi-volume
GOAL:
How to convert a single-volume db to multi-volume when it's close to the 2 GB limit
FACT(s) (Environment):
All Supported Operating Systems
Progress 7.x
Progress 8.x
OpenEdge Category: Database
FIX:
There are two ways to accomplish this :
1. If you have enough space to have the new database but still keep the current database, use PROCOPY.
- Create a structure file to define the appropriate files for the multi-volume database
Example of an .st file for UNIX:
* BigDB.st
*This file will create a 3 GB DB
*with 1 GB fixed size data extents plus a flexible one in the current directory.
*
d ./BigDB.d1 f 1048576
d ./BigDB.d2 f 1048576
d ./BigDB.d3 f 1048576
d ./BigDB.d4
b ./BigDB.b1
- Use PROSTRCT CREATE to create a void multi-volume database from the structure file
Example:
prostrct create BigDB BigDB.st
- Use PROCOPY to copy the single-volume database to the void multi-volume database structure.
Example:
procopy OldDB BigDB
2. Converting with PROREST
- Backup the single-volume database using PROBKUP
- Test backup file using PROREST -vf (Full Verify)
- Delete single-volume database
- Create structure file to define appropriate files for multi-volume database.
- Use PROSTRCT CREATE to create a void multi-volume database structure
- Use PROREST to restore the backup into the void multi-volume structure.
Follow normal database backup procedures prior to performing any modification to your databases. If you have not yet performed a backup of your database please refer to the 'backing up your database' in section 2 in the readme file.