Re: Script to handle hanging shutdowns

From: Ed Jennings <jennings_at_dca.net>
Date: 1996/07/25
Message-ID: <31F841A6.75B0_at_dca.net>#1/1


J Ford Hill wrote:
>
> Some of our databases hang on shutdown and this prevents our backup script
> from getting a good backup. Does anyone have a script that:
> 1) attempts a shutdown
> 2) checks to make sure the shutdown worked
> AND
> 3) If the shutdown failed, does a shutdown abort, startup,
> and clean shutdown???
>
> I have these specific questions about the above process:
>
> 1) How do you detect if your database did not shut down cleanly.
> Is the existance of the 'sgadef' file the key?
>
> 2) Can a unix script fork off another process that sleeps for a
> few minutes and then does the shutdown abort if the "sgadef"
> still exists?
>
> Thanks in advance.

I have been experiencing this problem since 7.2.2.3. Never saw it in 7.1.6 or earlier. Does anyone have an explaination or a cause? My logs don't indicate any problems. What causes the hang??

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~
jennings_at_dca.net
Received on Thu Jul 25 1996 - 00:00:00 CEST

Original text of this message