title: DB2 - Reclaiming disk space used by dropped tables
body: <p>I have an application that logs to a DB2 database. Each log is stored in a daily table, meaning that I have several tables, one per each day.</p>
  
  <p>Since the application is running for quite some time, I dropped some of the older daily tables, but the disk space was not reclaimed.</p>
  
  <p>I understand this is normal in DB2, so I goggled and found out that the following command can be used to reclaim space:</p>
  
  <pre><code>db2 alter tablespace &lt;table space&gt; reduce max
  </code></pre>
  
  <p>Since the tablespace that store the daily log tables is called <strong>USERSPACE1</strong>, I executed the following command successfully:</p>
  
  <pre><code>db2 alter tablespace userspace1 reduce max
  </code></pre>
  
  <p>Unfortunately the disk space used by DB2 instance is still the same...</p>
  
  <p>I've read somewhere that the <strong>REORG</strong> command can be executed, but what I've seen it is used to reorganize tables. Since I dropped the tables, how can I use <strong>REORG</strong>?</p>
  
  <p>Is there any other way to do this?</p>
  
  <p>Thanks</p>