DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Two Phase COmmit

  1. 05-11-2001, 07:27 AM #1
    sudip's Avatar
    sudip
    sudip is offline Senior Member
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Talking

    What is a two phase commit?
    There Nothing You cannot Do, The problem is HOW.
    Reply With Quote Reply With Quote
  2. 05-11-2001, 07:49 AM #2
    rohitsn
    rohitsn is offline Advisor
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    See TWO PHASE COMMIT comes in Distributed Database System.In Two phase Commit all the database servers in distributed database either commit or rollback as a unit.

    For e.g Say u are running a transaction which updates 3 databases.So incase if one database is not able to commit the transaction,the other databases will also not commit the transactions.So there is data integrity in distributed database system.Oracle automatically performs TWO PHASE COMMIT.

    In case of any help needed please be free to ask me at rohitsn@altavista.com


    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com
    Reply With Quote Reply With Quote
  3. 05-11-2001, 07:58 AM #3
    harvy
    harvy is offline Junior Member
    Join Date
    Apr 2001
    Posts
    16

    two phase commit

    Hi,

    The two phase commit mostly works in a distributed environment where it any of the transaction fails(due crash,powerfailure,etc) it is either comited or rolledback.
    Reply With Quote Reply With Quote
  4. 05-11-2001, 08:00 AM #4
    sudip's Avatar
    sudip
    sudip is offline Senior Member
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Thumbs up

    Thanx a lot, Guys.
    There Nothing You cannot Do, The problem is HOW.
    Reply With Quote Reply With Quote
  5. 05-11-2001, 10:51 AM #5
    padmam
    padmam is offline
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Very Interesting Explanation

    Hi, 11th May 2001 20:27 hrs *******

    Find enclosed a very good link on two phase commit explained digramatically.

    http://www.sei.cmu.edu/str/descriptions/dtpc_body.html

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width