Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008

    Unanswered: DB2 9.5 - Drop indexes + tablespaces SMS = pages not reducing


    I am using DB2 v9.5, the database is not automatic storage and table spaces are all SMS (I know that SMS is not the best practice, but I'm studying to perform the migration then).

    I dropped a total of 144 indexes, which were not used, but the amount of pages used/allocated in the database did not change after the DROP INDEX.

    As far as I remember, for SMS tablespaces, if DROP of objects (tables or indexes), REORGs not be necessary, unless you had just deleted rows from the table, where it would be necessary to run the REORG to reduce the size allocated for the table .

    Some opnion of what can be done to actually free the space from the indexes that were dropped?


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    I think if you reorg the indexes for the tables, you should get the space back.


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts