database repair (remove empty pages)

[#1]

I know that in Microsoft Access there is a mechanism called Repair Database, which as result optimizes the performance and the size of the database.

Is there any similar mechanism in SQL Anywhere?

We have currently problems of database size (some gigabytes), and we know that the actual data is not that big, but the most of size is 'debris' remaining from INSERT and DELETE

[VolkerBarth]

You can use dbinfo or various system procedures to check for free pages, and you can use reorganize table for a running database or a complete reload to minimize size. There are many FAQ here related to this topic.

Aside: Having used MS Access as a database in former times, I would really refrain from comparing it and its "repair mode" to a "real" database system like SQL Anywhere...

[Baron]

Thanks for the comment.

What you mean exactly with Reload? Do you mean Unload + Load into a new empty database?

[VolkerBarth]

Yes. That's the only way to reduce the database size.

[Baron]

This process we do sometimes.

But this process does not always result a new product DB which can functionally replace the original one!

An example is a DB with SQL Remote, or even with Mobilink!

[VolkerBarth]

You certainly CAN reload databases for SR or ML - you just have to do this as required, see the docs - it's easiest via dbunload -ar directory...