DB2 10.5 on Windows
Here is another strange one. I needed to load a large text file so I created a table and started the Load procedure when the server got rebooted (automatic window update). The database came up ok after the reboot but now I can't drop the table I was loading into. The table is empty. I get this error.
ERROR  [IBM][DB2/NT64] SQL0290N Table space access is not allowed.
So I google this and it is normally linked to one of these.
1. Database crash and recovery
2. Table is in load pending state
3. Tablespace is in not normal state
Well, none of these apply to me. The database came back fine. I can run queries and do everything just fine. The table is not in load pending state. And the tablespace is in a normal state. Other tables in this tablespace are acting normally. It is just this one table.
I can select from the table but that is it. I can't insert, or reorg or drop. I just want to drop it.