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

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.

Default

30 seconds

Description

This option resets the default number of seconds for Sybase IQ to wait in a hung state when it is out of disk space. At the end of this time, it 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 some disk space is added.