OUT_OF_DISK_WAIT_TIME option

Function

Controls the default interval time to wait before checking again when out of disk space.

Allowed values

Any integer

Default

30 seconds

Scope

Can be set only for the PUBLIC group. DBA authority is required to set the option. You must shut down and restart the database server for the change to take effect.

Description

OUT_OF_DISK_WAIT_TIME resets the default number of seconds Sybase IQ should wait in a sleep state when it is out of disk space. At the end of this time, Sybase IQ checks to see if any space has been added. If none has been added, it returns to a sleep state and waits before checking again. It repeats this process until disk space is added.