If roll forward mode is not being used, the cause is probably a long
transaction in the ADSM database.

The exact transaction can be determined with show commands, but it is not
easy at all.  The easiest way is to look at the oldest running sessions and
see which one has been backing up one file or Dbspace for the longest time.
3.2.41 and over Server levels also have an issue when nothing is running the
log sometimes will not clear.

Jeff Bach


        -----Original Message-----
        From:   Gill, Geoffrey L. [SMTP:GEOFFREY.L.GILL AT SAIC DOT COM]
        Sent:   Monday, May 21, 2001 9:02 AM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        Recovery Log

        This morning I noticed my recovery log had risen to 83.2 at some
point over
        the weekend. I'm already doing a full and one incremental backup of
the log
        every day to keep it's size down. As you can see it's only 4GB and I
still
        have room.

        The real question is, how and why did it get that high in the first
place?
        The previous high had been 39.3%. Is there any way to find out what
caused
        this or exactly when it happened?

        Thanks for the help....

               Available Space (MB): 4,096
             Assigned Capacity (MB): 4,096
             Maximum Extension (MB): 0
             Maximum Reduction (MB): 4,088
                  Page Size (bytes): 4,096
                 Total Usable Pages: 1,048,064
                         Used Pages: 465
                           Pct Util: 0.0
                      Max. Pct Util: 83.2
                   Physical Volumes: 2
                     Log Pool Pages: 2,048
                 Log Pool Pct. Util: 0.19
                 Log Pool Pct. Wait: 0.00
        Cumulative Consumption (MB): 34,747.88
        Consumption Reset Date/Time: 04/24/01 15:06:46

        Geoff Gill
        TSM Administrator
        NT Systems Support Engineer
        SAIC
        E-Mail:   gillg AT saic DOT com
        Phone:  (858) 826-4062
        Pager:   (888) 997-9614


**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to
whom they are addressed.  If you have received this email
in error destroy it immediately.
**********************************************************************