Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Table in Load Pending state but Terminate command does not work

931 views
Skip to first unread message

mshe...@yahoo.com

unread,
Jul 18, 2008, 3:29:56 PM7/18/08
to
After a failed informatica load session, when I try to select from a
table it shows that the table is in Load Pending state:

>>>>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:

>>>>>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!

0 new messages