If the log utilization gets to 100%, it will not only shut down sessions, it
will crash the server.


-----Original Message-----
From: Suad Musovich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 2:29 AM
To: [EMAIL PROTECTED]
Subject: Re: Recovery log utilization does not drop after DB backup


> some time ago I complained in a mail to this list that the recovery log
> utilization is not reset after a database backup. APAR IC30181 was
generated
> for this problem. Its status is "open".

I complained about the problem too. The response I got was, when the system
was
too busy it took a while for it to happen.

I have done this when no sessions/processes were running on the system and
it still
took over an hour to reset itself.

Our situation is worse as sometimes the log jumps up to over 90% before we
start to
backup (triggered by a ANR0314W). It has continued to increase after the
backup
and has got to 98% in one observed instance. Will it stop sessions if it
gets to 100?

The reason we don't have a auto triggered backup is that we use a manual
tape
drive (LTO is a bit of a waste for incrementals).

Suad
--

Reply via email to