Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2016
    Posts
    2

    Question Unanswered: Set Intigrity Pending.

    I need suggestion on this.


    -bash-4.1$ db2 "SET INTEGRITY FOR DIFOT.DIFOT_MISS_CHANGES IMMEDIATE CHECKED FORCE GENERATED NOT INCREMENTAL"
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL3603N Integrity processing through the SET INTEGRITY statement has found
    an integrity violation involving a constraint, a unique index, a generated
    column, or an index over an XML column. The associated object is identified by
    "DIFOT.DIFOT_MISS_CHANGES.DFT_MS_CHG_FK1". SQLSTATE=23514

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Code:
    SQL3603N  Integrity processing through the SET INTEGRITY statement has
          found an integrity violation involving a constraint, a unique
          index, a generated column, or an index over an XML column. The
          associated object is identified by "<name>".
    
    Explanation:
    
    A row has been found to violate the integrity of a table checked by the
    SET INTEGRITY statement. The integrity violation was caused by one of
    the following.
    
    *  A table constraint was violated. The table constraint is identified
       by "<name>".
    *  A unique index was violated. The unique index is identified by
       "<name>".
    *  The column value of a generated column does not match the result of
       the generation expression. The generated column is identified by
       "<name>".
    *  The table contains an index over an XML column that had an integrity
       violation. The XML column is identified by "<name>".
    
    The row has not been deleted from the table. The table remains in Set
    Integrity Pending state.
    
    User response:
    
    Execute the SET INTEGRITY statement again using the FOR EXCEPTION option
    and use the information from the exception tables to correct the data.
    Andy

  3. #3
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    Yep, as Andy pointed out ... the first stop is the doco.
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •