Problem solve Get help with specific problems with your technologies, process and projects.

Will the DB2 updates be committed as part of the two-phase commit?

If a CICS application calls a DB2 Stored procedure (that has done DB2 updates) and then issues a syncpoint, will the DB2 updates be committed as part of the two-phase commit? Assume that the Stored Procedure was not setup with the commit on return option and there were no commits coded in the stored procedure.
A stored procedure such as you describe will become part of the unit of work that it was called from. As such, when that unit of work is committed (such as by issuing a CICS syncpoint), the stored procedure work will be committed, too.
This was last published in May 2003

Dig Deeper on IBM DB2 management

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.