| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Should we used MQ Publish and Subscribe Appl for DB2 update |
« View previous topic :: View next topic » |
| Author |
Message
|
| PAMQUSER |
 Posted: Thu Feb 26, 2004 6:07 am Post subject: Should we used MQ Publish and Subscribe Appl for DB2 update |
 |
|
Newbie
Joined: 26 Feb 2004
Posts: 3
|
Our Company have a large application stored on a DB2 database. Periodically, we do incremental updates to the database. There are many other applications that read this database, such as the Company's legacy system called C.I.S.
Can MQ Series Publish and Subscribe feature be used to capture all of the most recent DB2 table updates nightly or for incremental updates, and then publish those updates so that the subscribers (other applications) who need those updates can access them and apply them to their application system.
To rephrase the question: Can MQ Series Publish and Subscribe feature be used to capture and publish the updates of a large DB2 database (nightly or periodically) and then make those changes available or accessible to multiple subscribers within the company? Is this possible or should we look at another tool of MQ Series?
Thanks
PAMQUSER |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Feb 26, 2004 6:11 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Pub/Sub is designed for one to many message distribution.
So, yes, if your application that does the update then turns around and publishes the update information, any application that is interested in the updates can subscribe and receive them.
But there's nothing built into any of the Pub/Sub products that will automatically notice that your table has been updated and publish the information. You'll have to either buy an adapter that knows how to do this, or write a program that will do this.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| EddieA |
| Posted: Thu Feb 26, 2004 6:54 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
There is a feature in DB2 that will talk to MQ which 'might' be usable to publish the messages whenever a row is added/changed/deleted, or from within a stored procedure.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| bduncan |
| Posted: Thu Feb 26, 2004 1:05 pm Post subject: |
|
|
Padawan
Joined: 11 Apr 2001
Posts: 1554
Location: Silicon Valley
|
PAMQUSER,
Please do not post your question in multiple forums.
Thanks
_________________
Brandon Duncan
IBM Certified MQSeries Specialist
MQSeries.net forum moderator |
|
| 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
|
|
|
|
