Causes Sybase IQ to leak, rather than reclaim, database disk space during a DROP command.
ON, OFF
OFF
Requires DBA permissions to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.
You must drop a corrupt index, join index, column or table and set the FORCE_DROP option to ON. This prevents the free list from being incorrectly updated from incorrect or suspect file space allocation information in the object being dropped. After dropping corrupt objects, you can reclaim the file space using the -iqfrec and -iqdroplks server switches.
When force dropping objects, you must ensure that only the DBA is connected to the database. The server must be restarted immediately after a force drop.
Do not attempt to force drop objects unless Sybase Technical Support has instructed you to do so.
For important information on using the FORCE_DROP option, see Chapter 13, “System Recovery and Database Repair”in the System Administration Guide: Volume 1.
