SIGN UP MEMBER LOGIN:
   
  • Home
  • »
  • DB2
  • »
  • SQL0668N Opertation not allowed for Reason Code "7" on table table_name SQLSTATE=57016
AuthorQuestion
SQL0668N Opertation not allowed for Reason Code "7" on table table_name SQLSTATE=57016
Posted on: 26 Apr 2011
I got this error while trying to insert data in a table. I didn't get such messages before. Also, I have checked my query many times and don't found any problem with it.

Please someone help .......

Thanks !!!

AuthorReply
Deepak Kumar
  • 34
  • 0
accepted
Re: SQL0668N Opertation not allowed for Reason Code "7" on table table_name SQLSTATE=57016
Posted on: 26 Apr 2011   Accepted Answer
Hi Legolas,

       You are trying to insert data in a table which is in the reorg pending state. It means you might altered your table and forgot to Reorganise the table.

Execute the following command in the DB2 Command Window to Reorganise the table :

DB2 REORG TABLE table_name

I hope this will work ......

:) havE a nicE daY

Re: SQL0668N Opertation not allowed for Reason Code "7" on table table_name SQLSTATE=57016
Posted on: 26 Apr 2011  
It works ..... thanks a lot