Re: DB backup doesn't decrease recovery log utilization

Mauro,

The point is to always keep distance between your log size and 5GB.  I
like to keep 1GB (your 4096MB) distance but half that is probably OK.

Steffan

"Mauro M. TINELLI" wrote:
>
> Steffan,
>
>         you're trying to scare me, aren't you! Well you succeed.
> What about 4096 MB? will they be all right?
>
> Mauro, STM
>
> > 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