can we change the block size if its defined already-basic question

[richieasir]

can we change the block size if its defined already+some more basic question

hi all,
I have created a database with prostrct which i defined the block size as 4096.after creating,it will be a void database.so i try to copy from the existing database sports2000(block size is 1024) using procopy.
but am getting error- source and target should have same block size.

1) is it possible to change the block size what i have already defined(from 4096 to 1024)?
(simply my question is-how to add meta schema to void database if its blocksizes are different?

*******************************

2) I created a .st file with some extent size and when i performed prostrct,it gives me a warning "extent size should be the multiple of 16".why and and again i viewed the .st file it has been converted to the nearest value which is multiple of 16,how?

*************************

3)I created a sample database and i started it using proserve.after that i performed pro dbname which shows some error...what is the difference between proserve and pro

regards
Richards

 

[TomBascom]

Re: can we change the block size if its defined already+some more basic question

hi all,
I have created a database with prostrct which i defined the block size as 4096.after creating,it will be a void database.so i try to copy from the existing database sports2000(block size is 1024) using procopy.
but am getting error- source and target should have same block size.

1) is it possible to change the block size what i have already defined(from 4096 to 1024)?

No. If this were a database with data in it and you wanted to change the block size you would need to dump & load.

(simply my question is-how to add meta schema to void database if its blocksizes are different?

There are several different empty databases in $DLC. Use the appropriate one for your block size.

2) I created a .st file with some extent size and when i performed prostrct,it gives me a warning "extent size should be the multiple of 16".why and and again i viewed the .st file it has been converted to the nearest value which is multiple of 16,how?

When Progress extends an extent it does it 16 blocks at a time. The prostrct command considers an odd extent size to be something worth warning you about but, as you have observed, it automatically adjusts it.

3)I created a sample database and i started it using proserve.after that i performed pro dbname which shows some error...what is the difference between proserve and pro

proserve starts a multi-user database server.

pro starts a single user session. If you have already started a db server pro will fail.

mpro starts a multi-user session. If you have not started a db server mpro will fail.