| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQ and DB2 on z/OS |
« View previous topic :: View next topic » |
| Author |
Message
|
| GMcCarthy |
 Posted: Wed Sep 17, 2003 6:35 am Post subject: MQ and DB2 on z/OS |
 |
|
Centurion
Joined: 06 Nov 2001
Posts: 113
Location: Melville NY
|
We're running WMQ 5.3 and DB2 7.1. Our DB2 systems guy is asking about how to put (MQSEND) to a queue. This queue would be triggered to start 'something' in db2 that will do an 'get' (MQRECEIVE) to update a table.
I can't find any info on what to 'trigger' and how to 'marry' the MQ and DB2 subsystems.
As you can see, I'm a bit unfamiliar with DB2....I'm thinking CICS here and I know it's different.
These are basic questions...can someone help and point me in the right direction.
_________________
Regards,
Gina
IBM Certified MQSeries Specialist |
|
| Back to top |
|
 |
| GMcCarthy |
| Posted: Wed Sep 17, 2003 6:52 am Post subject: |
|
|
Centurion
Joined: 06 Nov 2001
Posts: 113
Location: Melville NY
|
Do I need AMI for this??
_________________
Regards,
Gina
IBM Certified MQSeries Specialist |
|
| Back to top |
|
|
| mrlinux |
| Posted: Wed Sep 17, 2003 7:07 am Post subject: |
|
|
Grand Master
Joined: 14 Feb 2002
Posts: 1261
Location: Detroit,MI USA
|
No you dont need AMI,
You need to look at triggering the application.
You will need a trigger monitor, this is a batch version (Not IMS/CICS)
http://www-3.ibm.com/software/integration/support/supportpacs/individual/ma12.html
You will need to modify the Queue Definition and create a process definition
_________________
Jeff
IBM Certified Developer MQSeries
IBM Certified Specialist MQSeries
IBM Certified Solutions Expert MQSeries |
|
| Back to top |
|
|
| EddieA |
| Posted: Wed Sep 17, 2003 8:45 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
If you want to use the MQ functions in DB2, and it seems you do because you used the right terms: MQSEND and MQRECEIVE, then yes, you do need the AMI. But, it is already part of the z/OS version of MQ. You don't need the Support Pac.
Last time I looked, there still wasn't a 'listener' service for the DB2/MQ functions, so in order to receive messages you would have to kick off a Stored Procedure by some 'external' means that could be Triggered, by MQ, when a message arrives.
Most of the doc for this 'interface' seems to be in the DB2 readme. There's also a couple of good articles on the IBM website. Start with:
http://www7b.software.ibm.com/dmdd/library/techarticle/wolfson/0108wolfson.html
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| GMcCarthy |
| Posted: Wed Sep 17, 2003 10:09 am Post subject: |
|
|
Centurion
Joined: 06 Nov 2001
Posts: 113
Location: Melville NY
|
If we do write this application today using the AMI, when support for it is dropped, what then? There is a product called DB2 Information Integrator V8.1, do you know if this is a replacement for the MQ Functions and the AMI??
Thanks!
_________________
Regards,
Gina
IBM Certified MQSeries Specialist |
|
| 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
|
|
|
|
