FORCE_DROP Option
Causes SAP IQ to leak, rather than reclaim, database disk space during a DROP command.
ON, OFF
OFF
Option can be set as a temporary option only, for an individual connection or for the PUBLIC role, for the duration of the current connection.
Requires SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.
You must drop a corrupt 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 SAP Technical Support has instructed you to do so.
FORCE_DROP procedures for system recovery and database repair are described in Administration: Backup, Restore, and Data Recovery.