主数据库在2010-07-22-10.23.35连续报三次
2010-07-22-10.23.35.604529+480 I314904C350 LEVEL: Severe
PID : 516256 TID : 772 PROC : db2fmp (Java) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, SQO Memory Management, sqlofmblkEx, probe:20
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x30CD7578 : 820F 0002 ....
之后连续报
2010-07-22-10.30.50.819959+480 I334690C1039 LEVEL: Error
PID : 643322 TID : 1 PROC : db2agent (NETDB) 0
INSTANCE: db2inst1 NODE : 000 DB : NETDB
APPHDL : 0-187 APPID: GA141401.H00A.119302022201
MESSAGE : Severe TERMINATE err at nest lvl 1, in SQL from rtn
NETDBA.DOC_LOCKDATA:
DATA #1 : Hexdump, 136 bytes
0x20037ED0 : 5351 4C43 4120 2020 0000 0088 FFFF FC48 SQLCA .......H
0x20037EE0 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x20037EF0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x20037F00 : 2020 2020 2020 2020 2020 2020 2020 2020
0x20037F10 : 2020 2020 2020 2020 2020 2020 2020 2020
0x20037F20 : 2020 2020 2020 2020 5351 4C52 4932 4331 SQLRI2C1
0x20037F30 : 8010 0003 0000 0003 0000 0000 0000 0000 ................
0x20037F40 : FFFF FE0C 0000 0000 2020 2020 2020 2020 ........
0x20037F50 : 2020 2035 3730 3134 57014
2010-07-22-10.30.50.820579+480 I335730C1039 LEVEL: Error
PID : 847964 TID : 1 PROC : db2agent (NETDB) 0
INSTANCE: db2inst1 NODE : 000 DB : NETDB
APPHDL : 0-310 APPID: GA141401.H20A.119302022205
MESSAGE : Severe TERMINATE err at nest lvl 1, in SQL from rtn
NETDBA.DOC_LOCKDATA:
DATA #1 : Hexdump, 136 bytes
0x2006B360 : 5351 4C43 4120 2020 0000 0088 FFFF FC48 SQLCA .......H
0x2006B370 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x2006B380 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2006B390 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2006B3A0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x2006B3B0 : 2020 2020 2020 2020 5351 4C52 4932 4331 SQLRI2C1
0x2006B3C0 : 8010 0003 0000 0003 0000 0000 0000 0000 ................
0x2006B3D0 : FFFF FE0C 0000 0000 2020 2020 2020 2020 ........
0x2006B3E0 : 2020 2035 3730 3134 57014
2010-07-22-10.32.30.821641+480 I336770C1039 LEVEL: Error
PID : 905376 TID : 1 PROC : db2agent (NETDB) 0
INSTANCE: db2inst1 NODE : 000 DB : NETDB
APPHDL : 0-19 APPID: GA141401.GF0A.1250C2022159
MESSAGE : Severe TERMINATE err at nest lvl 1, in SQL from rtn
NETDBA.DOC_LOCKDATA:
DATA #1 : Hexdump, 136 bytes
0x20037ED0 : 5351 4C43 4120 2020 0000 0088 FFFF FC48 SQLCA .......H
0x20037EE0 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x20037EF0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x20037F00 : 2020 2020 2020 2020 2020 2020 2020 2020
0x20037F10 : 2020 2020 2020 2020 2020 2020 2020 2020
0x20037F20 : 2020 2020 2020 2020 5351 4C52 4932 4331 SQLRI2C1
0x20037F30 : 8010 0003 0000 0003 0000 0000 0000 0000 ................
0x20037F40 : FFFF FE0C 0000 0000 2020 2020 2020 2020 ........
0x20037F50 : 2020 2035 3730 3134 57014
造成全部应用客户机不能登录和保存,
因为系统是通过com+组件访问数据库。
所以首先是重启全部组件服务器,但重启之后,客户端还是不能正常登录,
最后,只能db2stop,db2start重启实例,才恢复业务的正常运行。
请问是什么原因,有人能具体解释和解决此问题吗?谢谢!
附件:
db2diag.zip (20.4 KB)
收起