- 论坛徽章:
- 0
|
环境:AIX5.2
数据库版本:8.2
症状:直接表现为应用无法使用,数据库直接连接也无法连接,db2stop 也无法停掉,只有重启数据库服务器才行。
日志片段如下,请高手帮忙分析一下什么原因:
2007-12-01-00.29.01.036396+480 I1054138C451 LEVEL: Severe
PID : 6580 TID : 1 PROC : db2agent (idle) 0
INSTANCE: db2inst2 NODE : 000 DB : BTCJDB
APPHDL : 0-501 APPID: C0A85504.O0E2.048A10154851
FUNCTION: DB2 UDB, DRDA Application Server, sqljsInitAgent, probe:10
MESSAGE : sqlccinit rc =
DATA #1 : Hexdump, 4 bytes
0x2FF13F10 : 0000 0036 ...6
2007-12-01-00.29.01.036629+480 I1054590C1192 LEVEL: Severe
PID : 6580 TID : 1 PROC : db2agent (idle) 0
INSTANCE: db2inst2 NODE : 000 DB : BTCJDB
APPHDL : 0-501 APPID: C0A85504.O0E2.048A10154851
FUNCTION: DB2 UDB, DRDA Application Server, sqljsInitAgent, probe:15
MESSAGE : Com-condition =
DATA #1 : Hexdump, 172 bytes
0x2FF13F34 : 0005 0007 3000 0000 0000 0001 1A5A 0002 ....0........Z..
0x2FF13F44 : 0000 0000 0000 0000 0000 0000 2A00 0000 ............*...
0x2FF13F54 : 820A 0001 1A58 0000 0000 0000 820A 0001 .....X..........
0x2FF13F64 : 0000 0004 2A00 000A F0CD 1200 2FF1 4020 ....*......./.@
0x2FF13F74 : 0000 0000 D38C 54E0 F0CD 11EC 2A00 0000 ......T.....*...
0x2FF13F84 : F0CD 8CB8 0000 0000 0000 0001 1A5A 0002 .............Z..
0x2FF13F94 : 0000 0000 2A00 0000 0000 0000 0200 0000 ....*...........
0x2FF13FA4 : 820A 0001 0000 000A 0000 0004 0000 0000 ................
0x2FF13FB4 : 0000 0000 D3A6 4228 F0CD 1200 2FF1 4020 ......B(..../.@
0x2FF13FC4 : 0000 0000 434F 4E4E 4543 5420 534D 454D ....CONNECT SMEM
0x2FF13FD4 : 0000 0000 0000 0000 0000 0000 ............
2007-12-01-00.30.15.151841+480 I1055783C335 LEVEL: Warning
PID : 23248 TID : 1 PROC : db2loggr (BTCJDB) 0
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1390
MESSAGE : ExtNum 757, state 401, baselsn 00000002961C0000 nextlsn
000000029658CA5D
2007-12-01-00.31.10.196324+480 I1056119C296 LEVEL: Warning
PID : 23248 TID : 1 PROC : db2loggr (BTCJDB) 0
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.
2007-12-01-00.32.10.196920+480 I1056416C296 LEVEL: Warning
PID : 23248 TID : 1 PROC : db2loggr (BTCJDB) 0
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.
2007-12-01-00.33.10.197522+480 I1056713C296 LEVEL: Warning
PID : 23248 TID : 1 PROC : db2loggr (BTCJDB) 0
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.
2007-12-01-00.34.10.198183+480 I1057010C296 LEVEL: Warning
PID : 23248 TID : 1 PROC : db2loggr (BTCJDB) 0
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.
2007-12-01-00.35.10.198773+480 I1057307C401 LEVEL: Warning
PID : 23248 TID : 1 PROC : db2loggr (BTCJDB) 0
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1800
DATA #1 : String, 131 bytes
DB2 was unable to confirm logs were archived.
Return code -2029059911, FirstArchNum 756, FirstArchNum2 4294967295, HeadExtentID 758
2007-12-01-00.40.12.766409+480 I1057709C380 LEVEL: Warning
PID : 28128 TID : 1 PROC : db2agent (idle) 0
INSTANCE: db2inst2 NODE : 000 DB : BTCJDB
APPHDL : 0-27 APPID: C0A85504.O041.052AB0005211
FUNCTION: DB2 UDB, data protection, sqlpterm, probe:2330
MESSAGE : Some daemon is taking too long to shut down
--如上条信息五分钟一次,直至下次重启服务器
2007-12-01-00.45.15.314696+480 I1058090C380 LEVEL: Warning
PID : 28128 TID : 1 PROC : db2agent (idle) 0
INSTANCE: db2inst2 NODE : 000 DB : BTCJDB
APPHDL : 0-27 APPID: C0A85504.O041.052AB0005211
FUNCTION: DB2 UDB, data protection, sqlpterm, probe:2330
MESSAGE : Some daemon is taking too long to shut down
...........................
2007-12-01-09.28.25.703742+480 I1103604C423 LEVEL: Severe
PID : 35746 TID : 1 PROC : db2agent (BTCJDB) 0
INSTANCE: db2inst2 NODE : 000 DB : BTCJDB
APPHDL : 0-53 APPID: C0A82404.KC04.01EF01010402
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2007-12-01-09.28.25.704863+480 I1104028C167 LEVEL: Severe
PID:35746 TID:1 NODE:000 Title: **** DRDA ASCB ****
Dump File:/home/db2inst2/sqllib/db2dump/357461.000
。。。。。。。。。。。。。
2007-12-01-09.28.25.710433+480 I1105063C172 LEVEL: Severe
PID:35746 TID:1 NODE:000 Title: **** AS UCINTERFACE ****
Dump File:/home/db2inst2/sqllib/db2dump/357461.000
2007-12-01-09.28.25.710582+480 I1105236C436 LEVEL: Severe
PID : 35746 TID : 1 PROC : db2agent (BTCJDB) 0
INSTANCE: db2inst2 NODE : 000 DB : BTCJDB
APPHDL : 0-53 APPID: C0A82404.KC04.01EF01010402
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:20
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
[ 本帖最后由 lmb 于 2007-12-3 17:35 编辑 ] |
|