title: Unable to drop index on a db2 table
body: <p>I have a table MAIN_SCHEMA.TEST in which I created a Index on a column CHECK_ID.
  CHECK_ID is also a FOREIGN_KEY constraint in TEST table.</p>
  <p>This table contains only 50 records.</p>
  <p>By Mistake the index got created in Default schema DEFAULT_SCHEMA.CHECK_ID_IDX.</p>
  <p>CREATE INDEX DEFAULT_SCHEMA.CHECK_ID_IDX(CHECK_ID ASC);</p>
  <p>So I am trying to drop this index but the drop query gets stuck for long time.</p>
  <p>DROP INDEX DEFAULT_SCHEMA.CHECK_ID_IDX.</p>
  <p>there are no locks on this table when I checked.</p>