Archive

Archive for June, 2007

Managing Progress DB Structure

June 8th, 2007 No comments

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.

Categories: Progress Tags: , , ,