Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2015
    Posts
    6

    Unanswered: query regarding transactional logs

    Hi team,

    i am currently undergoing OJT in an environment that is using db2 version 10.5, my question is, in archival logging, the transactions are limited by the log size beyond which it will start writing to a new log file, does the log file gets archived as soon as it becomes full?, or will it wait for all those transactions to complete that were first written to first log file and then in the absence of space continued writing to the second log file and so on?

  2. #2
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    Log file allocation and removal

    • logarchmeth1 or logarchmeth2 is set to a value other than OFF or LOGRETAIN
    Archive logging is used. The database is a recoverable database. Both roll-forward recovery and crash recovery are enabled. When a log file becomes full, it is automatically archived by the database manager.
    Regards,
    Mark.

  4. #4
    Join Date
    Dec 2015
    Posts
    6
    if the log file is full but active, will it still be archived?

  5. #5
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Yes, it can be archived.
    Regards,
    Mark.

  6. #6
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Posting Permissions

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