View Single Post
  #1 (permalink)  
Old 06-15-10, 06:14
aankdavid aankdavid is offline
Registered User
 
Join Date: Apr 2010
Posts: 5
SQL0668N Operation not allowed for reason code "x" on table

When you loading all database with db2move command, propably most of the tables being loaded are in pending state. To check which ones, execute SQL statement:

SELECT tabname,status,const_checked FROM syscat.tables WHERE status='C'

This command will list all tables in pending state


Reson code:

* "1" - table is in pending state - to fix this execute

SET INTEGRITY FOR table_name IMMEDIATE CHECKED

* "3" - previous load operation on this table failed. You have to terminate or restart previous load command
Reply With Quote