RE: Logical recovery during startup takes long

Peter 1. Not normal for most cases. However if you stop the engine with a very long transaction in progress, without first completing that transaction, then at startup the engine rolls the transaction back. This may take some time. I have seen a case of over 3 hours - but I was aware of a huge transaction involving temp tables of hundreds Mb. 2. Dont shut down with a big transaction in progress. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Peter Dzvonyar Sent: Thursday, November 09, 2000 1:58 AM To: informix-list@iiug.org Subject: 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 MemoryInitialized. 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