we are running DB2 9.7 UDB on win 2008 R2 - HADR enviornment.
Question about logs.
I have setup primary logs to 40 and secondary log to 60.
Log size is 10MB.
Configured to Archive log.
Database size is around 480GB.
By checking archive log folder, I can see there are around 30 (average per day) logs are archived. This means to me that 30 logs are used per day.
BUT, i did the snapshot for the database and I can see the following log details.
Log space available - 1038669727 bytes
Log space used by the db - 4786273 bytes
Maximum total log space uses - 21070297 bytes
Seconday log usage -0
I reset the monitor ,then after 24 hours did the above snapshot.
The question is, the snapshot information and the archived logs are not tally.
Can someone give me some idea why ? am I doing something wrong ?
you can close a logfile with archive command - as db2 does while executing backup..
the size of the closed logfile can be truncated because the file was not filled
the nbr of files is not reflecting the logspace used....
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be