Status: Verified
GOAL:
How to prepare a Progress 8.3 database for upgrade to Progress 9.x using the 83dbutils
FIX:
In the Progress install dir\bin\83dbutils directory for Progress 9x the executables that will allow you to prepare the 8.3x database for conversion using the proutiil command ( proutil dbname -C CONV89), can be found.
The README file that explains the process follows and is found in the same directory.
readme file:
The files in the DLC/83dbutils directory are supplied for PROGRESS Version 8.3 to Progress Version 9 database conversion purposes as documented below only.
Any other uses are strictly prohibited and unsupported.
** Please follow normal database backup procedures prior to performing
** any modification to your database with these utilities. If you have
** not yet performed a backup of your database please refer to the **
'backing up your database' in section 2, below.
The areas covered by this note include:
1. Files and their uses explained
2. Backing up your database
3. Special considerations for SCO OpenServer and SCO Unixware platform users
1. Files explained
The files are being provided by Progress Software to assist in the pre-database conversion processing required to upgrade to PROGRESS
Version 9. These files are required only for forward bound database conversion purposes and may be deleted if not needed. Functionality supported by these files includes:
File Name Summary
83makemultiv Use to convert a single volume PROGRESS Version 8.3 Database to multi-volume structure.
Usage: 83makemultiv <dbname>
83truncatebi Use to truncate the bi file for a PROGRESS Version 8.3 single or multi-volume Database. Usage: 83truncatebi <dbname>
83conv68 Use to convert a PROGRESS Version 6 database to PROGRESS Version 8.3 format. If the PROGRESS Version 6 database has a single volume structure the 83makemultiv utility should be used to convert it to a multi-volume structure prior to running the PROGRESS Version 9 conv89 utility.
Usage: 83conv68 <dbname>
83conv78
Use to convert a PROGRESS Version 7 database to PROGRESS Version 8.3 format. If the PROGRESS Version 7 database has a single volume structure the 83makemultiv utility should be used to convert it to a multi-volume structure prior to running the PROGRESS Version 9 conv89 utility. Usage: 83conv78 <dbname>
2. Backing up your database
If the database to be converted to PROGRESS Version 9 has not yet
been backed up for safety and potential recovery purposes; now is
the time to do it. The following procedure can be used for backing
up a PROGRESS Version 8.3 database prior to performing the remaining conversion procedures:
2.1. Set the DLC and PATH environment variables in the manner which your platform expects it to be set. In the sample code below please replace <DLC install dir> with the name of the directory into which the PROGRESS Version 9 product has been installed. On Unix:
DLC=<DLC install dir>/bin/83dbutils; export DLC PATH=$DLC:$PATH;export PATH
On NT :
SET DLC=<DLC install dir>\bin\83dbutils
SET PATH=%DLC%;%PATH%
2.2 Make the location of the database to be backed up your current working directory
2.3 Backup the database using th.e following command:
83_dbutil probkup <db-name> <device-name> <options>
Where:
<db-name> is the name of the database to be backed up <device-name> is the name of the special device or standard file to receive the backup
<options> Other standard PROGRESS probkup options as can be found in the "Backing up and Restoring" chapter in the Progress System Administration Guide.
Once the database has been successfully backed up, conversion to PROGRESS Version 9 format can be performed. Information regarding truncation of the bi file and conversion to multi-volume format can be found in section 1, above. Information for how to convert
the database to PROGRESS Version 9 format can be found in the
System Admin Reference Manual.
3. Special considerations for SCO OpenServer and SCO Unixware
platform users.
Beginning with PROGRESS Version 9 both PROGRESS SCO platforms;
SCO OpenServer
Unixware
share common executables. PROGRESS Versions prior to PROGRESS version 9 did not. As a result the PROGRESS Version 8.3 DB utilities described in his note are included for both platforms. Which platform the database to be worked with resides on dictates the set of PROGRESS Version 8.3 binaries to be utilized. If the platform is SCO OpenServer please
cp $DLC/bin/83dbutils/sco/* $DLC/bin/83dbutils
If the platform is Unixware please
cp $DLC/bin/83dbutils/unixware/* $DLC/bin/83dbutils
Once either of these steps has occurred the instructions above will apply and function properly..