Multi Volume possible with a Workgroup licence ?

[Olivier_Desmars]

[SOLVED] Multi Volume possible with a Workgroup licence ?

Windows 2000 Server Sp3 + Progress 9.1B

Is it possible to make a multi volume database with a Workgroup licence ?


here's what I am doing :


First I create an ST file for my MV database :

#
b c:\test\mydb.b1
#
d "Schema Area":6,32 c:\test\mydb.d1
#
d "Data Area":7,128 c:\test\mydb_7.d1 f 1500000
d "Data Area":7,128 c:\test\mydb_7.d2 f 1500000
d "Data Area":7,128 c:\test\mydb_7.d3

Then I create the MV database :

PROSTRCT create c:\test\mydb c:\temp\mydb.st

Watching in directory C:\TEST :

30/07/2003 15:50 mydb.st 258
30/07/2003 16:28 mydb.db 32 768
30/07/2003 16:28 mydb.b1 32 768
30/07/2003 16:28 mydb.d1 32 768
30/07/2003 16:28 mydb_7.d1 1 536 032 768
30/07/2003 16:28 mydb_7.d2 1 536 032 768
30/07/2003 16:28 mydb_7.d3 32 768
30/07/2003 16:28 mydb.lg 183

So all the files have been created.

From what I have read on this forum, I have now to perform a procopy from my old database, or a prorest, to place data in my new database. In both case it doesn't work :

1st) The Procopy (might be the simplest) :

procopy c:\singledb\mydb.db c:\test\mydb.db

Instead of loading the data in the MV DB, it only copies the single DB files (.DB, .D1 and .B1) to the C:\TEST directory ??

2nd) The Prorest give me the following errors

-> Unequal number of user areas detected in the target database. (6770)
-> Source database contains 1and target database contains 2 (6771)
-> Restore failed. (1618)



HEEEEEELP :blush:

PS: I tried the same on another computer (Win2K SP4 Pro + progress 9.1B) and it gives me the same errors (Workgroup licence also)

PS2: The ST file for my single database looks like this :

#
b c:\singledb\
#
d "Schema Area":6,32 c:\singledb\

PS3: The PROSTRCT STATISTICS of my single database give me :

PROGRESS Version 9.1B as of Thu Aug 17 22:49:26 EDT 2000
Storage Utilization Statistics
Database: c:\singledb\mydb
Primary data block size: 4096
BI block size: 8192
AI block size: 8192
Database Phyical structure information

Statistics for Area: Control Area
Files in Area: Control Area
c:\singledb\mydb.db 32768
Database Block Usage for Area: Control Area
Active blocks: 5
Empty blocks: 3
Extent blocks: 1
Total blocks: 8
Records/Block: 32

Statistics for Area: Primary Recovery Area
Files in Area: Primary Recovery Area
c:\singledb\mydb.b1 2228224

Statistics for Area: Schema Area
Files in Area: Schema Area
c:\singledb\mydb.d1 30015488
Database Block Usage for Area: Schema Area
Active blocks: 7315
Empty blocks: 13
Extent blocks: 1
Total blocks: 7328
Records/Block: 32

Database Block Usage Summary
Active blocks: 7320
Data: 6634
Free: 686
Empty blocks: 16
Extent blocks: 2
Total blocks: 7336

 

[Olivier_Desmars]

The error come from the ST file used to generate the multi db file :

#
b c:\test\mydb.b1
#
d c:\test\mydb.d1 f 1500000
d c:\test\mydb.d2 f 1500000
d c:\test\mydb.d3

is a working ST file.

Shame on Me :blush1: