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
The constraint is as follow
LTER TABLE "NC3 "."ORDER_CONFIG"
ADD CONSTRAINT "ODBDCNFG" FOREIGN KEY
REFERENCES "NC3 "."CONFIG"
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