NOTIFY_MODULUS option

Function

Controls the default frequency of notify messages issued by certain commands.

Allowed values

Any integer

Default

100000

Scope

DBA permissions are not required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.

Description

This option sets the default number of notify messages Sybase IQ issues for certain commands that produce them. The NOTIFY clause for some of the commands (such as CREATE INDEX, LOAD TABLE, and DELETE) override this value. Other commands that do not support the NOTIFY clause (such as SYNCHRONIZE JOIN INDEX) always use this value. The default does not restrict the number of messages you can receive.