数据库诊断日志中ERROR和WARNING信息

诊断日志中发现如下大量信息，麻烦帮忙分析：2014-06-12-14.21.45.816923+480 I8074836A538 LEVEL: ErrorPID : 319680 TID : 20664 ...显示全部

诊断日志中发现如下大量信息，麻烦帮忙分析：
2014-06-12-14.21.45.816923+480 I8074836A538    LEVEL: Error
PID    : 319680             TID  : 20664    PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000       DB : NEWSDB
APPHDL  : 0-20035             APPID: 172.21.40.22.4803.140612061425
AUTHID  : SBNETDBA
EDUID : 20664             EDUNAME: db2agent (NEWSDB) 0
FUNCTION: DB2 UDB, common communication, sqlcctcptest, probe:11
MESSAGE : Detected client termination
DATA #1 : Hexdump, 2 bytes
0x07000000BC3F2992 : 0036                                     .6

2014-06-12-14.21.45.817245+480 I8075375A520    LEVEL: Error
PID    : 319680             TID  : 20664    PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000       DB : NEWSDB
APPHDL  : 0-20035             APPID: 172.21.40.22.4803.140612061425
AUTHID  : SBNETDBA
EDUID : 20664             EDUNAME: db2agent (NEWSDB) 0
FUNCTION: DB2 UDB, common communication, sqlcctest, probe:50
MESSAGE : sqlcctest RC
DATA #1 : Hexdump, 2 bytes
0x07000000BC3F4A70 : 0036                                     .6

2014-06-12-14.21.45.817434+480 I8075896A500    LEVEL: Error
PID    : 319680             TID  : 20664    PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000       DB : NEWSDB
APPHDL  : 0-20035             APPID: 172.21.40.22.4803.140612061425
AUTHID  : SBNETDBA
EDUID : 20664             EDUNAME: db2agent (NEWSDB) 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgent::AgentBreathingPoint, probe:10
CALLED  : DB2 UDB, common communication, sqlcctest
RETCODE : ZRC=0x00000036=54

2014-06-12-14.21.45.843432+480 I8090477A1254    LEVEL: Warning
PID    : 319680             TID  : 18509    PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000       DB : NEWSDB
APPHDL  : 0-20071             APPID: 172.21.40.22.4833.140612061433
AUTHID  : SBNETDBA
EDUID : 18509             EDUNAME: db2agent (NEWSDB) 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgent::AgentBreathingPoint, probe:16
CALLSTCK:
  [0] 0x090000000978D1F4 pdLog + 0xFC
  [1] 0x09000000053308A0 pdLog@glue3EC + 0x94
  [2] 0x09000000059384DC AgentBreathingPoint__8sqeAgentFi + 0x5FC
  [3] 0x090000000981D5B0 IntrptWaitLock__12@52@sqeAgentFP16SQLO_EDUWAITPOSTiPUi + 0x20C
  [4] 0x09000000097B87F4 sqlplnfd__FP9sqeBsuEduP14SQLP_LOCK_INFOP8SQLP_LCBP9SQLP_LHSHP8SQLP_LRBUiiUlT7P8SQLP_AWBT7 + 0xBA0
  [5] 0x0900000009853E90 sqlplrq__FP9sqeBsuEduP14SQLP_LOCK_INFO + 0x118
  [6] 0x0900000005C9F654 @146@sqliLockUncond__FP7SQLI_CBP14SQLP_LOCK_INFOP12SQLI_KEYDATAPUlPcT5Ul + 0x4F4
  [7] 0x09000000098A79D4 @146@sqliLockForReadUncond__FP7SQLI_CBP12SQLI_KEYDATAPUlPcT4Ul + 0xD0
  [8] 0x09000000077E7B2C sqliDataFetchRetrySetup__FP7SQLI_CBP12SQLI_KEYDATAPUlPcT4Ul + 0x15C
  [9] 0x0900000009992AB4 .@[email]146@sqliScanLeaf2.fdpr.clone.268__FP7SQLI_CBP11SQLI_SFGLOB[/email] + 0x2C收起

关注1

参与9

查看其它 7 个回答mdshuo的回答

mdshuo软件开发工程师sobey

http://www-01.ibm.com/support/docview.wss?uid=swg21470035找到一篇文章解释类似情况。
Scenario #5: Executing long running query

A remote DB2 client has abnormally terminated when executing a long running query which includes a call to a routine. These messages are informational in nature and can be ignored. However the application should contain some exception handling logic to handle any abnormal terminations. Under the covers DB2 will clean up any non-SQL routines being executed on behalf of the connection. One of the side effects is that the db2diag.log may contain a 0xFFFFFB38 ( SQL1224)

In the example below the message originating from the db2fmp process about "The database manager is not able to accept new requests..." is misleading. The message is originating from the JDBC (db2jcc.jar) used internally by the DB2 server to execute a Java routine and can be ignored. There is nothing wrong with the DB2 database server.

文中提到：
There is nothing wrong with the DB2 database server.
但我这里却是必须重启数据库服务器才能解决问题，这又是为何？

互联网服务 · 2014-06-12

数据库诊断日志中ERROR和WARNING信息

查看其它 7 个回答mdshuo的回答

回答者

mdshuo 最近回答过的问题

回答状态