//
you're reading...
QAD Ent Application

How to upgrade a version 10.1x database to 10.1X

How to upgrade a version 10.1x database to 10.1X

ID: P131772
Title: “How to upgrade a version 10.1x database to 10.1X”
Created: 05/23/2008 Last Modified: 08/13/2009
Status: Verified
WME(‘Goals: ‘);
Goals:
How to upgrade a version 10.1A database to 10.1B? WME(‘Goals: ‘);
How to upgrade a version 10.1A database to 10.1C? WME(‘Goals: ‘);
How to upgrade a version 10.1B database to 10.1C? WME(‘Goals: ‘);
How to upgrade a version 10.1x database to 10.2A? WME(‘Goals: ‘);
Do I have to dump and load when upgrading the database from 10.1A to 10.1B? WME(‘Goals: ‘);
Do I have to dump and load when upgrading the database from 10.1A to 10.1C?
WME(‘Goals: ‘);
Do I have to dump and load when upgrading the database from 10.1B to 10.1C? WME(‘Goals: ‘);
Do I have to dump and load when upgrading the database from 10.1x to 10.2A?
WME(‘Facts: ‘);
Facts:
OpenEdge 10.x WME(‘Facts: ‘);
All Supported Operating Systems
WME(‘Fixes: ‘);
Fixes:
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> -stop

2. 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 solutionP121673, “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

Advertisements

About iambaprang

Bap Rang's house

Discussion

No comments yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s