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
|