Hi,

We just had a problem where the database was brought down but not the
database manager.
This is due to what seems to be a bug in the database engine in regards with
explain.

Now my question is, is there any monitoring (V8, Tivoli, ...?) which could
alert us when this happens?
The problem is that the SAP application looses it's connection to the
database and then tries to reconnect.
The reconnect brings the database into crash recovery and then everything is
back up. But we would like to
be alerted when something like this happens.

Anyone any ideas?

Thanks.

"Erik Hendrix" <hendrix_erik@hotmail.com> wrote in message
news:bab5d26075dc48cd43e4d385633e8c5a@news.teranew s.com...
> Hi,
>
> We just had a problem where the database was brought down but not the
> database manager.
> This is due to what seems to be a bug in the database engine in regards
with
> explain.
>
> Now my question is, is there any monitoring (V8, Tivoli, ...?) which could
> alert us when this happens?

AFAIK, Tivoli can't monitor this. I am not 100% sure -

> The problem is that the SAP application looses it's connection to the
> database and then tries to reconnect.
> The reconnect brings the database into crash recovery

If you ACTIVATE DATABASE, when all the connections were lost, at least you
wouldn't suffer CRASH RECOVERY.

> and then everything is
> back up. But we would like to
> be alerted when something like this happens.
>
> Anyone any ideas?
>
> Thanks.
>
>

"Fan Ruo Xin" <fanruox@sbcglobal.net> wrote in message
news:WWXWb.6515$PY.3583@newssvr26.news.prodigy.com ...
>
> "Erik Hendrix" <hendrix_erik@hotmail.com> wrote in message
> news:bab5d26075dc48cd43e4d385633e8c5a@news.teranew s.com...
> > Hi,
> >
> > We just had a problem where the database was brought down but not the
> > database manager.
> > This is due to what seems to be a bug in the database engine in regards
> with
> > explain.
> >
> > Now my question is, is there any monitoring (V8, Tivoli, ...?) which
could
> > alert us when this happens?
>
> AFAIK, Tivoli can't monitor this. I am not 100% sure -
Sorry. I only thought monitoring processes yesterday.
Tivoli can monitor message log. With Version 8, you can monitor notification
log file.

>
> > The problem is that the SAP application looses it's connection to the
> > database and then tries to reconnect.
> > The reconnect brings the database into crash recovery
>
> If you ACTIVATE DATABASE, when all the connections were lost, at least you
> wouldn't suffer CRASH RECOVERY.
>
> > and then everything is
> > back up. But we would like to
> > be alerted when something like this happens.
> >
> > Anyone any ideas?
> >
> > Thanks.
> >
> >
>
>