| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Commit call |
« View previous topic :: View next topic » |
| Author |
Message
|
| vinodh_niit |
 Posted: Tue May 28, 2002 7:45 pm Post subject: Commit call |
 |
|
Apprentice
Joined: 22 May 2002
Posts: 36
Location: chennai
|
hi allI
f I have a batch COBOL program that writes to both MQSeries queues and DB2 tables, then should I give 2 seperate commits (MQseries commit and DB2 commit) for both these resources to get committed? If this is not the correct strategy what needs to be done?
can any one help me on this query..
rgds
vinodh
_________________
vinodh
ssg-mq ream |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue May 28, 2002 8:19 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Vinodh,
You might want to use 2-phase commit where MQSeries will act as Transaction coordinator and DB2 database manager becomes resource manager that participates in global transaction.
For more information please read Chapter 12 in MQSeries System Administration manual.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| oz1ccg |
| Posted: Wed May 29, 2002 1:29 am Post subject: |
|
|
Yatiri
Joined: 10 Feb 2002
Posts: 628
Location: Denmark
|
Hi folks,
I guess that you're dealing with Z/OS and therefore you could use RRS, to help you on this topic.
The easiest way was just linking CSQBRRSI instead of CSQBSTUB.
This gives you the ability to make MQCMIT also doing DB2-COMMIT.
Ofcause the cleanest way was to invoke SRRCMIT/SRRBACK, this would require that you link CSQBRSTB...
But it's all in los manualos 
just my $0.02
_________________
Regards, Jørgen
Home of BlockIP2, the last free MQ Security exit ver. 3.00
Cert. on WMQ, WBIMB, SWIFT. |
|
| Back to top |
|
|
| vinodh_niit |
| Posted: Wed May 29, 2002 2:05 am Post subject: Commit call |
|
|
Apprentice
Joined: 22 May 2002
Posts: 36
Location: chennai
|
thanx a lot
_________________
vinodh
ssg-mq ream |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
