MVSFORUMS.com

karavi2000 · Posted: Thu Jul 16, 2009 10:57 am Post subject: CICS Commit and Syncpoint

Ok.. I have this following scenario..

Our MQ message triggers a CICS transaction and it does the following.

1. Updates the message into a table
2. Reformats the message into 2 records
3. Updates one record at a time into the database

In Step 3, we would want to commit the database after the first record is written. DB2 Commit will not work since this is part of a CICS transaction. Is there a way, we can issue a commit to the database without issuing CICS SYNCPOINT? (Google search revealed about SRRCMIT but not sure if it is a right thing to do as don't have a trace of this program in our existing Production environment). Please let me know if you get a chance. Thanks much for your time.

kolusu · Posted: Thu Jul 16, 2009 11:03 am Post subject:

karavi2000,

Read Upon Two-phase commit process here

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.admin/db2z_twophasecommit.htm

Kolusu