| Author |
Message
|
| shalabh1976 |
 Posted: Tue Feb 15, 2005 2:27 am Post subject: How to write MQ Adaptor/ Connector |
 |
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
Hi,
I have been given the task of writing a MQ Adapter/ Connector that can pick up inserts/updates/deletes done against a DB2 table and write a sutable XML message in a queue with the relevant data eg operation performed along with the rows modified. Can anyone guide me as to how to go about doing this ?
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
 |
| RAJESHRAMAKRISHNAN |
| Posted: Tue Feb 15, 2005 2:49 am Post subject: |
|
|
Voyager
Joined: 01 May 2004
Posts: 96
|
Can you mention the platform(s) that you are working on? MQ could be on one platform and DB2 might be on some other.
Also there is a feature in IBM MQSeries that enables data to be sent directly from DB2 on to an MQ Queue. You might be interested to have a look in to it as well. |
|
| Back to top |
|
|
| shalabh1976 |
| Posted: Mon Feb 21, 2005 12:26 am Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
The platform is Win 2K but my basic query is the resources needed to write a MQ adapter - I need information on how and where to get the software for the same.
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Mon Feb 21, 2005 12:31 am Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
what do you think is special about an MQ adapter?
it's just another program that talks X at one end and MQI on the other end...
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Feb 21, 2005 4:42 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Unless you're talking about somethiing that implements the ICS/WSF "adapter/connector" framework.
Then you should go look at the WBI Info Center
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mqdev |
| Posted: Wed Feb 23, 2005 7:58 am Post subject: |
|
|
Centurion
Joined: 21 Jan 2003
Posts: 136
|
| RAJESHRAMAKRISHNAN wrote: |
| Also there is a feature in IBM MQSeries that enables data to be sent directly from DB2 on to an MQ Queue. You might be interested to have a look in to it as well. |
Rajesh,
Can you post a link where one can get more info on this? If no link, can you post more info on this?
thx
-mqdev |
|
| Back to top |
|
|
| RAJESHRAMAKRISHNAN |
| Posted: Thu Feb 24, 2005 12:47 am Post subject: |
|
|
Voyager
Joined: 01 May 2004
Posts: 96
|
|
| Back to top |
|
|
| kman |
| Posted: Thu Feb 24, 2005 1:10 am Post subject: |
|
|
Partisan
Joined: 21 Jan 2003
Posts: 309
Location: Kuala Lumpur, Malaysia
|
I haven't been to the link Raja gave, but if you are thinking about using the mq calls from db2 app, I think that refers to DB2 7.2 and that also uses AMI (Application Messaging Interface). Now we know what happen to AMI.
On the other hand, the MQ Adapter mention in this topic is nothing more than just a normal MQ app that has DB2 access, possibly two phase commit.
It is something similar to
| Code: |
insert table XYZ with data ABC
prepare XML insert row as above
write XML statement to queue.
|
What's wrong with that? (the above is simple algo - don't get me wrong)
I've done something similar on my previous project. And the 'Con-sultant' gave a similar special term for that normal thing.  |
|
| Back to top |
|
|
| RAJESHRAMAKRISHNAN |
| Posted: Thu Feb 24, 2005 2:44 am Post subject: |
|
|
Voyager
Joined: 01 May 2004
Posts: 96
|
| Quote: |
I have been given the task of writing a MQ Adapter/ Connector that can pick up inserts/updates/deletes done against a DB2 table
|
Can you write a program (In C/C++ or Java) which can be triggered when an insert/update/delete happens? Without this is it possible to write an adaptor/connector that can detect inserts/updates/deletions?
BTW Regarding AMI, I don't have much idea. Has it gone out of favour? |
|
| Back to top |
|
|
| kman |
| Posted: Thu Feb 24, 2005 3:16 am Post subject: |
|
|
Partisan
Joined: 21 Jan 2003
Posts: 309
Location: Kuala Lumpur, Malaysia
|
| Last I hear.. no more updates on AMI |
|
| Back to top |
|
|
| kman |
| Posted: Thu Feb 24, 2005 3:23 am Post subject: |
|
|
Partisan
Joined: 21 Jan 2003
Posts: 309
Location: Kuala Lumpur, Malaysia
|
| Quote: |
Can you write a program (In C/C++ or Java) which can be triggered when an insert/update/delete happens? Without this is it possible to write an adaptor/connector that can detect inserts/updates/deletions?
|
Something going to write to the DB.. so that something can trigger the mq works. Unless ... you ask DB2 to start triggering other application... hmmm??
Unless you want even if DB2 operation were done through some management console.. this even trigger the mq app.
By the way.. AMI admin tool has been withdrawn. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Feb 24, 2005 6:29 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I am pretty sure that DB2 has added the capacity to write Java stored procedures..
yep.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
