When there is a large amount of LOB data in a table so that
level 2 EMP pages are required then the INSPECT command can
incorrectly calculate the next EMP page resulting in the errors
similar to the following:
DATABASE: SAMPLE
VERSION : SQL09076
2014-05-15-09.06.15.460665
Action: CHECK TABLE
Schema name: DB2INST1
Table name: TABLELOB
Tablespace ID: 11 Object ID: 1037
Result file name: tb_inspect_trc.txt
Table phase start (ID Signed: 1037, Unsigned: 1037;
Tablespace ID: 11) : DB2INST1.TABLELOB
Data phase start. Object: 1037 Tablespace: 11
The index type is 2 for this table.
Traversing DAT extent map, anchor 626164.
Extent map traversal complete.
DAT Object Summary: Total Pages 1369 - Used Pages 1369 -
Free Space 7 %
Data phase end.
Index phase start. Object: 524 Tablespace: 15
Traversing INX extent map, anchor 460.
Extent map traversal complete.
INX Object Summary: Total Pages 437 - Used Pages 437
Index phase end.
LOB phase start. Object: 6 Tablespace: 6
Traversing LOB extent map, anchor 44.
Error: In page 19944, physical page 19944 of object 6 in
tablespace 6, pagesize 4096.
Error: Hexadecimal dump of page contents.
0000 *3FD848E9 3DD7CB35 4760D8EB B879CD10*
*..H....5G....y..*
...
0FF0 *D1EFD352 8B3E89D6 02CDA36A F314F127*
*...R.......j....*
Error: Page header invalid revnum value 0.
Error: Page header invalid field begoff value 55359,
expected value 48.
Error: Page header invalid field datlen value 59720,
expected value 4048.
Error: Page header LSN (x06DAAD703BA52B81) is greater than
database current LSN (x0000014556D31436).
Error: Page header invalid field poolPageNumber value
902551357, expected value 19944.
Error: Page header invalid field objectID value 30687,
expected value 6.
Error: Page header invalid field objectType value 216,
expected value 67.
Error: Page header invalid field objectPageNumber value
902551357, expected value 19944.
Error: Page header invalid field tablespaceSeed value
281901496, expected value 6.
Error: Found error type (scan relative page 143740000 EMP
16952012 with entries 1011440027 > max 1000) drtbps.C
dartNextEMPExtent 1983 .
Error: In page 19945, physical page 19945 of object 6 in
tablespace 6, pagesize 4096.
Error: Hexadecimal dump of page contents.
0000 *1D93B0F6 1B36ADB3 BB5C268B E06C32A7*
*.....6.......l2.*
The Pages reported to be having the problem will not be
consistent and may change on each run of the INSPECT command. |
