The active log space is preallocated at the file system level, you can check the current log file (1504) in use as follows:
$ db2pd -db tsmdb1 -logs Database Partition 0 -- Database TSMDB1 -- Active -- Up 6 days 01:53:15 -- Date 07/26/2011 12:16:27 Logs: Current Log Number 1504 Pages Written 984 Cur Commit Disk Log Reads 0 Cur Commit Total Log Reads 0 Method 1 Archive Status Success Method 1 Next Log to Archive 1504 Method 1 First Failure n/a Method 2 Archive Status n/a Method 2 Next Log to Archive n/a Method 2 First Failure n/a Log Chain ID 6 Current LSN 0x000000BC027D8E23 $ ls S0001503.LOG S0001508.LOG S0001513.LOG S0001518.LOG S0001523.LOG S0001528.LOG S0001533.LOG S0001538.LOG S0001543.LOG S0001548.LOG S0001553.LOG S0001558.LOG S0001504.LOG S0001509.LOG S0001514.LOG S0001519.LOG S0001524.LOG S0001529.LOG S0001534.LOG S0001539.LOG S0001544.LOG S0001549.LOG S0001554.LOG S0001559.LOG S0001505.LOG S0001510.LOG S0001515.LOG S0001520.LOG S0001525.LOG S0001530.LOG S0001535.LOG S0001540.LOG S0001545.LOG S0001550.LOG S0001555.LOG S0001560.LOG S0001506.LOG S0001511.LOG S0001516.LOG S0001521.LOG S0001526.LOG S0001531.LOG S0001536.LOG S0001541.LOG S0001546.LOG S0001551.LOG S0001556.LOG S0001561.LOG S0001507.LOG S0001512.LOG S0001517.LOG S0001522.LOG S0001527.LOG S0001532.LOG S0001537.LOG S0001542.LOG S0001547.LOG S0001552.LOG S0001557.LOG SQLLPATH.TAG If it is full, a new log file is used. When a log file is no longer active (all sql statements are committed), it is archived: $ db2 get db cfg for tsmdb1 | grep LOGARCH First log archive method (LOGARCHMETH1) = DISK:/tsm1/archlog/archmeth1/ So it works as DB2 is supposed to do. Best regards, Kurt -----Oorspronkelijk bericht----- Van: ADSM: Dist Stor Manager [mailto:[email protected]] Namens Paul Fielding Verzonden: maandag 25 juli 2011 15:20 Aan: [email protected] Onderwerp: Re: [ADSM-L] Active logs taking 4 days to delete in 6.2 Yeah, I am. The thing that's wierd is the 4 day delay. Active logs are getting deleted, but they're waiting 4 days to do so. And this is not how the behavior has always been since going to 6.2. I just noticed the change one day. Very bizarre... On Mon, Jul 25, 2011 at 6:59 AM, Zoltan Forray/AC/VCU <[email protected]>wrote: > Are you doing "backup volhist" as well? IIRC, there was a discussion > that you needed to do that as well to purge activity logs. Plus it is > a requirement to perform DB restores on 6.x servers. > > > Zoltan Forray > TSM Software & Hardware Administrator > Virginia Commonwealth University > UCC/Office of Technology Services > [email protected] - 804-828-4807 > Don't be a phishing victim - VCU and other reputable organizations > will never use email to request that you reply with your password, > social security number or confidential personal information. For more > details visit http://infosecurity.vcu.edu/phishing.html > > > > From: > Paul Fielding <[email protected]> > To: > [email protected] > Date: > 07/25/2011 08:50 AM > Subject: > [ADSM-L] Active logs taking 4 days to delete in 6.2 Sent by: > "ADSM: Dist Stor Manager" <[email protected]> > > > > So, at one of my client sites I noticed that the Active log filesystem is > sitting at 82% full. This is not normal for this TSM server. Looking in > the filesystem I saw active logs going back four days. Checking the > actlog > shows that TSM db backups are still running properly every day, but just > to > be safe I ran two db backups in succession. No logs were removed. > > I decided to keep an eye on it. What I see happening is that each morning > when I look at it, there are still four days worth of logs, but the oldest > logs are moving forward by a day. ie. when I looked on July 22, the > oldest > log was July 18. When I looked on July 23, the oldest log was July 19. > Today, July 25, I see the oldest log is July 21. > > This strikes me as a bit bizarre. Anyone have any ideas? > > regards, > > Paul > *** Disclaimer *** Vlaamse Radio- en Televisieomroeporganisatie Auguste Reyerslaan 52, 1043 Brussel nv van publiek recht BTW BE 0244.142.664 RPR Brussel http://www.vrt.be/gebruiksvoorwaarden
