We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Hi. I would ask about...how  db2 handle  transaction rollback?

vescafi
vescafi asked
on
Medium Priority
634 Views
Last Modified: 2012-06-22
how  db2 handle  transaction rollback?

And how is this handle in two or more database?

Regards
Comment
Watch Question

what do you mean by how?
it undo the changes like any other database

for distributed transactions it uses a two-phase commit protocol

Author

Commented:
i mean
what is the memory structure  within instance db2...
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:

So
Oracle saves rollback transactions in rollback segments.
 However we also have a log buffer, for forward.

 DB2 do it in the log buffer?
the forward transaction and undo transaction  Both are within log buffer?

Thank you a lot!
yes
everything goes to the log buffer
Note that different platforms can handle it in different ways. Most likely the given answers so far fit your platform, but it might be useful if you tell us what platform you are running DB2 on.

Tom

Author

Commented:
sure , i have AIX 5.3 Operating System.
Just wanted to be sure. Then nothing needs to be added by someone like me.

Tom
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.