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: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-11-13T21:51:26Z by SystemAdmin
Pinned topic How to force drop a table?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-13T21:51:26Z at 2012-11-13T21:51:26Z by SystemAdmin
SystemAdmin 110000D4XK1632 PostsACCEPTED ANSWER
Re: How to force drop a table?2012-11-13T21:51:26Z in response to SystemAdminPlease 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.