db2-DB2跑批报错，求解......

问题描述

DB2跑批报错，求解......

将两个DB2数据库（9.7版本的）邦联，从一个库中往另一个库中跑数报错，日志如下，麻烦帮忙解决一下，谢谢！
2015-08-25-10.33.48.338070+480 I115102832E594 LEVEL: Error
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, drda wrapper, report_error_message, probe:10
DATA #1 : String, 16 bytes
DRDA Server:
DATA #2 : String with size, 17 bytes
SRVRIAS169_REPORT
DATA #3 : String, 16 bytes
Function name:
DATA #4 : String with size, 7 bytes
do_prep

2015-08-25-10.33.48.338342+480 I115103427E994 LEVEL: Error
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, drda wrapper, report_error_message, probe:20
DATA #1 : String, 16 bytes
ODBC native err:
DATA #2 : String with size, 6 bytes
-30081
DATA #3 : String, 16 bytes
ODBC sqlstate:
DATA #4 : String with size, 6 bytes
40003.
DATA #5 : String, 16 bytes
ODBC error txt:
DATA #6 : String with size, 331 bytes
[IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communica
tion API being used: "SOCKETS". Location where the error was detected: "yy.yy.yyy.www". Communication function detecting the
error: "send". Protocol specific error code(s): "32", "*", "0". SQLSTATE=08001

2015-08-25-10.33.48.338578+480 I115104422E628 LEVEL: Error
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, drda wrapper, DRDA_Statement::error_report, probe:50
MESSAGE : DRDA Wrapper:
DATA #1 : Hexdump, 27 bytes
0x00002AEFEC0C709C : 4465 7465 6374 6564 2063 6F6E 6E65 6374 Detected connect
0x00002AEFEC0C70AC : 696F 6E20 6973 2064 6561 64 ion is dead

2015-08-25-10.33.48.338863+480 I115105051E595 LEVEL: Error
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, drda wrapper, report_error_message, probe:10
DATA #1 : String, 16 bytes
DRDA Server:
DATA #2 : String with size, 17 bytes
SRVRIAS169_REPORT
DATA #3 : String, 16 bytes
Function name:
DATA #4 : String with size, 8 bytes
rollback

2015-08-25-10.33.48.339062+480 I115105647E727 LEVEL: Error
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, drda wrapper, report_error_message, probe:20
DATA #1 : String, 16 bytes
ODBC native err:
DATA #2 : String with size, 6 bytes
-99999
DATA #3 : String, 16 bytes
ODBC sqlstate:
DATA #4 : String with size, 6 bytes
08003.
DATA #5 : String, 16 bytes
ODBC error txt:
DATA #6 : String with size, 64 bytes
[IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003

2015-08-25-10.33.48.339344+480 I115106375E629 LEVEL: Error
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, drda wrapper, DRDA_Connection::error_report, probe:50
MESSAGE : DRDA Wrapper:
DATA #1 : Hexdump, 27 bytes
0x00002AEFEC0C70D4 : 4465 7465 6374 6564 2063 6F6E 6E65 6374 Detected connect
0x00002AEFEC0C70E4 : 696F 6E20 6973 2064 6561 64 ion is dead

2015-08-25-10.33.48.339631+480 I115107005E541 LEVEL: Error
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, drda wrapper, FencedDRDA_Server::get_diagnostic, probe:10
MESSAGE : DiagRec han_type
DATA #1 : Hexdump, 2 bytes
0x00002AEB9FFEBB48 : 0300 ..

2015-08-25-10.33.48.339997+480 I115107547E555 LEVEL: Warning
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_rollback_with_sqlcode, probe:100
MESSAGE : NLI or DMS force ROLLBACK
DATA #1 : Hexdump, 4 bytes
0x00002AEFECCCD1BC : 0100 0200 ....

2015-08-25-10.33.48.340136+480 I115108103E882 LEVEL: Warning
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_rollback_with_sqlcode, probe:150
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30080 sqlerrml: 38
sqlerrmc: 32 * 0 TCP/IP SOCKETS yy.yy.yyy.www send
sqlerrp : SQLGNERR
sqlerrd : (1) 0x8026006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 08001

2015-08-25-10.33.48.340836+480 I115108986E456 LEVEL: Error
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, Query Gateway, FencedServer::find_connection, probe:10
MESSAGE : No existing connection found

2015-08-25-10.33.48.340974+480 I115109443E553 LEVEL: Error
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, Query Gateway, sqlqg_FMP_FedRollback, probe:130
MESSAGE : ZRC=0x80260160=-2144992928=SQLQG_ERROR "Error constant for gateway."
DATA #1 : String, 36 bytes
F1PC rollback and connection is null

2015-08-25-10.33.48.341195+480 I115109997E551 LEVEL: Error
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, Query Gateway, sqlqgFedRbk1, probe:200
MESSAGE : ZRC=0x80260160=-2144992928=SQLQG_ERROR "Error constant for gateway."
DATA #1 :
Rollback failed for server: SRVRIAS169_REPORT

2015-08-25-10.33.48.341387+480 I115110549E539 LEVEL: Error
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, data protection services, sqlpxrbk, probe:2325
RETCODE : ZRC=0x8026006D=-2144993171=SQLQG_RC_CA_BUILT
"Error constant for gateway and the sqlca filled and trustable."

2015-08-25-10.33.48.341534+480 I115111089E537 LEVEL: Severe
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrrbck_dps, probe:200
RETCODE : ZRC=0x8026006D=-2144993171=SQLQG_RC_CA_BUILT
"Error constant for gateway and the sqlca filled and trustable."

2015-08-25-10.33.48.341672+480 I115111627E832 LEVEL: Severe
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrrbck_dps, probe:250
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1476 sqlerrml: 6
sqlerrmc: -30080
sqlerrp : SQLRR0F9
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF38 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 40506

2015-08-25-10.33.48.341794+480 I115112460E533 LEVEL: Severe
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:500
RETCODE : ZRC=0x8026006D=-2144993171=SQLQG_RC_CA_BUILT
"Error constant for gateway and the sqlca filled and trustable."

2015-08-25-10.33.48.341930+480 I115112994E532 LEVEL: Severe
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:57
RETCODE : ZRC=0x8026006D=-2144993171=SQLQG_RC_CA_BUILT
"Error constant for gateway and the sqlca filled and trustable."

2015-08-25-10.33.48.342064+480 I115113527E552 LEVEL: Severe
PID : 22006 TID : 47191490029888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RIAS
APPHDL : 0-15888 APPID: xx.xx.xxx.zzz.41545.150819042741
AUTHID : RIAS
EDUID : 370 EDUNAME: db2agent (RIAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_rollback_with_sqlcode, probe:300
RETCODE : ZRC=0x8026006D=-2144993171=SQLQG_RC_CA_BUILT
"Error constant for gateway and the sqlca filled and trustable."

解决方案

http://bytes.com/topic/db2/answers/183158-error-40003-ibm-cli-driver-sql30081n-communication-error-has-been-detected-communic

时间： 2024-10-26 12:23:26

db2-DB2跑批报错，求解......的相关文章

nodejs写的聊天室chome一直在报错求解

问题描述 nodejs写的聊天室chome一直在报错求解 写了一个聊天室,但是chrome控制台一直在报错,这是我的项目目录:html部分代码 <!DOCTYPE html><html> <head> <meta charset=""utf-8"" /> <title></title> <link rel=""stylesheet"" href=&q

python 报错求解Undefined variable from import: urlopen

问题描述 python 报错求解Undefined variable from import: urlopen 解决方案 http://www.cnblogs.com/i-bugs/p/4028647.html 解决方案二: 第三方包引入时,eclipse默认会把一些包定为错误的,错误是: "undefined variable from import..." 其实是对的,可是报错,很烦人 解决方法: window -- preferences -- pydev -- editor -

cxf-jboss启动xfire报错求解

问题描述 jboss启动xfire报错求解 昨天遇到个问题我jboss4启动xfire接口程序报以下错误: java.lang.NoClassDefFoundError: javax/servlet/http/HttpServletRequest Caused by: java.lang.LinkageError: loader constraint violation: loader (instance of org/jboss/mx/loading/UnifiedClassLoader3)

springmvc报错求解求解啊。

问题描述 springmvc报错求解求解啊. 解决方案 解决方案二: 解决方案三:

java-在我的电脑上跑正常,在linux的tomcat服务器上跑项目报错 万分感谢

问题描述 在我的电脑上跑正常,在linux的tomcat服务器上跑项目报错 万分感谢 解决方案 参考servlet-api.jar not loaded 把 webappsmaintenanceWEB-INFlib 下面的 servlet-api.jar 删掉吧! tomcat自己有,不需要你提供! 顺便看看其他的jar, 和 tomcatlib 目录比较一下,tomcat已经有的,就别留着了! 你也看看你的问题截图的第六行,把相关的jar文件删除看看. 解决方案二: 检查一下数据库是不是和你开

jsp标签-jsp中a标签跳转报错,求解

问题描述 jsp中a标签跳转报错,求解 报错信息sec7115:visited and :link styles can only differ by color 解决方案 你这个js错误还是什么 https://github.com/CSSLint/csslint/pull/372 解决方案二: 把你的代码贴出来 解决方案三: 你把A标签内容贴出来啊,要我们怎么看啊 解决方案四: 你最好把代码贴出来让我们看一下 解决方案五: 超链接的访问过状态和链接状态只能被颜色标记不同--我只能翻译翻译

pyqt-ubuntu安装PyQt的IDE, eric总是报错,求解

问题描述 ubuntu安装PyQt的IDE, eric总是报错,求解 解决方案 可以了... 重新安装了下 sudo apt-get install libqscintilla2-dev

mapreduce-solaris部署hadoop集群跑wordcount报错

问题描述 solaris部署hadoop集群跑wordcount报错 solaris部署hadoop集群跑wordcount报错, 信息如下: [admin@4bf635fa-5f3e-4b47-b42d-7558a6f0bbff ~]$ hadoop jar /opt/hadoop/share/hadoop/mapreduce/hadoop-mapreduce-examples-2.7.1.jar wordcount /input /output 15/08/20 00:48:09 WARN

tomcat-搭建ssh框架和comcat服务器报错求解

问题描述 搭建ssh框架和comcat服务器报错求解 Unable to load configuration. - bean - jar:file:/D:/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp2/wtpwebapps/ssh/WEB-INF/lib/struts2-spring-plugin-2.1.8.1.jar!/struts-plugin.xml:29:132 at com.opensymphony.xw