Consultor Eletrônico

Creating a multi-volume db from a single-volume db

910624-pjh01
INTRODUCTION:
=============
This Product Services Technical Support Knoledgebase entry provides
a brief description of how to convert your single-volume database
into a multi-volume database.


PROCEDURAL APPROACH:
====================
First, take a backup of your current database using probkup
(3-6 in Sys Admin Guide - Ver. 5) or (4-7 in Sys Admin II - Ver. 6).
Then test your backup to make sure that it worked properly!

Then create a structure file of how you want your multi-volume
database to be structured - where you want the extents to go
(V5 example Sys. Admin pg. 5-5 and V6 example Sys Admin II pg. 6-8).

After you create your structure file, create a void multi-volume
database using the following command as an example:

prostrct create dbname dbname.st

This creates your new database structure. At this point, you
need to restore the backup of your original database into the new
multi-volume structure. For example:

prorest dbname.db /devicename

For further instructions refer to Chapter 3 in the Sys Admin Guide
for Version 5 and Chapter 4 in Sys Admin II for Version 6.

At this point, it should be transparent to users of the database
that it is a multi-volume structure.


REFERENCES TO WRITTEN DOCUMENTATION:
====================================
Version 5 - Chapter 5 in System Administration Guide.

Version 6 - Chapter 6 in System Administration II.

Progress Software Technical Support Note # 796