DB2 日志报出来错误,现在库起不来,请大家帮分析怎么处理
2011-06-28-11.35.36.140475+480 I47788573E2543 LEVEL: SeverePID : 26142 TID: 47205410924864PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL: 0-7 APPID: *LOCAL.tsminst1.110628033533
AUTHID: TSMINST1
EDUID : 36 EDUNAME: db2redow (TSMDB1) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbVerifyCBITS, probe:1110
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : String, 64 bytes
Error encountered trying to read a page - information follows :
DATA #2 : String, 96 bytes
CBIT verification error
bitExpected is 0, userByte is 65, sector 31 (from head of page, 0 based)
DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
10417
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 72 bytes
Obj: {pool:6;obj:5;type:1} Parent={5;5}
lifeLSN: 0000012DA201
tid: 0 00
extentAnchor: 160
initEmpPages: 0
poolPage0: 192
poolflags: 3122
objectState: 27
lastSMP: 0
pageSize: 32768
extentSize: 32
bufferPoolID: 4
partialHash: 17104902
bufferPool: 0x00002aeef2260180
DATA #5 : Bitmask, 4 bytes
0x00000023
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:6;obj:5;type:1} PPNum:10417 OPNum:10033
begoff: 48
datlen: 32720
pagebinx: 642
revnum: 1024
pagelsn: 0027F786CFC6flag: 6
signature: 3164800852
cbits1to31: 49e80301
cbits32to63: 4209fba1
CALLSTCK:
0x00002AEEC921277F pdLog + 0xD7
0x00002AEEC9B12418 _Z25sqlbLogReadAttemptFailurejP16SQLB_OBJECT_DESCjP9SQLB_PAGEibmjPcP12SQLB_GLOBALS + 0x180
0x00002AEECB3D7203 /opt/tivoli/tsm/db2/lib64/libdb2e.so.1 + 0x3127203
0x00002AEECB3D5804 sqlbReadPage + 0x490
0x00002AEECB3CD6C4 _Z19sqlbGetPageFromDiskP11SQLB_FIX_CBi + 0x160
0x00002AEECB3C025B _Z7sqlbfixP11SQLB_FIX_CB + 0xB2F
0x00002AEECB475941 _Z7sqlifixP7SQLI_CBP14SQLI_PAGE_DESCji + 0x5D
0x00002AEECB236F3D _Z12sqliRecFixpgP7SQLI_CBjiP14SQLI_PAGE_DESC + 0x33
0x00002AEECB231F49 /opt/tivoli/tsm/db2/lib64/libdb2e.so.1 + 0x2F81F49
0x00002AEECB2356A1 _Z8sqliRedoP8sqeAgentPcP8SQLP_LSNmm + 0x30C7 先检查检查磁盘是否能访问吧!
$db2diag -rc 0x86020019
Input ZRC string '0x86020019' parsed as 0x86020019 (-2046689255).
ZRC value to map: 0x86020019 (-2046689255)
V7 Equivalent ZRC value: 0xFFFFE119 (-7911)
ZRC class :
Critical Media Error (Class Index: 6)
Component:
SQLB ; buffer pool services (Component Index: 2)
Reason Code:
25 (0x0019)
Identifer:
SQLB_CSUM
Identifer (without component):
SQLZ_RC_CSUM
Description:
Bad Page, Checksum Error
Associated information:
Sqlcode -980
SQL0980CA disk error occurred.Subsequent SQL statements cannot be
processed.
Number of sqlca tokens : 0
Diaglog message number: 8426
页:
[1]