2006-11-15 10:25
edward1123
db2 对 informix 抄写问题
[size=3][font=SimSun]原先[/font][font=SimSun][font=Times New Roman]db2 8 [/font][/font][font=SimSun]对[/font][font=SimSun][font=Times New Roman] informix 7 [/font][/font][font=SimSun]抄写都一切正常[/font][/size]
[size=3][font=SimSun]但改成对[/font][font=SimSun][font=Times New Roman]informix 9 [/font][/font][font=SimSun]抄写就出现以下问题不知如何解决[/font][/size]
[size=3][font=Times New Roman][font=SimSun]2006-10-27-09.02.17.312263 <CPCCDUL(9C/07)> ASN1001E APPLY "AMPM1" : "WorkerThread". The Apply program encountered an SQL error. The ERRCODE is "9C0107". The SQLSTATE is "560BD". The SQLCODE is "-1822". The SQLERRM is "-201 (offset 152)[/font][font=SimSun]AMPMDATASOC[/font][font=SimSun]A syntax error has occurred.". The SQLERRP is "SQLQGIFX". The server name is "". The table name is "DB2INST1.CCDAP02".[/font] [/font][/size]
[size=3][font=Times New Roman][font=SimSun]2006-10-27-09.02.17.330596 <CPREST(01/00)> ASN1044I APPLY "AMPM1" : "WorkerThread". The Apply program will become inactive for "5" minutes and "0" seconds.[/font][/font][/size]
[size=3][font=Times New Roman][font=SimSun]2006-10-27-09.07.17.458546 <CPCCDUL(9C/07)> ASN1001E APPLY "AMPM1" : "WorkerThread". The Apply program encountered an SQL error. The ERRCODE is "9C0107". The SQLSTATE is "560BD". The SQLCODE is "-1822". The SQLERRM is "-201 (offset 152)[/font][font=SimSun]AMPMDATASOC[/font][font=SimSun]A syntax error has occurred.". The SQLERRP is "SQLQGIFX". The server name is "". The table name is "DB2INST1.CCDAP02".[/font] [/font][/size]
[font=SimSun][font=Times New Roman][size=3]2006-10-27-09.07.17.502106 <CPREST(01/00)> ASN1044I APPLY "AMPM1" : "WorkerThread". The Apply program will become inactive for "5" minutes and "0" seconds.[/size][/font][/font]
2006-11-15 14:36
beginner-bj
错误提示说,联邦数据库配置得不对。
2006-11-15 17:42
edward1123
首先先不说设定配置上的问题
事实上当第一次Replication时能正常Replication,并且作业正常
但当informix table 资料有异动时,Replication 就会有以上的错误讯息
2006-11-15 20:11
beginner-bj
话不能这么说吧?提示总是有道理的。
还有就是,提示说的是联邦有问题,不是复制(就是你说的抄写)有问题。
页:
[1]
Powered by Discuz! Archiver 5.5.0
© 2001-2006 Comsenz Inc.