When I try to load the data into TableA using the below syntax
load from "H:\tab282.ixf" of ixf modified by generatedoverride insert into TableA nonrecoverable" it failed with the following error.
SQL2038N .A database system error "SQLUIIGN" occured during processing.
SQL0289N unable to locate new pages in table space "TABLESPACE_TS"
After that I try to run the set integrity command but i am getting another error.
set integrity for tableA immediate checked;
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0668N Operation not allowed for reason code "3" on table
SQL0668N Operation not allowed for reason code "3" on table "TABLEA ".
1.Can you please help me how to come out of above situation.
2.If I am not sure of the exact problem how to find out effected tables after load operation or set integrity pending state tables?
Thank in advance.