Managing Progress DB Structure
1) To move around the db extent to differ location
- Bring down the DB and make a backup of the DB.
- Copy the db extent file, such as .b1, .b2 or .d1, .d2, to a new location
- Edit the .st file to point to the new location
- prostrct repair db-name [.st description file], This will update the .db with the .st with new file location
- prostrct list db-name, verify the change and insure .db, .st consistent
2) To Add a new extend
- Create a new.st file that only contain the new extent information.
- prostrct add db-name new.st
- This will turn the last flexible extent to fixed extent with the current file size.
- If want to make the file size of all fixed extent consistent, edit the .st file, then use procopy to copy the DB from a backup.
3) Another way to do all of above, like changing the location of extent and changing the file size for fixed extent.
- Edit the .st file with what ever change you want
- Use procopy to copy the DB from a backup to rebuild the new DB.
Recent Comments