我在测试往一个 5 路 p2p q 复制的添加字段 LOCATION 和 TEST 的时候,遇到一个问题。发现虽然所有的源表的结构都在 5 个点上更新了,但是我发现这个新增加的字段不是在每个点都能被复制,检查 IBMQREP_SRC_COLS 和IBMQREP_TRG_COLS 表该字段对应的行数以后,发现都不完整,有个点上是 1 行,有个点上是 2 行,有个点上是 3 行 ,就是都不是完整的 4 行 ,如下所示是我在 P1 上的情况
db2 'select count(*), subname from ASN.IBMQREP_SRC_COLS group by subname'
1 SUBNAME
----------- ----------------------------------------
4 EMP0001
6 EMP0002
5 EMP0003
6 EMP0004
db2 "select count(*),TARGET_COLNAME from ASN.IBMQREP_TRG_COLSgroup by TARGET_COLNAME"
1 TARGET_COLNAME
----------- -----------------
4 IBMQREPVERNODE
4 IBMQREPVERTIME
4 ID
3 LOCATION
4 SSN
3 TEST
我插入信号的语句如下
db2 "insert into asn.IBMQREP_SIGNAL(SIGNAL_TIME,SIGNAL_TYPE,SIGNAL_SUBTYPE,SIGNAL_INPUT_IN,SIGNAL_STATE) values (CURRENT TIMESTAMP,'CMD','ADDCOL','EMP0001;LOCATION','P' )"
插入以后, QCapture 新生成的相关日志如下
2010-12-09-08.35.35.175534ASN7010I"Q Capture" : "ASN" : "WorkerThread" : The program successfully act
ivated publication or Q subscription "EMP0004" (send queue "DB2.SEND15.QUEUE", publishing or replication queue map "PEERMJ1TOPEERMJ5
") for source table "EIJAMSDB.EMP".
2010-12-15-08.31.44.509412ASN7019I"Q Capture" : "ASN" : "WorkerThread" : "ADDCOL" signal was received and
will be processed.
2010-12-15-08.31.44.564047ASN7100I"Q Capture" : "ASN" : "WorkerThread" : Column "LOCATION" has been added
to the publication or Q subscription.
2010-12-15-08.31.44.570101ASN7100I"Q Capture" : "ASN" : "WorkerThread" : Column "LOCATION" has been added
to the publication or Q subscription.
2010-12-15-08.31.44.593134ASN7100I"Q Capture" : "ASN" : "WorkerThread" : Column "LOCATION" has been added
to the publication or Q subscription.
2010-12-15-08.31.44.886143ASN0553W"Q Capture" : "ASN" : "WorkerThread" : An internal error"4" occurred
for message number "7099" containing "1" substitution fields: "EMP0004".
2010-12-15-08.31.44.899675ASN0589I"Q Capture" : "ASN" : "WorkerThread" The program received an unexpected
return code "6037" from routine "queueSub::handleADDCOL".
2010-12-15-08.31.44.899717ASN0589I"Q Capture" : "ASN" : "WorkerThread" The program received an unexpected
return code "6037" from routine "subMgr::handleADDCOL".
另外,原来这个 ADDCOL 的测试在 3 路的 P2P 是成功的,参考资料是
http://publib.boulder.ibm.com/in ... yrqsubtchgadc2.html
[ 本帖最后由 macrozeng 于 2010-12-17 17:27 编辑 ]
|