SQL0668N Operation not allowed for reason code "3" on table db2admin.sample. SQLSTATE=57016

[mnsu...@gmail.com]

Hi
i was trying to load wrong data into a table. so i terminated the transaction forcefully by pressing ctrl+c in CLP. after this when i try to access the table, i'm getting the following error
"SQL0668N Operation not allowed for reason code "3" on table db2admin.sample. SQLSTATE=57016"
i tried with SET INTEGRITY for SAMPLE IMMEDIATE CHECKED command. but it returns that the table is not in pending state.
Now what can be done to access the table? i do not have the back of the data.
Thanks in advance
Sued

[Larry]

mnsu...@gmail.com wrote:

Please post the exact error msg you receive including the message number
... and exactly what you are trying to do when you receive it (i.e.
commands, etc.).

Larry Edelstein

[mnsu...@gmail.com]

hi
i have already posted the exact error message in the topic title itself. that was what i got. i got this error when i was trying to do a select query after force terminating the previous process

[Serge Boivin]

I don't know if this will help, but reason code 3 is:
3
The table is in the Load Pending state. A previous LOAD attempt on
this table resulted in failure. No access to the table is allowed until
the LOAD operation is restarted or terminated.

The suggested response is:
3
Restart or terminate the previously failed LOAD operation on this
table by issuing LOAD with the RESTART or TERMINATE option respectively.

[samog...@yahoo.com]

Hi,

Granted a unique index & Primary key aren't allowed while creating a so-called replicated 'MQT'- Table. Well I treid to create just an index on the MQT & got this :

SQL0668N Operation not allowed for reason code "1" on table "REP.S_TW1950_B".

SQLSTATE=57016

Any clues?

[samog...@yahoo.com]

Hi,

do a

1. db2 connect to ;

2. db2 list tablespaces show detail, then

3. re-issue the "SET INTEGRITY for SAMPLE IMMEDIATE CHECKED" command

If

above== Fail

do

Full a Image copy and/or Backup DB-Object (in this case yr.Table).., then

A. Re-try nr 3. above

and/or

remove whatever indexes and Load with a No Logging option

..(depending on yr environment)

Else

take a break and start a fresh.

It worked for me - couple o' hrs ago!

So, Gd. Luck!

Sam