IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 1 reply
  • Latest Post - ‏2012-11-13T21:51:26Z by SystemAdmin
SystemAdmin
SystemAdmin
1632 Posts

Pinned topic How to force drop a table?

‏2012-10-05T12:25:15Z |
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

Best Regards,

G.L Hernandez
Updated on 2012-11-13T21:51:26Z at 2012-11-13T21:51:26Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1632 Posts

    Re: How to force drop a table?

    ‏2012-11-13T21:51:26Z  
    Please refer to the explanation to SQLCODE=-950:

    SQL0950N

    The table or index cannot be dropped because it is currently in use.

    Explanation

    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.

    User response

    Close any cursors required and resubmit the statement.