A message log file exists for each database. The default name of this file is dbname.iqmsg. The message log file is actually created when the database is started for the first time after creation of that database.
By default, 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 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 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.