title: Reduce sybase sql anywhere db file size
body: <p>Is it possible, to reduce the size of an sap sql anywhere database file? After a few weeks, our database are around 10GB size, because the database does not reduce the db-size automatically. But in fact, the database only contains 240MB of data. I calculated the db-size like this:</p>
  
  <pre><code>SELECT  sum((((table_page_count * DB_PROPERTY('PageSize')) / 1024) / 1024)) dbsize FROM SYSTAB
  </code></pre>
  
  <p>One way should be, to unload and load the database, but that seems to be very time expensive and is not possible at runtime.</p>
  
  <p>Does anyone has an idea, how to solve this problem?</p>
  
  <p>Thank you!</p>