Prev: Problem with DB2_USE_ALTERNATE_PAGE_CLEANING
Next: how to set idle time out
From: Knut Stolze on 14 Sep 2006 05:15
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
First  |  Prev  | 
Pages: 1 2
Prev: Problem with DB2_USE_ALTERNATE_PAGE_CLEANING
Next: how to set idle time out