ADSM-L

Re: DB backup doesn't decrease recovery log utilization

1999-08-27 00:29:15
Subject: Re: DB backup doesn't decrease recovery log utilization
From: arhoads <arhoads AT PACBELL DOT NET>
Date: Thu, 26 Aug 1999 21:29:15 -0700
Mauro,

Just a tip: reduce your log back down to 4GB or so.  At 5GB should you
run into a problem your only resort will be to restore the database from
the last backup.

Steffan

"Mauro M. TINELLI" wrote:
>
> Gerhard,
>
>         I had a exactly the same problem. Once, it happened at night when I'm
> running all the back-ups, so the system after rescheduling 4 times a DB
> Backup, closed itself up, and the next morning I had to add some log
> space in order to restart the server.
>
>         The log was about 1 Gbyte in size ... now is 5 Gbytes and the
> DbBackupTrigger is at 55%. It never happened again! he maximum I reached
> is 75% of log in use. Is it a workaround? I don't know, but it fixed the
> problem.
>
> PS. IBM said the problem was known. But they asked me to lower the DBB
> threshold and it didn't work.
>
> Mauro, STM
>
> > Hello,
> > since yesterday I have a problem.
> > I use the recovery log in rollforward mode. When DB backup is finished,
> > the recovery log utilization is not decreased in any way. I have to
> > restart the server to accomplish this.
> > An example: I started a backup when the recovery log utilization was
> > 26.9 %. It was an incremental which finished after about 10 minutes.
> > Afterwards the recovery log utilization was 27.0% and was still
> > increasing. After the restart of the server it was 0.4%.
> > Has anyone seen this behaviour? Any idea what I can do? I will open a
> > PMR asap.
> > BTW, the server is level 3.1.2.40 on AIX 4.2.1.
> > Best regards
> > Gerhard
> >
> > ---
> > Gerhard Rentschler            email:g.rentschler AT rus.uni-stuttgart DOT de
> > Regional Computing Center     tel.   ++49/711/685 5806
> > University of Stuttgart       fax:   ++49/711/682357
> > Allmandring 30a
> > D 70550
> > Stuttgart
> > Germany