InfoSphere CDC Refresh causing SQL0668N
A Refresh operation using InfoSphere CDC uses the LOAD utility and this can put the target tables in SET INTEGRITY PENDING NO ACCESS state. In this case, issue the following command to get the table out of this state:
SET INTEGRITY FOR IMMEDIATE CHECKED
In some cases, the error SQL3608N may result when the above is issued as there could be a dependent table linked via a foreign key which is in no access state. In that case, take the parent table out of this state first. In an extreme case, there may be two tables which are mutually linked by foreign keys to each other and where both go into no access state. In that case, issue the command with both tablenames.
E.g:
set integrity for department, employee immediate checked
SET INTEGRITY FOR
In some cases, the error SQL3608N may result when the above is issued as there could be a dependent table linked via a foreign key which is in no access state. In that case, take the parent table out of this state first. In an extreme case, there may be two tables which are mutually linked by foreign keys to each other and where both go into no access state. In that case, issue the command with both tablenames.
E.g:
set integrity for department, employee immediate checked
Labels: infosphere cdc load db2 sql3608n sql0668n reason code 1

0 Comments:
Post a Comment
<< Home