469,903 Members | 1,887 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

Instance Crash

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

Sep 12 '06 #1
5 5766
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..
Sep 12 '06 #2
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
Sep 12 '06 #3
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
Sep 13 '06 #4
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
Sep 13 '06 #5
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
Sep 14 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Krice | last post: by
8 posts views Thread by Jean-Marc Blaise | last post: by
8 posts views Thread by Lana Zapornikova | last post: by
2 posts views Thread by Mike | last post: by
reply views Thread by db2first | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.