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

    Unanswered: DB2 9.7 UDB - transaction Log space.

    Hi,
    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.
    Thanks.

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    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.

    Hth
    nvk

  3. #3
    Join Date
    Nov 2011
    Posts
    87

    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
    Location
    Belgium
    Posts
    2,514
    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
    http://www.infocura.be

Posting Permissions

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