Olivier_Desmars
Member
[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
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