Table in Load Pending state but Terminate command does not work

Question posted by: msheikh25@yahoo.com (Guest) on July 18th, 2008 07:35 PM

After a failed informatica load session, when I try to select from a
table it shows that the table is in Load Pending state:

Quote: Originally Posted by Quote: Originally Posted by Quote: Originally Posted by >>>>db2 "select count(*) from TABLE"

1
-----------
SQL0668N Operation not allowed for reason code "3" on table "TABLE".
SQLSTATE=57016


But then when I try to take it out of load pending state by running a
“terminate into” command, I get an error saying cannot run command on
table that is NOT in load pending state:

Quote: Originally Posted by Quote: Originally Posted by Quote: Originally Posted by >>>>>db2 load from /dev/null of del terminate into TABLE

SQL27902N LOAD RESTART/TERMINATE is not allowed on a table that is
not in
LOAD PENDING state.


Any ideas on what I can do to fix this? Thanks!

Not the answer you were looking for? Post your question . . .
182,081 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).