省中心和地市数据同步方案求解,内详(各行业应该都碰得到的)

stonenba

省中心和地市数据同步方案求解,内详(各行业应该都碰得到的)
我们正做一个全省的业务系统,初步设计方案是数据存放于省中心,和各地市(20多个也存放一台服务器）,
问题是：一些表的数据是全省统一的，要求一地市数据（统一的部分数据）发生变化时省和其它地市也能与之同步。采用db2数据库。程序部署在was上。


有劳各位大虾、斑竹、前辈们给出解决方案。谢了。
（初步设想方案采用mq 解决，有没有更好的方案呢？？？？？？？？？）

bpmfhu

mq可以满足要求。而且mq是基于tcp/ip协议，不会丢消息的。另外，要求其他地市要保持同步。我觉得可以先上传，然后在从中心下发消息，应该可以

stonenba

谢谢楼上的，欢迎各位高手继续讨论，多给点建议供参考。

wangzhonnew

not too sure what is MQ, maybe it is out scope of DB2 itself...
from pure db2 implementation, i beleive XA will works for your situation, the XA transaction can be used to update the data in different databases.

stonenba

XA? what is it?please tell me about it more and more?can it really sovle my problem? 3qu!!!!!!!!

wangzhonnew

here XA (two-phase commit) is something like "indoubt transactions" (An indoubt transaction is a global transaction that was left in an indoubt state), usually it can be used to update the data between different databases. (for example, i need to update the data in database A and B, i will connect to database A, start transaction, update the table TA, connect to database B, update the table TB, commit transaction or rollback, then i will get table TA and TB both committed or rollback)

the image overview of two-phase commit is following:
http://publib.boulder.ibm.com/in ... /admin/t0005061.htm
http://publib.boulder.ibm.com/in ... /admin/t0005064.htm
http://publib.boulder.ibm.com/in ... f%6d%6d%69%74%22%20

For detailed implementation please read the following links:
http://publib.boulder.ibm.com/in ... c/conn/c0004786.htm
http://publib.boulder.ibm.com/in ... c/conn/c0006180.htm
http://publib.boulder.ibm.com/in ... f%6d%6d%69%74%22%20
http://publib.boulder.ibm.com/in ... c/conn/t0004765.htm
http://publib.boulder.ibm.com/in ... /admin/c0005034.htm

Or in the InfoCenter search for "two-phase commit" or "Multisite Update"

wangzhonnew

also fedarated system is another choice, but creating more than 20 or more wrappers and nicknames will make the database harder to manage....

but please notice that DUOW only work for the following system:
DB2 UDB for UNIX(R) and Windows(R) Version 7 or later
DB2 UDB for OS/390 Version 6.1 DB2 UDB for OS/390 and z/OS(TM) Version
DB2 for z/OS Version 8 or later
DB2 UDB for iSeries(TM) requires OS/400 Version 5 Release 1 or later

fedarated system can fedarate different types of databases like Oracle or SQL servers

stonenba

creating more than 20 or more wrappers and nicknames will make the database harder to manage

so it is not a good way.
But thank you all the same!!!!!

wangzhonnew

寒，不清楚你是否真的看懂了，有两种方法可以实现
1）XA
2）联邦系统
XA的好处就是相对简单方便，联邦系统的好处就是可以兼容其他类型数据库
“creating more than 20 or more wrappers and nicknames will make the database harder to manage”指的是联邦系统

whiterain

呵呵，xa是一个不错的选择，呵呵，而且java也支持xa 的TRANSACTIONs