- 论坛徽章:
- 0
|
请教：配置DB2复制（replication）时出错的原因
现有一节点上的含100个表左右的数据库需要与另外一个节点上的数据库保持数据同步，在配置sql replication时出现了如下错误:
1.SQLSTATE=23001 The update or delete of a parent key is prevented by aRESTRICT update or delete rule
(RESTRICT 更新或删除规则防止父键被更新或删除)
2.错误日志显示:
*** SQL ERROR ***: SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELE
TE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "ZZ.IBMSN
AP_SIGNAL" from having duplicate values for the index key. SQLSTATE=23505
3.*** SQL ERROR ***: SQL0532N A parent row cannot be deleted because the relationship "ADMINISTRATOR.SP_ITEMCAGE.F_ORGANCAGE" rest
ricts the deletion. SQLSTATE=23001
DTGT: Prepare delete stmt is DELETE FROM "ADMINISTRATOR"."ORGAN".
DTGT: Delete failed. errcode is 730101. sqlstate is 23001. sqlcode is -532
SAT: ASNLOAD = N, EFFECT_MEMBERS = 3
SAT: FULL_REFRESH = Y
SAT: SET_INSERTED = 83
SAT: SET_DELETED = 0
SAT: SET_UPDATED = 0
SAT: SET_REWORKED = 0
SAT: SET_REJECTED_TRXS = 0
SAT: STATUS = -1
SAT: LASTRUN = 2008-10-14-19.55.00.593000
SAT: LASTSUCCESS is null
SAT: SYNCHPOINT is null
SAT: SYNCHTIME is null
SAT: SOURCE_ALIAS is ISOURCE
SAT: SOURCE_SERVER is ILSDB
SAT: SOURCE_OWNER is ADMINISTRATOR
SAT: SOURCE_TABLE is TECHAPLNAME
SAT: TARGET_ALIAS is GSIDB
SAT: TARGET_SERVER is GSIDB
SAT: TARGET_OWNER is ADMINISTRATOR
SAT: TARGET_TABLE is TECHAPLNAME
SAT: SQLSTATE is null
SAT: SQLERRM is null
SAT: SQLCODE is null
SAT: SQLERRP is null
SAT: APPERRM is null
************************************************************************
自己认为问题是出在表中的外键约束上，或者是表之间的联系太多
请求DB2高手答疑
谢谢！ |
|
免费注册
发表于 2008-10-16 11:19
