现在遇到新问题了.在多表复制的时候,当复制到第十二表的时候,出现如下错误: INSERT INTO ASN.IBMSNAP_PRUNCNTL ( APPLY_QUAL, SET_NAME, CNTL_SERVER, CNTL_ALIAS, SOURCE_OWNER, SOURCE_TABLE, SOURCE_VIEW_QUAL, TARGET_OWNER, TARGET_TABLE, TARGET_SERVER, TARGET_S...
显示全部现在遇到新问题了.
在多表复制的时候,当复制到第十二表的时候,出现如下错误:
INSERT INTO ASN.IBMSNAP_PRUNCNTL ( APPLY_QUAL, SET_NAME, CNTL_SERVER, CNTL_ALIAS, SOURCE_OWNER, SOURCE_TABLE, SOURCE_VIEW_QUAL, TARGET_OWNER, TARGET_TABLE, TARGET_SERVER, TARGET_STRUCTURE, MAP_ID, PHYS_CHANGE_OWNER, PHYS_CHANGE_TABLE ) SELECT 'DDD', 'DDD', 'PMINE1', 'PMINE1', 'CSCHEMA', 'EXP_TIME_REAL', 0, 'PSCHEMA', 'EXP_TIME_REAL', 'PMINE1', 8, coalesce ( char(INT(MAX(MAP_ID))+1), '0' ), 'CSCHEMA', 'CDEXP_TIME_REAL' FROM ASN.IBMSNAP_PRUNCNTL
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0803N One or more values in the INSERT statement, UPDATE statement, or
foreign key update caused by a DELETE statement are not valid because the
primary key, unique constraint or unique index identified by "2" constrains
table "ASN.IBMSNAP_PRUNCNTL" from having duplicate values for the index key.
SQLSTATE=23505
不管是一个预定义集对应一个表,还是对应多个表,当创建第十二张表的时候,就出现上面的错误.
收起