Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

How to remove the table from set integrity pending state in db2 after load

Avatar of partminer
partminer asked on
DB2Windows OS
21 Comments1 Solution4976 ViewsLast Modified:

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
"tableA".  SQLSTATE=57016

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.
Avatar of gmarino

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 21 Comments.
See Answers