Technical Blog Post
Abstract
75 ways to demystify DB2: #6: Tech Tip: Inplace reorg fails with SQL2216N SQL error "-668".
Body
When you alter a table to drop a column, the table must be reorganized before an update, insert, or delete operation or an index scan can be performed on the table. After the column is successfully dropped, the table is placed in a reorg pending state. When you attempt to execute the REORG with INPLACE option, DB2 will through SQL2216N SQL error "-668". The error means :
SQL2216N SQL error "-668" occurred while reorganizing a database table or its indexes.
If a table is in a reorg pending state, inplace reorg is not allowed. Instead use the offline reorg option to the table.
Reference:
===========
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001966.html?cp=SSEPGG_9.7.0%2F3-6-2-4-96
UID
ibm11141252