Manage the size of the transaction and message logs to conserve disk space.
The transaction log file contains recovery and auditing information. Place the transaction log on a separate device or partition from the database itself to avoid database file fragmentation and to protect against media failure.
The transaction log can consume a large amount of disk space over time. Truncate the transaction log periodically to conserve disk space.
SAP Sybase IQ logs all messages in the message log file, including error, status, and insert notification messages. Limit the size of this file to conserve disk space.
Set a maximum file size and archive the log files when the active message log is full
Increase NOTIFY_MODULUS database option setting
Use the NOTIFY parameter to turn off notification messages in LOAD TABLE. INSERT, and CREATE INDEX statements
Use -iqmsgsz switch to limit the size of the message log
Utility Guide > start_iq Database Server Startup Utility > start_iq Server Options > -iqmsgsz iqsrv16 Server Option
Utility Guide > start_iq Database Server Startup Utility > start_iq Server Options > -m iqsrv16 Server Option
Reference: Statements and Options > Database Options > Alphabetical List of Options > NOTIFY_MODULUS Option
Reference: Statements and Options > SQL Statements > CREATE INDEX Statement
Reference: Statements and Options > SQL Statements > INSERT Statement
Reference: Statements and Options > SQL Statements > LOAD Statement