I've seen this before but on OS/390 not on Aix.
It happens when there is a hung client session. According to IBM this hung
session can in turn
causes a thread to hang in the recovery log which prevents it from
resetting.
(the session cannot be cancelled)
This is why when ADSM is restarted , the thread is released and the recovery
log can reset.
Are you seeing hung sessions?
Nathan
-----Original Message-----
From: Mauro M. TINELLI [SMTP:Mauro.TINELLI AT ST DOT COM]
Sent: Thursday, August 26, 1999 11:42 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: DB backup doesn't decrease recovery log
utilization
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
|