Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

what is TWO PHASE COMMITER

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
kotesh

New User


Joined: 11 May 2005
Posts: 20

PostPosted: Mon Mar 06, 2006 4:24 pm    Post subject: what is TWO PHASE COMMITER
Reply with quote

Hi Guy,
could you plese let me know about the TWO PHASE COMMITER
in DB2..

Thanks
kotesh
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Mon Mar 06, 2006 4:59 pm    Post subject: Re: what is TWO PHASE COMMITER
Reply with quote

http://ibmmainframes.com/viewtopic.php?t=2268

Regards,
Priyesh.
Back to top
View user's profile Send private message
nabarun

New User


Joined: 27 Apr 2005
Posts: 13
Location: india

PostPosted: Wed Dec 06, 2006 3:22 pm    Post subject:
Reply with quote

Two-phase commit - DB2


PHASE I.
----------


STEP 1 :

When the database client requests that the unit of work be committed, a prepare message
is sent to all databases participating in the unit of work. Each database writes a "PREPARED"
record to its log files, and replies to the database client.

STEP 2 :

After the database client receives a positive response from all of the databases, it sends a
message to the transaction manager database, informing it that the unit of work is now ready
to be committed (PREPARED). The transaction manager database writes a "PREPARED" record to its
log file, and sends a reply to inform the client that the second phase of the commit process
can be started.



PHASE II
-----------

STEP 3 :

During the second phase of the commit process, the database client sends a message to all
participating databases to tell them to commit. Each database writes a "COMMITTED" record
to its log file, and releases the locks that were held for this unit of work. When the database
has completed committing the changes, it sends a reply to the client.


STEP 4 :

After the database client receives a positive response from all participating databases,
it sends a message to the transaction manager database, informing it that the unit of work
has been completed. The transaction manager database then writes a "COMMITTED" record to its
log file, indicating that the unit of work is complete, and replies to the client, indicating
that it has finished.


Regards,
Nabarun
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Why Newcopy is required when we have ... DIXINSH CICS 5 Thu Apr 28, 2016 9:47 am
No new posts What is RLL phase in Restart Logic? Raghu navaikulam All Other Mainframe Topics 1 Tue Aug 20, 2013 6:20 pm
No new posts Sort jonkeys failing with SA78 ABEND... ajeshsasi DFSORT/ICETOOL 6 Tue Mar 12, 2013 8:50 pm
No new posts Two phase commit dick scherrer CICS 8 Sun Mar 25, 2012 9:35 pm
No new posts What are the Possible reasons for PHA... mchanapa CICS 15 Tue Dec 06, 2011 12:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us