DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016

Standard

After some manipulation with table I have faced the exception DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, the description of one does not explain properly the reason of problem and solution for it. It appeared after changing a table structure,in my case, the new column with some constrain was added .

Solution:
Execute the sql query. The parameter has to be the name of table that was changed.
REORG TABLE <NAME OF TABLE>

About these ads

7 thoughts on “DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016

  1. After running above command I got below error :-

    SQL2216N SQL error “-668″ occurred while reorganizing a database table or its
    indexes.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s