OUT_OF_DISK_MESSAGE_REPEAT option

Function

Controls the interval time between out of disk space messages.

Allowed values

Any integer

Default

120

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_MESSAGE_REPEAT resets the default amount of time at which Sybase IQ should repeat the cycle of checking and then issuing an out-of-space message. To determine this length of time, multiply this option value with the value for OUT_OF_DISK_WAIT_TIME. For example, using the defaults of 120 for OUT_OF_DISK_MESSAGE_REPEAT and 30 seconds for OUT_OF_DISK_WAIT_TIME, Sybase IQ would issue an out-of-space message every hour.