Kbase P67854: Bundled Version 8 and 9 dbutilities available in OpenEdge 10, OE10
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/18/2006 |
|
Status: Verified
GOAL:
Are there version 8 or 9 utilities bundled with OpenEdge 10, OE10?
GOAL:
If I no longer have version 8 or 9 of Progress installed, how can I truncate my BI file in OpenEdge 10?
GOAL:
Where can I find utilities to convert a version 6, 7, 8 or 9 database when only OpenEdge 10, OE10 is installed on the machine
GOAL:
Where is the utility to convert a Version 8.3 single volume database to a multi-volume database when OpenEdge 10, OE10 is the only version of Progress installed?
FIX:
OpenEdge 10 (OE10) comes with 83dbutils and 91dbutils bundled into the release. These utilities are provided for the purpose of being able to perform administrative tasks against an version 8 or 9 database without having to have the original version 8 or version 9 release installed.
The utilities are located in:
$DLC/bin/83dbutils (Version 8 utilities)
$DLC/bin/91dbutils (Version 9 utilities)
A readme file exists in each one of these directories. The readme file provides detailed information regarding commands/utilities located in these directories.
Version 8 utilities in 83dbutils:
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>
NOTE: If the database you have from version 6 or 7 was created on a DOS or Novell system it will be 512 byte blocksize and the only way to migrate would be to perform a dump and load. These tools can not migrate from a 512 byte blocksize database.
The message you will receive is:
SYSTEM ERROR: Invalid blocksize 512 in database <database name>. (4521)
Version 9 utilities in 91dbutils:
File Name Summary
91truncatebi Use to truncate the bi file for a PROGRESS Version 9.1
single or multi-volume Database.
Usage: 91truncatebi <dbname>
91conv89 Use to convert a PROGRESS Version 8 database to
PROGRESS Version 9.1 format.
Usage: 91conv89 <dbname>
To execute one of the commands above, either provide explicit path to the executable itself like $DLC/bin/91dbutils/91truncatebi or add the directory to your $PATH environment variable.