and when that log seems to not clear (and you are in logmode normal) try a
"ckpt" command from an admin session, that usually will cause it to clear
(ckpt is another debug command to force a checkpoint)
Dwight
-----Original Message-----
From: Jeff Bach [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 9:36 AM
To: [EMAIL PROTECTED]
Subject: Re: Recovery Log
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:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 9:02 AM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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.
**********************************************************************
