
Logical recovery during startup takes long
We stopped our Informix server (7.31.FC6) and started it again a bit
later. The engine needed more than an hour to finish the logical
recovery. It really rolled back one transaction and the only reason I
can accept that this might have been a long one.
Questions:
1. Is it a normal behaviour? In case it really had a relative long
uncomplete transaction should it not have rolled it back at shutdown?
2. How can this be prevented? Let us suppose you have a half an hour
time-window to do a quick maintenance at your productive engine, you
shut Online down, and later you start it again. But your startup is
delayed because it needs a long, long time to make the logical recovery.
I mean it may be very difficult to explain your users...
Many thanks for any reply.
Regards
Peter Dzvonyar
SAP-Consultant R/3 BC
------
Here is the relevant part of the message log:
....
18:17:35 Checkpoint Completed: duration was 1 seconds.
18:17:36 Informix Dynamic Server Stopped.
Tue Nov 7 20:06:51 2000
20:06:51 Event alarms enabled. ALARMPROG =
/informix/Q12/etc/log_full_muell.sh'
.....
20:07:05 Informix Dynamic Server Initialized -- Shared Memory
Initialized.
20:07:05 Physical Recovery Started.
20:07:06 Physical Recovery Complete: 0 Pages Restored.
20:07:06 Logical Recovery Started.
20:17:21 Checkpoint Completed: duration was 5 seconds.
20:59:59 Checkpoint Completed: duration was 6 seconds.
21:23:11 Logical Recovery Complete.
0 Committed, 1 Rolled Back, 0 Open, 0 Bad Locks