Troubleshooting data migration from SQL Server to Db2

If you encounter the following error when you migrate data:

SQL0668N Operation not allowed for reason code "1" on table "RICALM.RQRMENT_DECIMAL_EXT". SQLSTATE=57007

Try the following option:

• Verify whether any table is in Integrity Pending No Access State by using the following command:

  SELECT TABNAME, TABSCHEMA, STATUS FROM SYSCAT.TABLES WHERE STATUS ='C' AND TABSCHEMA IN ('CONFIG','RICALM','RIDW','RIODS');

• In case there is any result that is generated, mark those tables with Integrity Checked. Save the following script in setIntegrityChecked.sql file in SQLLIB\BIN folder:

  BEGIN
  FOR v_row AS SELECT TABSCHEMA, TABNAME FROM SYSCAT.TABLES WHERE
  STATUS = 'C' AND TABSCHEMA IN
  ('CONFIG','RICALM','RIDW','RIODS')
  DO
  EXECUTE IMMEDIATE 'SET INTEGRITY FOR '|| TRIM(v_row.TABSCHEMA)
  ||'.'|| TRIM(v_row.TABNAME) || ' IMMEDIATE CHECKED';
  END FOR;
  END@

• Run the following command in Db2 Command Window:

  db2 -td@ -vf C:\IBM\SQLLIB\BIN\setIntegrityChecked.sql