-iqmsgsz iqsrv15 Server Option

Limits the maximum size of the message log.

Syntax

-iqmsgsz size

Remarks

-iqmsgsz is an integer 0-2047 (inclusive), in MB. The default value is 0, which specifies that there is no limit on message log size. The IQMsgMaxSize server property corresponds to the -iqmsgsz server switch and takes precedence over the value of -iqmsgsz.

A -iqmsgsz value n greater than 0 means that the message log can grow up to n megabytes in size. For example, the following command limits the size of the message log to 100MB:

start_iq -n iqdemo iqdemo.db ... <other options> ... -iqmsgsz 100

See Reference: Building Blocks, Tables, and Procedures > System Procedures > Catalog Stored Procedures > sa_server_option System ProcedureReference: Building Blocks, Tables, and Procedures > System Procedures > sa_server_option system procedure.

See System Administration Guide: Volume 1 > Overview of Sybase IQ System Administration > Message Log Contents.