| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| From DB2 to Mq on Zos |
« View previous topic :: View next topic » |
| Author |
Message
|
| giuly020277 |
 Posted: Fri Oct 02, 2009 1:10 am Post subject: From DB2 to Mq on Zos |
 |
|
Centurion
Joined: 07 Aug 2007
Posts: 146
Location: Florence,Italy
|
Hello everyone... Ineed your help again.
Here we have to do the following project :
From DB2 i received a messages on Mq on zos (v.7) that let start a transaction CICS who updates some VSAM.
The question is (it's the first time we used DB2 to send messages) :
How to send messages from Db2 to mq on zos? which is the command?
Where i found documentation? On db2 libraries ? On mq i don't find anything. |
|
| Back to top |
|
 |
| bruce2359 |
| Posted: Fri Oct 02, 2009 5:44 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| Quote: |
| How to send messages from Db2 to mq on zos? |
DB2 is a database management system. The usual way to get data from a DB2 table is to write an application that does a SQL call to extract data from a DB2 table, then compose an MQ message, then MQPUT it to an MQ queue. The MQ part can be done using MQ base calls (like MQPUT), Java, JMS, or other.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Oct 02, 2009 7:11 am Post subject: Re: From DB2 to Mq on Zos |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| giuly020277 wrote: |
| How to send messages from Db2 to mq on zos? which is the command? |
I don't think there's a command that does this. Way back (2000-2001) I worked with a really good DB2 guy who claimed he could use some kind of optional DB2 gateway component to fire rows from an INSERT trigger as messages but I don't think we ever tried it.
Certainly in your situation I'd use the CICS transaction to handle the WMQ interaction.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Oct 02, 2009 7:45 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
There is a DB2 messaging interface thingy that will do exactly what is needed.
Oddly enough it is documented in the DB2 Information Center, as it is a DB2 function.
I think it's still built using AMI, too, but that's irrelevant. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Oct 02, 2009 7:54 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
There is a DB2 messaging interface thingy that will do exactly what is needed.
|
Well remembered me! 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Fri Oct 02, 2009 7:56 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
|
| 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
|
|
|
|
