Fix of reason code “7” SQLCODE=-668 SQLSTATE=57016

May 17, 2012 in Database

In DB2, you may face this error. This error means that the access to the table is restricted. Do not be worry if you see this error because it may happen after the ALTER TABLE DROP COLUMN statement.

In order to fix this error, you need to run the REORG command as follows:


After running this command, you will be able to access the table.

For more information about the DB2 REORG command check:

6 responses to Fix of reason code “7” SQLCODE=-668 SQLSTATE=57016

  1. Hey,
    Thank you so much.It solved my problem

  2. abc said on June 5, 2012

    db2 “reorg table schema.table”

    SQL2216N SQL error “-668” occurred while reorganizing a database table or its

  3. thanks very very very very you are saviour

  4. Thank you, it helped me a lot.

  5. i have been promoted because of this fix. Thanks!

  6. Thanks! It was helpful.

Skip to toolbar