Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2011

    Unanswered: DB2 9.7 UDB - transaction Log space.

    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 ?
    please advise.

  2. #2
    Join Date
    Jan 2010

    the maximum value describes the High Water mark for the amount of space used by open transactions. It's not the amount of logspace written over time.


  3. #3
    Join Date
    Nov 2011

    the eqation is not correct

    as you said, according to the high water mark, only 20MB was used. So there should be only 2 log files in the archive area.
    But there are 30 logs in archive.

    Any ideas?

  4. #4
    Join Date
    Apr 2006
    Provided Answers: 11
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts