Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    39

    Unanswered: table in check pending(Urgent)

    I was refreshing the DB from production using LOAD utility and got the following error

    QL0104N An unexpected token "nc3" was found following "hecked for
    exception". Expected tokens may include: "IN". SQLSTATE=42601
    bash-2.03$ db2 "set integrity for nc3.ORDER_CONFIG immediate checked force generated"
    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 Check data processing through the SET INTEGRITY statement has found
    integrity violation involving a constraint with name
    "NC3.ORDER_CONFIG.ODBDCNFG". SQLSTATE=23514


    The constraint is as follow
    LTER TABLE "NC3 "."ORDER_CONFIG"
    ADD CONSTRAINT "ODBDCNFG" FOREIGN KEY
    ("ODBID_CONFIG")
    REFERENCES "NC3 "."CONFIG"
    ("ODBID")
    ON DELETE RESTRICT
    ON UPDATE NO ACTION


    I used the load with for exception table1 also ,still my table is in check pending mode
    set integrity is also giving error

    Please help ,Its Urget

  2. #2
    Join Date
    May 2003
    Location
    Toronto
    Posts
    29
    I might not be right, you can have a try following the message:

    It is advisable to execute the SET INTEGRITY statement using the FOR EXCEPTION option when checking the data. The data may be corrected with the information from the exception table(s).

    I did not meet this situation before. I hope you can share your experience once you solve it. Good luck.

  3. #3
    Join Date
    Dec 2003
    Posts
    39
    I used the same and the problem was solved..


    Thanks for ur advice

Posting Permissions

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