IBM Support

75 ways to demystify DB2: #6: Tech Tip: Inplace reorg fails with SQL2216N SQL error "-668".

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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm11141252

Page Feedback