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=3D57016
But then when I try to take it out of load pending state by running a
=93terminate into=94 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!
