help me prostrct create blocksize problem

N

netfreebsd

New Member
OS: Windows Server 2003
PROGRESS version 8.3B
prostrct create db db.st

#db.st
d d:\db\db.d1 f 2000000
d d:\db\db.d2
b d:\db\db.b1

#d:\db
db.b1 16 kb B1 file
db.d1 2,000,000 kb D1 file
db.d2 4 kb D2 file
db.db 8 kb Data Base File
db.st 1 kb ST File

!!!! my question !!!!!
1. why db.d2 is blocksize 4 kb. how to change blocksize to 8 kb ?

please help;
 
Pls don't get mad at me, BUT, Progress 8.3 is so old that I am barely aware it did exist ... must have been somewhere around 1995 when life was still easy ...

How did you determine that the blocksize of the individual database extents is different? What are the error messages you are getting?


Regards, RealHeavyDude.
 
4kb blocksize on windows is usually recommended.

You can't have multiple blocksizes in a progress db. Look at the db log for a line that states what the blocksize is, it will look similar in format to - Database Blocksize (-blocksize): 8192

to change dbblocksize requires creating a new db and then moving the existing data to the new db. Lots of articles on the progress kb to help.
 
thank for help
I want move single volume db to multi volume db but old single volume is blocksize 8192 when use command prorest error is

Source and Target database should have the same blocksizes: source 8192, target 4096


## add my question ?
1. when use command run prostrct create -->> call _dbutil.exe in DLC/bin with create db right.
so default blocksize 4096, 8192 what is file or shema file decide

2. When I run command prostrct create db db.st - blocksize 8192 on os windows system is error message --> This version of PROGRESS does not support variable sizes for database blocks (-blocksize). (5866)
 
When you create a new void database structure and you don't want it to have the default blocksize you need to specify the blocksize you want to have:

prostrct create db-name -blocksize 1024|4096|8192

There is no way to populate a void database structure with a backup that has a different database blocksize.

When you restore a backup to populate a void database structure then you must have created the void database structure with the proper database block size in the first place.

But, you don't necessarly need to create the void database structure upfront. You could just restore the database into the target location. If a structure description file is existing then the restore will use it, otherwise it will create just one big extent. BUT, V8.3 has a 2GB file limit. If your database is larger than 2GBs you need to have a structure description file, otherwise the restore will fail.

HTH, RealHeavyDude.





I
 
Hi, I check version 8.3B not support for -blocksize server 2003.
I run command prostrct create db -blcoksize 8192 db.st

" is error -blocksize not support this verisons"
 
#d:\db
db.b1 16 kb B1 file
db.d1 2,000,000 kb D1 file
db.d2 4 kb D2 file
db.db 8 kb Data Base File
db.st 1 kb ST File


I want change default blocksize from 4 kb to 8 kb. how to change this os or schema file of progress or file ? in progress db. So progress 8.3B is not change or not support change blocksize. This is demo step by step for who is expert progress all is help me.
1. --> prostrct create db_name st file (os=server 2003)
2. --> result command is

* for windows is not support blocksize but for unix is support blocksize. progress is same version.



db.b1 16 kb B1 file
db.d1 2,000,000 kb D1 file --> create with 4 kb --> change to 8 kb
db.d2 4 kb D2 file --> create with 4 kb --> change to 8 kb
db.db 8 kb Data Base File
db.st 1 kb ST File



Thank for help.
 
You must log in or register to reply here.
Back
Top