A message log file exists for each database. The default name of this file is dbname.iqmsg, although you can specify a different name when you create the database. The message log file is actually created when the first user connects to a 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 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.
When you enable message log wrapping, as soon as the file reaches the maximum size specified in the IQMSG_LENGTH_MB database option, new messages are written starting at the beginning of the file. Existing messages are overwritten, line-by-line.
When wrapping is enabled, the tag <next
msg insertion place> tells you where new messages
are being placed. Additional tags at the beginning and end of the
file remind you that log wrapping is enabled, and that the last
message in the file may not be the most recent one.
To enable message log wrapping and set the maximum log file size, see “IQMSG_LENGTH_MB option” in Sybase IQ Reference Manual.
