| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Need suggestions for DB sync by using MQ |
« View previous topic :: View next topic » |
| Author |
Message
|
| tiangl |
 Posted: Mon Apr 18, 2005 6:45 am Post subject: Need suggestions for DB sync by using MQ |
 |
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
hi,
i want to use MQ to sync multi dbs to remote site. it require realtime sync. as we know, DB operations has a strong dependence,sometimes,the second step to update have to base on the first step of insert. if i want to use multi-threads to deal with msg, can MQ support to deliver msg in sequence? i guess not. any suggestion for this scenario? |
|
| Back to top |
|
 |
| zpat |
| Posted: Mon Apr 18, 2005 6:49 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
| Check out the new IBM provided features of DB/2. One of them is queue based replication. |
|
| Back to top |
|
|
| tiangl |
| Posted: Mon Apr 18, 2005 3:51 pm Post subject: |
|
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
| customer use Oracle Database, i can't convince them to change to DB2. any idea? |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Apr 18, 2005 7:38 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Can the first step of insert and the second step of update have something in common that can be used as a part of message retrival field?
_________________
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 |
|
|
| zpat |
| Posted: Mon Apr 18, 2005 11:17 pm Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
If you want to process updates in parallel without losing sequencing on the same record, then split the messages by the first letter of a key index field.
Eg All the "A"s will be processed in one thread etc - that way sequence is maintained for the same data, but it can be parallelised.
Use MQSI (or a simple application) to split the traffic from one queue to one queue per letter (or as many as you want). |
|
| Back to top |
|
|
| tiangl |
| Posted: Tue Apr 19, 2005 9:21 am Post subject: |
|
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
|
| 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
|
|
|
|
