One possible explanation is that, since you have referential integrity, there are dependent rows on other tables (with delete restrict on their foreign keys) that prevent certain deletions from occurring on this table.
Did you check the db2diag.log file for any error messages?
thanks for your opinion.
now i know the table has some problem. when i copy to another table, the system clue to "the index has some problem".
so i don't know how to do it???i must creat the new table now ??can suggest me other way to solve this prolbem..