| Author |
Message
|
| gobi_nathan |
 Posted: Tue Feb 04, 2003 1:19 am Post subject: MQSI -database monitor |
 |
|
Acolyte
Joined: 08 Jan 2003
Posts: 69
|
Hi ,
I want to get the database updates into MQ queue.Is there any way to do it?
Is there any settings in MQSI by which i can,monitor the database events (insert,update) and convert into the Message.
Is there any way to do it this?
-Gobi |
|
| Back to top |
|
 |
| yaakovd |
| Posted: Tue Feb 04, 2003 10:10 am Post subject: |
|
|
Partisan
Joined: 20 Jan 2003
Posts: 319
Location: Israel
|
I think it impossible directly from MQSI.You need some external task.
May be Crossworlds can help here. Somebody have idea?
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel |
|
| Back to top |
|
|
| philip.baker |
| Posted: Tue Feb 04, 2003 10:19 am Post subject: |
|
|
Voyager
Joined: 21 Mar 2002
Posts: 77
Location: Baker Systems Consulting, Inc. - Tampa
|
Gobi,
In past posts there is evidence that indicates the CrossWorlds product has been used at your work location. If you have the use of one of the database Adapters from CrossWorlds, you can place a trigger (simply a regular database trigger) on the tables to be monitored, and have the triggered process place an event in the CrossWorlds Adapter event table. The Adapter would pull the updated/inserted record(s) from the DB table, create a message and place it on a queue. MQSI could read the queue, and based on message header or message body content, could route the data to another queue that could represent the table from which the data came.
MQSI/WMQI likes to get its work in the form of messages from queues, (Unless you are using SCADA devices.) however, one hokey way of making MQSI do this is to have an MQSI flow, which is run by a repeating scheduled job via the Windows scheduler or UNIX cron(depending on where your broker is) that places a message on the flow input queue every second or two. The flow would query a certain database table and evaluate the TimeStamp fields on each record that stores the insert or update time of the record. If the TimeStamp is recent (within a certain time calculation window), the record could be selected from the database and written to a queue. (This would seem a bit of a science project only.)
_________________
Regards,
Phil |
|
| Back to top |
|
|
| wmqiguy |
| Posted: Wed Feb 05, 2003 9:23 am Post subject: |
|
|
Centurion
Joined: 09 Oct 2002
Posts: 145
Location: Florida
|
"This would seem a bit of a science project only." - Phil
LOL!!! I love that phrase. Do you mind if I borrow it liberally? I think half the thigs I do are "science projects."
Todd |
|
| Back to top |
|
|
| gobi_nathan |
| Posted: Mon Feb 10, 2003 7:00 am Post subject: Performance issue with adapter |
|
|
Acolyte
Joined: 08 Jan 2003
Posts: 69
|
Hi philip,
What you says is correct.
We have tried the webshpere adapters for jdbc too.we find some performance degradations in using Adapter.
Suppose,if we wants to replicate the 500 updated rows.By using the adapter,we are suppose to pass 500 messages across the MQ.(each row we have a single message).Thats why we are trying some other way.
-Gobi |
|
| Back to top |
|
|
| philip.baker |
| Posted: Mon Feb 10, 2003 8:32 am Post subject: |
|
|
Voyager
Joined: 21 Mar 2002
Posts: 77
Location: Baker Systems Consulting, Inc. - Tampa
|
Gobi,
There may be a way to get MQSI involved in a solution to replicate database updates, however unless a 'batch' window for processing is desired and performance is not an issue, it may not be the best idea. I would imagine the Database vendor you are using has some other solution. What is the database and version you are trying to replicate. Also, what are the performance specs you are looking for. (May have to move this discussion to another forum unless middleware is to be used. ha)
_________________
Regards,
Phil |
|
| Back to top |
|
|
| gobi_nathan |
| Posted: Mon Feb 10, 2003 7:29 pm Post subject: |
|
|
Acolyte
Joined: 08 Jan 2003
Posts: 69
|
philip ,
We are using Oracle 8i.Operating system may be windows or solaris. only performance we are looking for is,application should not take much time to replicate the data passsing through MQSI.
We are definitely using the middelware,Since we have some tranformations logics in between.
Our scenario is something like,whenever database update happens i want to send the notification messages to all the subscribers with transformation.
-Gobi. |
|
| Back to top |
|
|
| kirani |
| Posted: Sat Feb 15, 2003 11:50 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
I think you configure your database to put a message on the queue (using Trigger) when a DB update takes place. I know this is possible with DB2, but I am not sure about the Oracle DB.
Later this message can be transformed by WMQI and published for subscribers.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
