Kbase P131772: How to upgrade a version 10.1x database to 10.1X
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/13/2009 |
|
Status: Verified
GOAL:
How to upgrade a version 10.1A database to 10.1B?
GOAL:
How to upgrade a version 10.1A database to 10.1C?
GOAL:
How to upgrade a version 10.1B database to 10.1C?
GOAL:
How to upgrade a version 10.1x database to 10.2A?
GOAL:
Do I have to dump and load when upgrading the database from 10.1A to 10.1B?
GOAL:
Do I have to dump and load when upgrading the database from 10.1A to 10.1C?
GOAL:
Do I have to dump and load when upgrading the database from 10.1B to 10.1C?
GOAL:
Do I have to dump and load when upgrading the database from 10.1x to 10.2A?
FACT(s) (Environment):
OpenEdge 10.x
All Supported Operating Systems
FIX:
You do not have to dump and load the database when upgrading from 10.1A to 10.1B, 10.1A to 10.1C or 10.1B to 10.1C. You do not need to upgrade from one to the other in sequence, but may go directly from 10.1B to 10.2A , for example.
When upgrading the database from 10.1A to 10.1B/10.1C perform the following steps:
1. Shutdown the database.
Command syntax: proshut <dbname> or dbman -db <dbname> -stop2. When updating from 10.1A to 10.1B or 10.1C:
Disable AI on your database (If currently being used as part of your database backup/recovery mechanism.)This has to be done due to the change from 32-Bit DBKEYS to 64-Bit DBKEYS that was introduced in 10.1B.
If you do not disable AI prior to migration to 10.1B / 10.1C you will receive the following error message when starting the database in the new version:
"This codebase cannot open a 32-bit DBKEY database with After Imaging enabled. (13713)"
See solution P121673, "3713 Error starting/migrating a database with AI enabled from 10.1A to 10.1B" for details.
3. Backup the database with probkup command or Operating System
4. Truncate the BI file.
Command syntax: proutil <dbname> -C truncate bi
5. Uninstall 10.1A (This is optional. You only need to Uninstall 10.1A if the intent is to install 10.1B/10.1C in that same directory/location).
6. Install the 10.1B/10.1C/10.2A
7. Installation of Service Pack needs to be done separately upon completion of a successful 10.1B / 10.1C / 10.2A installation.
8. (10.1B+) Enable AI on your database (If this is a requirement for your database backup/recovery mechanism).9. Start database under 10.1B, 10.1C or 10.2A. Command syntax: proserve <dbname> startup parameters or dbman -db <dbname> -start