Kbase 19037: Moving the .db File in a Multi-Volume Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 8.x
SYMPTOM(s):
Can't start database after moving the .db file to another directory
Data extents are not moved
BI extent is not moved.
** <file-name> is a copy of <file-name>. Database cannot be opened (598)
** Cannot find or open file C:\WRK83E\sports.db, errno = 2. (43)
** The server terminated with exit code <number> (800)
** Unable to create <file-name>, errno = <number> (609)
** Cannot find or open file C:\WRK83E\test\sports.bi, errno = 2. (43)
CAUSE:
Prostrct Repair was not run after the database file was moved. This prevents the database from finding its extents
FIX:
To resolve the problem do the following:
1) Go to the directory containing the .db file.
2) Copy up to date .st file to directory containing the .db file.
3) PROSTRCT REPAIR <dbname>.
4) Start database with -g parameter to point to old location of the .bi extent