-on iqsrv16 database server option

Specifies a maximum size for the database server message log, after which the file is renamed with the extension .old and a new file is started.

Syntax

iqsrv16 -on { size[ k | m | g ] } ...

Applies to

All operating systems and database servers.

Remarks

The size is the maximum file size for the database server message log, in bytes. Use k, m, or g to specify units of kilobytes, megabytes, or gigabytes respectively. The minimum size limit is 10 KB. By default, there is no maximum size limit.

When the database server message log reaches the specified size, the database server renames the file with the extension .old, and starts a new file with the original name.

Note: If the .old database server message log file already exists, it is overwritten. To avoid losing old database server message log files, use the -os option instead.

This option cannot be used with the -os option.

It is recommended that you do not end the database server message log file name with .log because this can create problems for utilities that perform operations using the transaction log.