IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

2 phsae commit


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rambabu
Currently Banned

New User


Joined: 18 Apr 2005
Posts: 67

PostPosted: Tue Apr 19, 2005 5:33 pm
Reply with quote

can any body tell me what is 2phase commit in db2? i want to know the details about that.....
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


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

PostPosted: Wed Apr 20, 2005 12:17 pm
Reply with quote

Hi Rambabu,

This occurs when a programmer Issues an Exec CICS Syncpoint command.
This is called two phase because CICS will first commit changes to the resources under its control like VSAM files. and then DB2 changes are
committed.
Usually CICS signals DB2 to complete the next phase and releases all the locks.

Regards,

Priyesh
Back to top
View user's profile Send private message
shymalasridevi

New User


Joined: 03 May 2005
Posts: 16

PostPosted: Tue May 03, 2005 3:19 pm
Reply with quote

cics first commits all the resources and then give control to db2 to commit the resources at after issuing the syncpoint
this is 2 phase commit
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts filter COMMIT/ROLLBACK statements DFSORT/ICETOOL 13
No new posts Commit limit for Delete query through... DB2 10
No new posts Commit a DB2 Table on Unix Server and... DB2 3
No new posts Need information on DB2 COMMIT DB2 9
No new posts DB2 Commit thru Xpediter DB2 4
Search our Forums:

Back to Top