Limit the size of the message log to conserve disk space.
Sybase IQ logs all messages in the message log file, including error, status, and insert notification messages. You can turn off notification messages using parameters in the LOAD and INSERT statements.
At some sites the message log file tends to grow rapidly, due to the number of insertions, LOAD option and low NOTIFY_MODULUS database option settings, or certain other conditions. Sybase IQ lets you limit the size of this file by wrapping the message log or by setting a maximum file size and archiving log files when the active Sybase IQ message log is full.
For information on setting the maximum log file size, archiving message log files, and enabling message log wrapping, see “Message logging” in System Administration Guide: Volume 1 > Overview of Sybase IQ System Administration.