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

Tue Jul 17, 2012 12:24 am

This is a DB2error :Fix of reason code “7″ SQLCODE=-668 SQLSTATE=57016 , happens when access to a table is restricted. You face while you are running SQL query like :

Code:: ALTER TABLE DROP COLUMN

To fix this issue you can run the following command to remove the restriction :

Code:: REORG TABLE [TABLE_NAME]

For more information about REORG command please see the link below :

Code:: http://publib.boulder.ibm.com/infocenter/db2e/v9r1/index.jsp?topic=%2Fcom.ibm.db2e.doc%2Fsqlreorgt.html