upgrading from 9c to 10c

[cpb]

Hi

How to check what version of progress is installed on a server? Also I need to migrate a 9c db to 10c db. Could you provide me some links for this please?

thanks

 

[rzr]

Message proversion view-as alert-box.

 

[TomBascom]

Or "showcfg" from a command prompt.

Progress version numbering is major.minor.letter with service pack# appended. i.e.

9.1c01 would be major version 9, minor version 1, letter c service pack 01

You should not be upgrading to 10c (which is likely 10.1c). It is 3 years old. You should be upgrading to 10.2B04 which is the latest release. Version 11 will probably be released around year-end.

The migration process can be quite simple:

1) backup
2) proutil dbname -C conv910
3) recompile
4) restart

(Of course you test all of this ahead of time on your test system...)

But to completely take advantage of the new release you also need to convert your database to use type 2 storage areas. This generally requires some analysis of your data and a dump & load. For some ideas on how to think about type 2 storage areas: http://dbappraise.com/ppt/sos.pptx

 

[cpb]

thanks tom, that was really helpful info. How can I migrate a db from PA RISC to itanium boxes? Is there any steps for that. I need to backup and put in the itanium boxes and then upgrade to the latest version.

 

[TomBascom]

Backup and restore is not a migration mechanism.

Backup and restore works when:

1) The Progress version numbers are the same
2) The OS is the same
3) The byte ordering is the same

If any of those change then backup & restore is not an option. Offhand I do not recall if the byte order is the same from PA-RISC to Itanium.

Otherwise you have to dump & load.

 

[cj_brandt]

You can go PA RISC to Itanium with a progress backup or OS copy. We do it all the time.