Hi,

Is there any quick way (withjoiut restoring) to recover from this error? It's on a VMware system that I can roll-back but it has happened twice now and would like to know how to fix it?

Simon

2008-03-05-23.20.09.442000+000 I10768117H640 LEVEL: Severe
PID : 2216 TID : 2948 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : WAREHOUS
APPHDL : 0-14 APPID: *LOCAL.DB2.080305232000
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1150
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : <preformatted>
Failed to read page from disk on attempt number 1.
Retrying operation. Only subsequent failures will be logged.

2008-03-05-23.20.09.442000+000 I10768759H1666 LEVEL: Severe
PID : 2216 TID : 2948 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : WAREHOUS
APPHDL : 0-14 APPID: *LOCAL.DB2.080305232000
AUTHID : ADMINISTRATOR
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, 95 bytes
CBIT verification error
bitExpected is 0, userByte is 1, sector 7 (from head of page, 0 based)
DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
64995
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 68 bytes
Obj: {pool:2;obj:2832;type:1} Parent={2;2832}
lifeLSN: 00008984C3BF
tid: 0 0 0
extentAnchor: 64960
initEmpPages: 0
poolPage0: 64992
poolflags: 3122
objectState: 27
lastSMP: 0
pageSize: 4096
extentSize: 32
bufferPoolID: 1
partialHash: 168820738
bufferPool: 0x06fdd290
DATA #5 : Bitmask, 4 bytes
0x00000002
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:2;obj:2832;type:1} PPNum:64995 OPNum:3
begoff: 48
datlen: 4048
pagebinx: 274
revnum: 1024
pagelsn: 000155EA6420 flag: 6
signature: 1206056196
cbits1to31: 0
cbits32to63: 0

try to use dbdart and it will which page is corrupted..drop the object and recreate it