During a database rollforward, we may encounter an unexpected
End of File (EOF) while prefetching pages if an automatic DMS
tablespace is repeatedly being expanded during the rollforward.
The DMS tablespace needs to have been created prior to v97 (i.e.
a migrated database) for this to occur.
Example db2diag.log messages:
2012-12-05-13.31.11.045535-420 E627148A511 LEVEL: Info
PID : 49545328 TID : 27768 PROC :
db2sysc0
INSTANCE: db2inst1 NODE : 000 DB :SAMPLE
APPHDL : 0-9
APPID:*LOCAL.db2inst1.121205200111
AUTHID : db2inst1 EDUID : 27768 EDUNAME:
db2redow (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services,
sqlbGrowLastRange,probe:60
MESSAGE : ADM6102I Table space "USERSPACE2" (ID "3") was
successfully extended by "33554432" bytes.
2012-12-05-13.31.11.454924-420 I627660A388 LEVEL: Warning
PID : 49545328 TID : 16460 PROC :
db2sysc0
INSTANCE: db2inst1 NODE : 000
EDUID : 16460 EDUNAME: db2pfchr (SAMPLE) 0
FUNCTION: DB2 UDB, RAS/PD component,
pdEDUIsInDB2KernelOperation, probe:600
DATA #1 : String, 22 bytes
sqlbReadPageInternal
DATA #2 : String, 4 bytes
sqlb
2012-12-05-13.31.11.455395-420 I628049A454 LEVEL: Severe
PID : 49545328 TID : 16460 PROC :
db2sysc0
INSTANCE: db2inst1 NODE : 000
EDUID : 16460 EDUNAME: db2pfchr (SAMPLE) 0
FUNCTION: DB2 UDB, RAS/PD component,
pdResilienceIsSafeToSustain, probe:800
DATA #1 : String, 37 bytes
Trap Sustainability Criteria Checking
DATA #2 : Hex integer, 8 bytes
0x200000000000884C
DATA #3 : Boolean, 1 bytes
false
Example Stack:
<StackTrace>
-------Frame------ ------Function + Offset------
0x090000000DFBCC7C
sqlmStopWaitTimeInterval__FCUlP8sqeAgentCbN23@glue57C + 0x24C
0x090000000DECF348 sqlmStopInterval__FCUlP8sqeAgentCi@glue57A +
0x1FC
0x09000000116A27F8 sqlbReadPageInternal + 0x48
0x09000000116A65CC sqlbReadPage + 0x170
0x09000000116BA48C
.sqlbGetPageFromDisk.fdpr.clone.2031__FP11SQLB_FIX_CBi + 0x694
Nested signal handlers detected
<SignalDetails>
<Siginfo_t length="64">
07000000 01BFDEAC 00000000 00000002
00000000 00000FEA 00000000 00000000
FFFFFFFF FFFFFFFF 00000000 00000000
07000000 01BFE0C8 00000000 00000000
</Siginfo_t>
Signal #117440512 (unknown signal name); si_code: 0
(SI_USER:Sent by kill, sigse
nd, raise.)
</SignalDetails> |
