I wrote a program which is triggered from ESB(MQ) and has IMS/DB,DB2 and MQ.
I need to commit the after processing each record.
Note:1. chkp call is not working it shows MQ queue error.
2. If I processed single record and then try to make GU call to ims region to commit and process next record is gives MQ queue error at the time to extracting record from MQ queue
Is there any other way to commit the record in this type of program.
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
would look at RRSAF. Resource Recovery Services. Used to control more than 2 resources (DB2, MQS, IMS ...etc...)
RRS supports two phase commit; a lot easier to use than coding the process yourself.
to do it without RRS,
you need to make separate COMMITs one for MQS and one for IMS and one for DB2
- can get a little complicated - especially if a commit on db2 fails and you have already commited your MQS.
RRSAF will control this problem.
You only need to execute COMMIT in one place
and RRSAF will take care of the UOW for all resources at the same time.