Kbase P123298: Why does it take a long time to startup the database after a system crash?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/06/2009 |
|
Status: Verified
GOAL:
Why does it take a long time to startup the database after a system crash?
GOAL:
Why does it take a long time to startup the database after a system panic?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
OpenEdge Category: Database
FIX:
If a database is running and users are actively working within the database (performing updates to the database) and the machine crashes the database will have to perform crash recovery the next time it is started.
The database will have to backout the transactions of every user that was connected whose work was not completed when the crash occurred.
Depending on the number of transactions which were listed as incomplete in the Before Image file, the duration of the crash recovery process may be long or short.
If there are a large number of transactions or very complex incomplete transactions the duration will likely be longer than if there is a small number of transactions or less complex transactions.