I inspect the table and indexes...everything looks fine...but just to
be sure...i drop any existing indexes...
But still it crashes when i try to do select * ...
I then tried to reorg the table to see if moving the data round
helps..and this is what I got..
db2 reorg table tablename
SQL2216N SQL error "-1224" occurred while reorganizing a database
table or
its indexes.
Any insight on this ?
Knut Stolze wrote:
Purple-D wrote:
we have a weird issue..
When we try to do select count(*) from a table..say tab_a.. we get
back the count.
but the moment we try to do "select * from tab_a" ...the instance
crashes and has to be restarted...
The tablespace and table states are normal and count is very small
.(i.e. 150 recs) ..also there are no long or lob columns in that
table..
Tablespace has lots of space..so definately no space or memory issues..
This is on a db2 luw v8.1 fp 10. running on linux...
Any clues as to why this is happening..
DB2 should never ever crash. Period. So if you have a DB2 crash, there is
only one thing to do: call IBM support.
p.s: Possible exceptions are if you deliberately kill DB2 processes or use
external routines that are buggy.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany