In one of our current projects we are using derby and have some large db tables (over 20 Million rows and some indexes).
We decided to clean this table with a scheduled task. Now to be able to free some disk space we want to compress the files using SYSCS_COMPRESS_TABLE. What would be the best option to use this function and keep the table lock as short as possible? Our app needs to keep running while the compression is taking place.
Do you have any suggestions?