The DB2DIAG.log file shows messages as below, but the db2 still
running without crash. There is no stack in db2diag.log or
dumped files. However the transaction may roll back.
2013-01-08-14.15.37.497938-300 I5125893A453 LEVEL: Error
PID : 16777590 TID : 7056 PROC : db2sysc
71
INSTANCE: db2inst01 NODE : 071
EDUID : 7056 EDUNAME: db2pfchr (DB) 71
FUNCTION: DB2 UDB, buffer pool services,
sqlbReadAndReleaseBlock, probe:110
DATA #1 : String, 114 bytes
Tablespace 5 (TS_USERTEMP) flags=1141
HighWaterMark=0ConOffset=294912, startpage=18,
diskPageNumber=18, numPages=9
2013-01-08-14.15.37.498277-300 I5126347A437 LEVEL: Error
PID : 16777590 TID : 7056 PROC : db2sysc
71
INSTANCE: db2inst01 NODE : 071
EDUID : 7056 EDUNAME: db2pfchr (DB) 71
FUNCTION: DB2 UDB, buffer pool services,
sqlbReadAndReleaseBlock, probe:100
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not
exist"
DIA8506C Unexpected end of file was reached.
2013-01-08-14.15.37.498666-300 I5126785A448 LEVEL: Error
PID : 16777590 TID : 7056 PROC : db2sysc
71
INSTANCE: db2inst01 NODE : 071
EDUID : 7056 EDUNAME: db2pfchr (DB) 71
FUNCTION: DB2 UDB, buffer pool services,
sqlbReadAndReleaseBlock, probe:100
DATA #1 : String, 109 bytes
Obj={pool:5;obj:42;type:129} State=x27 Cont=0 Offset=18
BlkSize=14
sqlbReadAndReleaseBlock error: numpages=9
2013-01-08-14.15.37.498997-300 I5127234A910 LEVEL: Error
PID : 16777590 TID : 7056 PROC : db2sysc
71
INSTANCE: db2inst01 NODE : 071
EDUID : 7056 EDUNAME: db2pfchr (DB) 71
FUNCTION: DB2 UDB, buffer pool services,
sqlbReadAndReleaseBlock, probe:0
DATA #1 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 88 bytes
Obj: {pool:5;obj:42;type:129} Parent={5;42}
lifeLSN: 00000349D09AAFE2
tid: 0 0 0
extentAnchor: 0
initEmpPages: 0
poolPage0: 0
poolflags: 1141
objectState: 27
lastSMP: 0
pageSize: 16384
extentSize: 16
bufferPoolID: 2
partialHash: 2167013381
bufferPool: 0x0700000025a91820
pdef: 0x070000002a4343a0
2013-01-08-14.15.37.507804-300 I5128145A437 LEVEL: Error
PID : 16777590 TID : 7056 PROC : db2sysc
71
INSTANCE: db2inst01 NODE : 071
EDUID : 7056 EDUNAME: db2pfchr (DB) 71
FUNCTION: DB2 UDB, buffer pool services,
sqlbBlockAreaErrorHandler, probe:0
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not
exist"
DIA8506C Unexpected end of file was reached.
2013-01-08-14.15.37.509498-300 I5128583A415 LEVEL: Error
PID : 16777590 TID : 7056 PROC : db2sysc
71
INSTANCE: db2inst01 NODE : 071
EDUID : 7056 EDUNAME: db2pfchr (DB) 71
FUNCTION: DB2 UDB, buffer pool services,
sqlbBlockAreaErrorHandler, probe:0
DATA #1 : String, 77 bytes
Obj={pool:5;obj:42;type:129} State=x27
Prefetcher Error, in sqlbProcessRange |
