Gerhard,


I have seen a situatuion where the recovery log was filling rapidly  (1
or 2 % every 2 or 3 mins) caused by a client backing up thousands of
small files, causing database entries to be generated quicker than they
can be commited (The explanation I was given, anyway) It may be worth
looking at this.

Matthew Warren.
HOIST - Head Office Infrastructure Support Team.
ADSM (FAB) + Unix support.
        Marks & Spencer Plc.
        Baker Street.
        London.
Email: matthew.warren AT marks-and-spencer DOT com




> -----Original Message-----
> From: Gerhard Rentschler [SMTP:g.rentschler AT RUS.UNI-STUTTGART DOT DE]
> Sent: Wednesday, April 22, 1998 3:45 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Recovery Log filling fast
>
> Hi,
> I have the follwing strang eymptom. My recovery log is filling
> rapidly. The
> recovery log is 1124 MB, the database is 4096 MB. The last full backup
> was
> done 8 hours ago. Now the recovery log contains 485 MB of data. But
> only
> 200 MB were changed in the database. How can this be explained?
> My server is on an AIX 4.2.1 and is level 2.1.5.13. Most clients are
> version 3.
> 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