View previous topic :: View next topic
|
Author |
Message |
naveeneckumar
New User
Joined: 11 Jan 2008 Posts: 5 Location: india
|
|
|
|
hi,
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. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
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.
Search the ibm Redbook site for RRSAF. |
|
Back to top |
|
|
naveeneckumar
New User
Joined: 11 Jan 2008 Posts: 5 Location: india
|
|
|
|
how to implemet RRS in cobol code
will you please describe this little bit.
Thanks,
Naveen |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
RRS is not implemented in some single program. . . It is a direction that is implemented over a much broader scope.
It is also not (typically) implemented by one person. . .
Suggest considerably more study/investigation is needed before implementation is considered. |
|
Back to top |
|
|
naveeneckumar
New User
Joined: 11 Jan 2008 Posts: 5 Location: india
|
|
|
|
Thanks |
|
Back to top |
|
|
|