Progress
Database Administration
Guide and Reference


Converting a Single-volume Version 8 Database With PROCOPY

Follow these steps to convert an existing Version 8 single-volume database to a multi-volume database:

  1. Create a structure description file to define the appropriate files for the multi-volume database. Give this structure description file a different name from the single-volume database you want to convert.
  2. For example, suppose you have a single-volume database called finance.db on a UNIX machine. You might create the following structure description file:

          * 
          * This is a structure description file for a multi-volume Progress 
          * database composed of two fixed-length data extents, one variable- 
          * length data extent, one BI extent and two variable-length AI  
          * extents. 
          *  
          *  
          *  
          *  
          *  
          d   /vol1/fsys1/finance2.d1      f  224000 
          d   /vol2/fsys1/finance2.d2      f   96000 
          d   /vol2/fsys2/finance2.d3 
          b   /vol2/fsys2/finance2.b1 
          a   /vol2/fsys3/finance2.a1 
          a   /vol2/fsys3/finance2.a2 
    

  3. Use the PROSTRCT utility with the CREATE qualifier to create a void multi-volume database structure from the information in the structure description. Give this database the same name as the structure description file. Following is an example of the command:
  4. prostrct create finance2 
    

  5. Use the PROCOPY utility to copy the single-volume database to the void multi-volume database structure. The source database cannot be in use when you attempt to use PROCOPY. In addition, you cannot use PROCOPY against a crashed database; you must recover the database first. Following is an example of the PROCOPY command:
  6. procopy finance finance2 
    

The resulting database is then ready to use with Progress applications and can be directly converted to Progress Version 9.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095