Instance Crash
in [DB2]
|
From: Purple-D on 12 Sep 2006 13:31 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..
From: Tomas on 12 Sep 2006 14:17 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..
From: Knut Stolze on 12 Sep 2006 15:42 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
From: Purple-D on 13 Sep 2006 10:56 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
From: Purple-D on 13 Sep 2006 13:01 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
|
Next
|
Last
Pages: 1 2 Prev: Problem with DB2_USE_ALTERNATE_PAGE_CLEANING Next: how to set idle time out |