table it shows that the table is in Load Pending state:
1>>>>db2 "select count(*) from TABLE"
-----------
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:
SQL27902N LOAD RESTART/TERMINATE is not allowed on a table that is>>>>>db2 load from /dev/null of del terminate into TABLE
not in
LOAD PENDING state.
Any ideas on what I can do to fix this? Thanks!