Kbase P111526: Why online backup is delayed by abnormal session end
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Why online backup is delayed by abnormal session end
GOAL:
Consequences of transaction rollback
FIX:
The transaction rollback, indicated within the database log file with the messages
Begin transaction backout. (2252)
Transaction backout completed. (2253)
is consuming a lot of CPU and, most of the time also is producing a lot of I/O's.
While undoing modifications made in database blocks , the machine performance is impacted and all processes may suffer from it.
The online backup is a process which requires a maximum of I/O's as it reads each database block.