How to commit updated records in IMS as well as in DB2?Both in CICS and Batch. Is there any single command will do these?

krishnaraj25
Profile Answers by krishnaraj25 Questions by krishnaraj25
Mar 20th, 2006
1
3341

Questions by krishnaraj25 answers by krishnaraj25

Showing Answers 1 - 1 of 1 Answers

Culver_lake
Profile Answers by Culver_lake

Mar 23rd, 2006

what you are talking about is a 2-phase commit. In cics you issue a CICS SYNCPOINT command with the commit option. This commits the transaction as a whole. Commits are propagated to DB2 and IMS and any other resource manager (like WebSphere MQ) that is participating and supports the 2-phase commit protocols.
In a CICS transaction, if you try to do an SQL commit you wil get a -925 which is an environment error. 2PC requires that there be a coordinator (CICS) and participants (DB2, IMS, etc.). Only the coordinator can "coordinate" the commit process.