hi, we are running db2 udb v8.1 on windows, when i try to retrieve a
view's data , i get the error SQL10007N Message "99999" could not be
retrieved. Reason code:
"4". what is message 99999? i know the view is based on the table, so
i do inspect on the table
db2 => inspect check table name oeptoly schema njipd for error state
all results keep results.txt on all dbpartitionnums
the output is
DATABASE: NJIPD
VERSION : SQL08013
2004-04-23-18.04.00.270000
Action: CHECK TABLE
Schema name: NJIPD
Table name: OEPTOLY
Tablespace ID: 4 Object ID: 4
Result file name: results.txt
Table phase start (ID Signed: 4, Unsigned: 4; Tablespace ID: 4) :
NJIPD.OEPTOLY
Data phase start. Object: 4 Tablespace: 4
The index type is 2 for this table.
Traversing DAT extent map, anchor 96.
Extent map traversal complete.
DAT Object Summary: Total Pages 215479 - Used Pages 215479 -
Free Space 12 %
Data phase end.
Index phase start. Object: 4 Tablespace: 4
Traversing INX extent map, anchor 5440.
Extent map traversal complete.
INX Object Summary: Total Pages 268546 - Used Pages 268546
Index phase end.
Table phase end.
Processing has completed. 2004-04-23-18.04.31.710000
looks like there is no error, so i try to sample data from some other
views which is based on the same table, some are working and some
gives me the error, why is that? please help