Kbase P1446: Error 647 when starting database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/06/2010 |
|
Status: Verified
SYMPTOM(s):
Error 647 when starting database
bkset: Extent [file-name] is below size [file-size]. (647)
After prostrct add of an extent larger than 2Gb
prostrct remove does not resolve issue
No backup made before starting prostrct add utility
No space on machine to restore backup into another directory
FACT(s) (Environment):
Progress 8.x
CAUSE:
Extents reaching the 2GB Progress limit cannot extend, the prostrct add, added extents larger than 2GB.
FIX:
STEPS:
0. Ensure that there is a reliable backup the database before proceeding
1. Change the db-name.st for the extent(s) affected to reflect a fixed extent size that is less than 2GB, depending on the database blocksize:
In effect, the "2GB" extent file size is dependant on the database blocksize: dblocksize (2097152-(16*dblocksize))
1KB 2,097,136
2KB 2,097,120
4KB 2,097,088
8KB 2,097,024
2. prostrct repair facilitates changing the extent size. Make sure that the db-name.st file is included in the command line and that absolute file references are defined for all extents listed.
$ prostrct repair db-name db-name.st