看了下0x00000036对应的错误应该是SQL0290N错误,指出表空间由于处于停顿状态而不允许存取,
出现这个问题后数据库就挂了,需要重新连接,一天能出现好几次,有人能告诉我会产生这个问题的原因吗?
详细的日志文件如下:
2016-02-25-14.22.47.875394+480 I2283062A489 LEVEL: Event
PID : 26017870 TID : 10282 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MTDB2
APPHDL : 0-8 APPID: *LOCAL.DB2.160225021942
AUTHID : PAS
EDUID : 10282 EDUNAME: db2stmm (MTDB2) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : STMM CFG DB MTDB2: "Sortheap" From: "3912"
2016-02-25-14.23.07.864623+480 I2283552A533 LEVEL: Error
PID : 26017870 TID : 16829 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MTDB2
APPHDL : 0-52 APPID: 10.1.3.43.1740.160225022908
AUTHID : PAS
EDUID : 16829 EDUNAME: db2agent (MTDB2) 0
FUNCTION: DB2 UDB, common communication, sqlcctcptest, probe:11
MESSAGE : Detected client termination
DATA #1 : Hexdump, 2 bytes
0x070000013D3E41C2 : 0036 .6
2016-02-25-14.23.07.864923+480 I2284086A515 LEVEL: Error
PID : 26017870 TID : 16829 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MTDB2
APPHDL : 0-52 APPID: 10.1.3.43.1740.160225022908
AUTHID : PAS
EDUID : 16829 EDUNAME: db2agent (MTDB2) 0
FUNCTION: DB2 UDB, common communication, sqlcctest, probe:50
MESSAGE : sqlcctest RC
DATA #1 : Hexdump, 2 bytes
0x070000013D3E62B0 : 0036 .6
2016-02-25-14.23.07.865122+480 I2284602A495 LEVEL: Error
PID : 26017870 TID : 16829 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MTDB2
APPHDL : 0-52 APPID: 10.1.3.43.1740.160225022908
AUTHID : PAS
EDUID : 16829 EDUNAME: db2agent (MTDB2) 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgent::AgentBreathingPoint, probe:10
CALLED : DB2 UDB, common communication, sqlcctest
RETCODE : ZRC=0x00000036=54
2016-02-25-14.23.07.865396+480 I2285098A1150 LEVEL: Warning
PID : 26017870 TID : 16829 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MTDB2
APPHDL : 0-52 APPID: 10.1.3.43.1740.160225022908
AUTHID : PAS
EDUID : 16829 EDUNAME: db2agent (MTDB2) 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgent::AgentBreathingPoint, probe:16
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x090000000BECFB60 pdLog + 0xE4
[1] 0x0900000008884D04 pdLog@glue417 + 0x94
[2] 0x09000000087E6BEC AgentBreathingPoint__8sqeAgentFi + 0x754
[3] 0x090000000BEDE1E8 AgentBreathingPoint__8sqeAgentFi@glue199 + 0x78
[4] 0x090000000BEDE128 sqldFetchDirect__FP13SQLD_DFM_WORK + 0x8
[5] 0x090000000BF6DD6C sqldDataFetch__FP8SQLD_CCBP8SQLZ_RIDUlP7SQLI_CB + 0x17C
[6] 0x090000000BF6D960 .@147@sqli_proc_leaf.fdpr.clone.2014__FP7SQLI_CBi + 0x160
[7] 0x090000000BF763DC .sqliFirstTreeSearch.fdpr.clone.1974__FP7SQLI_CBP11SQLI_SFGLOB + 0x27C
[8] 0x0000000000000000 ?unknown + 0x0
[9] 0x0000000000000000 ?unknown + 0x0
2016-02-25-14.23.07.876046+480 I2286249A925 LEVEL: Error
PID : 26017870 TID : 16829 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MTDB2
APPHDL : 0-52 APPID: 10.1.3.43.1740.160225022908
AUTHID : PAS
EDUID : 16829 EDUNAME: db2agent (MTDB2) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_rds_common_post, probe:1700
MESSAGE : Severe TERMINATE err at nest lvl 3, in SQL from rtn
PAS.SP_PASJAVA_CKYJCX:
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09075
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 55032
2016-02-25-14.31.47.981849+480 I2287175A497 LEVEL: Event
PID : 26017870 TID : 10282 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MTDB2
APPHDL : 0-8 APPID: *LOCAL.DB2.160225021942
AUTHID : PAS
EDUID : 10282 EDUNAME: db2stmm (MTDB2) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : STMM CFG DB MTDB2: "Sheapthres_shr" From: "15659"