基本情况描述：
数据库在执行数据刷新操作时,crash了。
OS windows2003 sp2 数据库版本：DB2 v9.7.0.441"、"s090521" 和 "NT3297"，修订包为 "0"。
我的初步分析，日志文件导致系统crash，难道是数据库的bug 。
以下是部分db2diag.log文件
2010-03-24-08.09.00.671000+480 I402094449H552 LEVEL: Severe
PID : 7264 TID : 7084 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PLATSYS
APPHDL : 0-52309 APPID: 10.145.6.130.36617.100323190025
AUTHID : CARECLUB
EDUID : 7084 EDUNAME: db2agent (PLATSYS)
FUNCTION: DB2 UDB, data protection services, sqlpgrlg, probe:9120
DATA #1 :
diff 3043, count 3043, fromptr 7F4BABF3, CharPtr 7F4BB02F, pageLso 236223202312, LowPageLso 236223198237
2010-03-24-08.09.00.687000+480 I402095003H541 LEVEL: Severe
PID : 7264 TID : 7084 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PLATSYS
APPHDL : 0-52309 APPID: 10.145.6.130.36617.100323190025
AUTHID : CARECLUB
EDUID : 7084 EDUNAME: db2agent (PLATSYS)
FUNCTION: DB2 UDB, data protection services, sqlpgrlg, probe:9120
DATA #1 :
rc -2028994519, pageByteCount 4076, pageLso 236223202312 LookForLso 236223201280, Bp 7F4BA000
2010-03-24-08.09.00.687000+480 I402095546H195 LEVEL: Severe
PID:7264 TID:7084 NODE:000 Title: SQLP_LFPB
Dump File:C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY1\DB2\7264.7084.000.dump.bin
2010-03-24-08.09.00.703000+480 I402095743H1045 LEVEL: Error
PID : 7264 TID : 7084 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PLATSYS
APPHDL : 0-52309 APPID: 10.145.6.130.36617.100323190025
AUTHID : CARECLUB
EDUID : 7084 EDUNAME: db2agent (PLATSYS)
FUNCTION: DB2 UDB, data protection services, sqlpgrlg, probe:2510
DATA #1 :
-2028994519 when reading LSO 236223201280 from log file S0000466.LOG dpsAgtCbFlags 0 setSkipOutputBuf 0
CALLSTCK:
[0] 0x6CC29EFD pdLogPrintf + 0x269
[1] 0x6EF584FA sqlucPdLogPrintf + 0x595CC4
[2] 0x6DED37BD sqlpluhd + 0x170CD
[3] 0x6D554F1A sqldExpandFullRecOverrideDict + 0x5AA6C
[4] 0x6EC2AE41 sqlucPdLogPrintf + 0x26860B
[5] 0x6D5527F2 sqldExpandFullRecOverrideDict + 0x58344
[6] 0x6D55226F sqldExpandFullRecOverrideDict + 0x57DC1
[7] 0x6D4E4FD9 sqldRowFetch + 0x32B
[8] 0x6E177D6F sqlri_udf_free_out_loc + 0x837A9
[9] 0x6E0F6546 sqlri_udf_free_out_loc + 0x1F80
2010-03-24-08.09.01.109000+480 I402096790H986 LEVEL: Severe
PID : 7264 TID : 7084 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PLATSYS
APPHDL : 0-52309 APPID: 10.145.6.130.36617.100323190025
AUTHID : CARECLUB
EDUID : 7084 EDUNAME: db2agent (PLATSYS)
FUNCTION: DB2 UDB, data protection services, sqlpgrlg, probe:2510
DATA #1 :
HeadLsn 000000373C2C0C7D, reqlso 236223201280
CALLSTCK:
[0] 0x6CC29EFD pdLogPrintf + 0x269
[1] 0x6EF5854C sqlucPdLogPrintf + 0x595D16
[2] 0x6DED37BD sqlpluhd + 0x170CD
[3] 0x6D554F1A sqldExpandFullRecOverrideDict + 0x5AA6C
[4] 0x6EC2AE41 sqlucPdLogPrintf + 0x26860B
[5] 0x6D5527F2 sqldExpandFullRecOverrideDict + 0x58344
[6] 0x6D55226F sqldExpandFullRecOverrideDict + 0x57DC1
[7] 0x6D4E4FD9 sqldRowFetch + 0x32B
[8] 0x6E177D6F sqlri_udf_free_out_loc + 0x837A9
[9] 0x6E0F6546 sqlri_udf_free_out_loc + 0x1F80
2010-03-24-08.09.01.109000+480 I402097778H195 LEVEL: Severe
PID:7264 TID:7084 NODE:000 Title: SQLP_DBCB
Dump File:C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY1\DB2\7264.7084.000.dump.bin
2010-03-24-08.09.01.125000+480 I402097975H195 LEVEL: Severe
PID:7264 TID:7084 NODE:000 Title: SQLP_LFPB
Dump File:C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY1\DB2\7264.7084.000.dump.bin
2010-03-24-08.09.01.125000+480 I402098172H195 LEVEL: Severe
PID:7264 TID:7084 NODE:000 Title: SQLP_LFPB
Dump File:C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY1\DB2\7264.7084.000.dump.bin
2010-03-24-08.09.01.125000+480 I402098369H561 LEVEL: Severe
PID : 7264 TID : 7084 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PLATSYS
APPHDL : 0-52309 APPID: 10.145.6.130.36617.100323190025
AUTHID : CARECLUB
EDUID : 7084 EDUNAME: db2agent (PLATSYS)
FUNCTION: DB2 UDB, data management, sqldRowFetch, probe:666
RETCODE : ZRC=0x87100029=-2028994519=SQLP_BADLSN "Invalid LSN value."
DIA8538C An invalid log sequence number (LSN), the value was "".
2010-03-24-08.09.01.156000+480 I402098932H652 LEVEL: Severe
PID : 7264 TID : 7084 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PLATSYS
APPHDL : 0-52309 APPID: 10.145.6.130.36617.100323190025
AUTHID : CARECLUB
EDUID : 7084 EDUNAME: db2agent (PLATSYS)
FUNCTION: DB2 UDB, data management, sqldRowFetch, probe:666
DATA #1 : String, 119 bytes
ccbptr=50E5B800, poolID=5, objectID=25, class=0,
recid=2B2002E, waPrivFlags=2058001F, waMdcFlags=00000000, fetchMode=2
DATA #2 : Hexdump, 4 bytes
0x08D99E34 : 0200 0000 ....
2010-03-24-08.09.01.171000+480 I402099586H539 LEVEL: Severe
PID : 7264 TID : 7084 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PLATSYS
APPHDL : 0-52309 APPID: 10.145.6.130.36617.100323190025
AUTHID : CARECLUB
EDUID : 7084 EDUNAME: db2agent (PLATSYS)
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : SQLD_CCB:
DATA #1 : String, 49 bytes
pool(TID)=5, obj(FID)=25, indexid(IID)=0, class=0
2010-03-24-08.09.01.171000+480 I402100127H194 LEVEL: Severe
PID:7264 TID:7084 NODE:000 Title: SQLD_CCB
Dump File:C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY1\DB2\7264.7084.000.dump.bin
2010-03-24-08.09.01.171000+480 I402100323H204 LEVEL: Severe
PID:7264 TID:7084 NODE:000 Title: SQLD_CCB_DPARTINFO
Dump File:C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY1\DB2\7264.7084.000.dump.bin
2010-03-24-08.09.01.171000+480 I402100529H526 LEVEL: Severe
PID : 7264 TID : 7084 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PLATSYS
APPHDL : 0-52309 APPID: 10.145.6.130.36617.100323190025
AUTHID : CARECLUB
EDUID : 7084 EDUNAME: db2agent (PLATSYS)
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : SQLD_TCB:
DATA #1 : String, 35 bytes
Perm Table(5:25)=CARECLUB.ASS_USERS
2010-03-24-08.09.01.171000+480 I402101057H213 LEVEL: Severe
PID:7264 TID:7084 NODE:000 Title: SQLD_TCB_NAME.tcbSchemaName
Dump File:C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY1\DB2\7264.7084.000.dump.bin
 |
| 文件: |
FODC_Panic_2010-03-24-08.09.10.968000.rar |
| 大小: |
318KB |
| 下载: |
下载 | |
|
| 文件: |
db2error.rar |
| 大小: |
210KB |
| 下载: |
下载 | |
阅读(1785) | 评论(0) | 转发(0) |
