Convert 8.3 version db to 9.1d

[kevin_w]

Hi,


I wanne convert a 8.3 version db to a 9.1d, i've try to use the conv89 utility but than i get a error that it's not a multi-volume db.

Is it possible to convert the db to multi-volume only with progrss 9.1d installed ?

 

[FrancoisL]

You will have to use the 8.3 Tools in your 9.1D installation. They are in the DLC/bin directory.

 

[kevin_w]

Hi,

I can find this tools in my directory could you please explain wich tools you mean (which exe files ???)

 

[tamhas]

It's been a long time since 8.3 to 9.x, but I think the indication is to convert it to multi-volume in 8.3 and then use conv89 to move it to 9.x.

Why in the world 9.1D??? If 9, should be 9.1E. But, why even 9?

 

[TomBascom]

The tools are in $DLC/bin/83dbutils.

Truncate the bi file and backup your database before trying to do a conversion.

It has been a long time and I could be wrong but... as I recall the conversion from single volume to multi-volume will be handled by conv89 if it wasn't done in v8 first. Given the option I'd do as suggested and, if necessary, convert to multi-volume with v8 tools (many databases were already multi-volume).

 

[FrancoisL]

conv89 did not convert the database to a multi-volume , it would simply give out an error that you need to convert it .

If the 83dbutil directory does not exist , you can always copy the DLC directory from an old install , you don't need to reinstall it to use the tools.

 

[kevin_w]

If i wanna make multi-volume database i first need to create a new db and then i need a st-file i think. Problem is that i don't have this file can i build it up with a command given to the 8.3db ?

 

[TomBascom]

ID: P5884
Title: "How to convert a version 7 or 8 single-volume database to multi-volume"
Created: 08/06/2002 Last Modified: 09/26/2008
Status: Verified


Goals:
# How to convert a version 7 or 8 single-volume database to multi-volume
# How to convert a single-volume db to multi-volume when it's close to the 2 GB limit


Facts:
# All Supported Operating Systems
# Progress 7.x
# Progress 8.x


Fixes:
There are two ways to accomplish this :

1. If you have enough space to have the new database but still keep the current database, use PROCOPY.
- Create a structure file to define the appropriate files for the multi-volume database

Example of an .st file for UNIX:

* BigDB.st
*This file will create a 3 GB DB
*with 1 GB fixed size data extents plus a flexible one in the current directory.
*
d ./BigDB.d1 f 1048576
d ./BigDB.d2 f 1048576
d ./BigDB.d3 f 1048576
d ./BigDB.d4
b ./BigDB.b1

- Use PROSTRCT CREATE to create a void multi-volume database from the structure file

Example:

prostrct create BigDB BigDB.st

- Use PROCOPY to copy the single-volume database to the void multi-volume database structure.

Example:

procopy OldDB BigDB

2. Converting with PROREST
- Backup the single-volume database using PROBKUP
- Test backup file using PROREST -vf (Full Verify)
- Delete single-volume database
- Create structure file to define appropriate files for multi-volume database.
- Use PROSTRCT CREATE to create a void multi-volume database structure
- Use PROREST to restore the backup into the void multi-volume structure.


Follow normal database backup procedures prior to performing any modification to your databases. If you have not yet performed a backup of your database please refer to the 'backing up your database' in section 2 in the readme file.


Notes:
Reference to written documentation :
V8: "System Administration Guide", Chapter 6.7: Converting a Single-volume Database to a Multi-volume database. In V9 the database is Multi-volume by default. You must convert your Version 8 databases to a multi-volume structure before converting the databases to Version 9.