Kbase 18482: Changing DB Blocksize - Do I Have to Dump and Load ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
How to change the blocksize of the database?
GOAL:
How to change the Database's blocksize
GOAL:
Do I have to Dump and Load to change the database blocksize?
GOAL:
Can I use procopy to change the database blocksize?
GOAL:
Can I use probkup/prorest to change the database blocksize?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Progress 9.x
Progress 8.2x
Progress 8.3x
FIX:
You must dump and load your database (either through Binary Dump and Load or the Data Dictionary) when changing the Progress database block size.
You will specify the blocksize when creating the new database.
For Example:
prostrct create db-name db-name.st -blocksize 8192
This will create a database with an 8K block size. If the blocksize is not specified the default will be the block size of the operating system.
It is not possible to change the database block size via procopy and prorest.