配置SQL复制出现错误,求指导

现有一节点上的含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
参与2

1同行回答

macrozengmacrozeng数据库管理员IBM
检查这个外键 , ADMINISTRATOR.SP_ITEMCAGE.F_ORGANCAGE  ,父表里面有记录造成了子表无法删除,  可以尝试在目标数据库上设置一下db2 "alter table  ADMINISTRATOR.SP_ITEMCAGE alter foreign key F_ORGANCAGE not  enforced" 同...显示全部
检查这个外键 , ADMINISTRATOR.SP_ITEMCAGE.F_ORGANCAGE  ,父表里面有记录造成了子表无法删除,  可以尝试在目标数据库上设置一下
db2 "alter table  ADMINISTRATOR.SP_ITEMCAGE alter foreign key F_ORGANCAGE not  enforced"
同时检查源数据库端是否有类似约束收起
政府机关 · 2013-05-23
浏览1428

提问者

liliy
其它北京
擅长领域: 数据库分布式系统大数据

问题状态

  • 发布时间:2013-05-23
  • 关注会员:1 人
  • 问题浏览:3127
  • 最近回答:2013-05-23
  • X社区推广