Upgrading from 10.1C04 to 10.2B01, course of action?

E

exxoid

New Member
Hello,

We plan on upgrading our Progress databases this weekend from 10.1C04 to 10.2B01, I am trying to put a plan in action to make this go as smooth as possible and would appreciate comments/feedback on any of the steps:

Prior to the upgrade, we tested to ensure our software would work on 10.2B01 by upgrading our testing environment first (each environment has a /dlc directory, and we can easily switch version by updating the /dlc to the appropriate version as its only a symlink).

Our environment is AIX 5.3 64bit.

- Shut everything off and ensure nothing is in memory (dbipcs)
- Truncate BI
- Back-up the database
- Update symlink of DLC to new version
- Start DB and verify logs

I would also like to adjust our structure by removing some variable lenght AI files (we only use variable) but we have 100 of them for each DB (they are switched every 5 minutes), with variable length we only need 4 (I think was minimum?) but I am going to keep it at 5.

Now, the process for this would be?

- rfutil dbname -C aimage list # to findout if any extents are not marked as EMPTY
- rfutil dbname -C aimage extent empty #empty it if its not empty
- rfutil dbname -C aimage end # to stop AI
- prostrct remove dbname ai #remove the AIs (95 of them)
- prostrct list dbname #update the ST file
- rfutil dbname -C aimage begin #start AI image back-up

Do I need to truncate AI files for a database before removing them? Also, should I run this before running truncate BI?

Thanks for your help.
 
As soon as the after image is switched off (rfutil dbname -C aimage end) you can remove the extents from the database structure. There is no need to truncate 'em.

It would be a good idea to remove the superfluous after image extents AFTER you've backed up the database successfully. To make sure you can restore the database from your backup you can use the prorest command with the -vf (full verify) option. At this point the truncate before image already has happened before the backup ...

HTH, RealHeavyDude.
 
cj_brandt, thanks for that I forgot to include that in my steps, it was already in the planning as I think a few new VSTs are introduced.

RealHeavyDude, thanks for the feedback.
 
You must log in or register to reply here.
Back
Top