EricMuu 2015-09-07 12:16 采纳率: 0%
浏览 3480

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."

  • 写回答

1条回答 默认 最新

报告相同问题?

悬赏问题

  • ¥15 完成下列问题完成下列问题
  • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题!
  • ¥15 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像,如何解决?
  • ¥15 求daily translation(DT)偏差订正方法的代码
  • ¥15 js调用html页面需要隐藏某个按钮
  • ¥15 ads仿真结果在圆图上是怎么读数的
  • ¥20 Cotex M3的调试和程序执行方式是什么样的?
  • ¥20 java项目连接sqlserver时报ssl相关错误