I need to drop my table "13SEPTEMBER2011" because when I open it some error is prompting. It happen to me two times the 1st one is on my DB2 v9.7 and now in my DB2 v10.1. They are both been corrupt after I import data file on that table and I don't know why?
I try dropping the table in GUI form but the command doesn't execute and error comes again.
This error always occur every time I open it.
" ALTER TABLE JUSTIN."13SEPTEMBER2011" DROP PRIMARY KEY
The table or index cannot be dropped because it is currently in use.. SQLCODE=-950, SQLSTATE=55006, DRIVER=3.63.108 "
Help to those who know what may solve my problem.
Thank you very much
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
SystemAdmin 110000D4XK1632 Posts
Re: How to force drop a table?2012-11-13T21:51:26ZThis is the accepted answer. This is the accepted answer.Please refer to the explanation to SQLCODE=-950:
The table or index cannot be dropped because it is currently in use.
A DROP TABLE or DROP INDEX statement cannot be issued when an open cursor is currently using the table or index.
The statement cannot be processed. The table or index is not dropped.
Close any cursors required and resubmit the statement.