Re: dbshut
From: Andre van Winssen <andrevw_at_ideta.nl>
Date: Wed, 7 Dec 1994 07:37:39 GMT
Message-ID: <D0FJus.LM_at_ideta.nl>
Date: Wed, 7 Dec 1994 07:37:39 GMT
Message-ID: <D0FJus.LM_at_ideta.nl>
davidjroth_at_aol.com (DavidJRoth) writes:
>In article <stanbD045Cw.95q_at_netcom.com>, stanb_at_netcom.com (Stan Brown)
>writes:
>SHUTDOWN IMMEDIATE will not work (quickly) if there is a long running
>transaction since it will wait for the transaction to complete.
Sorry, but this is NOT TRUE. What you described was a NORMAL shutdown.
A SHUTDOWN IMMEDIATE terminates all client SQL statements being processed. Any uncommitted transactions are rolled back. This could take a lot of time!!
Killing processes on the OS level will not help either, since outstanding transactions still have to be rolled back.
AvWinssen
-- Andre van Winssen <andrevw_at_ideta.nl> Ideta b.v., Frankemaheerd 6, 1102 AN Amsterdam, the NetherlandsReceived on Wed Dec 07 1994 - 08:37:39 CET