title: Db2 doesn't allow to update table, throws an error saying that operation is incomplete
body: <p>I'm getting an error when trying to update a table. The SQL statement is:</p>
  <pre><code>UPDATE dda_accounts SET TYPE_SK = TYPE_SK - 10 WHERE TYPE_SK &gt; 9;
  </code></pre>
  <p>The error I get is:</p>
  <pre><code>SQL Error [57007]: Operation not allowed for reason code &quot;7&quot; on table 
     &quot;BANK_0002_TEST.DDA_ACCOUNTS&quot;.. SQLCODE=-668, SQLSTATE=57007, DRIVER=4.27.25
  </code></pre>
  <p>SQLSTATE <code>57007</code> says that there's something incomplete after an ALTER TABLE was executed.</p>
  <p>I found <a href="https://www.ibm.com/mysupport/s/question/0D50z00005pgi6lCAA/why-am-i-seeing-db2-sql-error-sqlcode668-sqlstate57016-or-sqlcode407-sqlstate23502-codes-on-iwd-startup-in-sco-v2301-and-how-do-i-resolve-this?language=en_US" rel="nofollow noreferrer">this resolution</a>, but it's not clear if it can be fixed or the only way to recover the table is using a backup.</p>
  <p>Running a select statement works, only the update fails. What is the way to fix this table?</p>