Instance Crash

[Purple-D]

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..

[Tomas]

What does the db2diag.log say?

You could be encountering a bad page. Try running db2dart or INSPECT
and see if it has something new to tell you.

/T

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..

[Knut Stolze]

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

[Purple-D]

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

[Purple-D]

I fixed the problem...but whats weird is I still dont know what the
problem was...
db2dart for that table was clean ..similiar to INSPECT...so i simply
dumped the data out into a flat file using db2dart...and loaded it into
another table..and dropped the offending table....life is good...for
now..!

Purple-D wrote:

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

[Knut Stolze]

Purple-D wrote:

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 ?

Yeah: call IBM support.

Even if you can work-around the problem (as your other post suggests), there
won't be any guarantee that you don't hit the trap again. Let the DB2
developers investigate this issue and - if necessary - fix it.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany