Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2012
    Posts
    6

    Unanswered: COMMIT/ROLLBACK process?

    What happens when i COMMIT / ROLLBACK the work in DB2
    Ex: A transaction process is updating say 100 records in to the table and committing the task. I want to understand this process, how these 100 records will get updated when a COMMIT is executed and until Commit where these records be read/stored?, in the buffer pages?

    Please share your thoughts on Rollback process too.

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    When you are using DML (update, insert, delete), DB2 uses the logs to track what you are doing (e.g. before and after image for an update). It also writes the data to the table.

    If you commit, the DB2 marks the logs as committed and that is the end. If you rollback, DB2 uses the logs to return the table data to the state it was in before the transaction started.

    Andy

  3. #3
    Join Date
    Oct 2012
    Posts
    6
    Thanks for your thoughts on this Andy

Posting Permissions

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