| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQ on ZOS - RRS Question |
« View previous topic :: View next topic » |
| Author |
Message
|
| JWJ |
 Posted: Wed May 04, 2005 8:45 am Post subject: MQ on ZOS - RRS Question |
 |
|
Novice
Joined: 13 Jun 2002
Posts: 18
Location: Farmers Insurance Group
|
Are there any advantages in using the MQ verses the RRS commit/backout commands? Is there a difference due to the stub that is used?
We are updating DB2 and MQ and want to make sure the DB2 insert is committed before the MQ record is available.
JJ
_________________
JWJ |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed May 04, 2005 10:00 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I think MQ uses RRS on the mainframe anyway.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| javagate |
| Posted: Wed May 04, 2005 11:41 am Post subject: |
|
|
Disciple
Joined: 15 Nov 2004
Posts: 159
|
DB2 is using RRS not MQ
_________________
WebSphere Application Server 7.0 z/OS &
MQ 6.0. I work with WebSphere in the real world not in some IBM lab. |
|
| Back to top |
|
|
| oz1ccg |
| Posted: Wed May 04, 2005 12:54 pm Post subject: |
|
|
Yatiri
Joined: 10 Feb 2002
Posts: 628
Location: Denmark
|
I assume we're talking about a batch program on z/OS, and not CICS.
The main reason for using RRS is to get advantage of the the two phase commit architecture.
Lets say you do the DB2COMMIT and the MQCOMMIT in your program...
What happens if the MQCOMMIT fails ?
You have data out of sync. and in worst case, you're loosing data, maybe large payments.  I know many programs doing it in this way. 
(Written before RRS support was GA).
Using RRS, this can't happen, because both MQ and DB2 are using RRS as commit coordinator, and this means that both operations are committed or backed out.   This is something management like.
| Quote: |
| DB2 is using RRS not MQ |
This might not be 100% true, because shared queues rely on this.
BTW: Is there a difference due to the stub that is used? YES.
Have a look in the manual. If I should use MQ to do the RRS using the special stub, I would commit MQ first, and the DB2, because the DB2 COMMIT would be empty.
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 |
|
|
| JWJ |
| Posted: Wed May 04, 2005 2:11 pm Post subject: |
|
|
Novice
Joined: 13 Jun 2002
Posts: 18
Location: Farmers Insurance Group
|
Thanks for the useful response...... Sorry, I should have been specific about where we were running--- Yes its a batch job, and the Queue is a Shared Queue.
Sounds like what you are saying is that to get the highest level of process integrity you should use the CSQBRSTB stub and use the RRS commands. Doing that, you would use only the RRS commands not DB2 and MQ commit or backout commands. This would cause both resource managers to do corrdinated unit of work, similar to doing this under CICS.
Does that sound rigth? Anyway, thanks again!!!
Jerry
_________________
JWJ |
|
| Back to top |
|
|
| oz1ccg |
| Posted: Thu May 05, 2005 2:50 am Post subject: |
|
|
Yatiri
Joined: 10 Feb 2002
Posts: 628
Location: Denmark
|
|
| 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
|
|
|
|
