DB2 LOAD operation failed
Posted on 2013-06-20
One of the tables got in an inaccessible state after I tried to change a column datatype.
The LOAD failed during that change, and I can't do anything now.
If I try to open the table, I get
com.ibm.db.DataException: A database manager error occurred. : [IBM][CLI Driver][DB2/NT64] SQL0668N Operation not allowed for reason code "3" on table "DBO.POSITION". SQLSTATE=57016
goes with no errors, but doesn't change anything
REORG results in
SQL2216N SQL error "-668" occurred while reorganizing a database
table or its indexes.
I am not proficient in DB2, especially in administration, so my research lead me nowhere.
Please tell me what I try - specifically,
because "try to cancel the LOAD job" tells me nothing.
Any help is appreciated.