Specifies a maximum size for the database server message log file, at which point the file is renamed.

Syntax

{ dbsrv11 | dbeng11 } -os { size[ k | m | g ] } ...

Applies to

All operating systems and database servers.

Remarks

The size is the maximum file size for logging database server messages, 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.

Before the database server logs output messages to the database server message log file, it checks the current file size. If the log message will make the file size exceed the specified size, the database server renames the database server message log file to yymmddxx.slg, where yymmdd represents the year, month, and day the file was created, and xx is a number that starts at 00 and continues incrementing.

This option allows you to identify old database server message log files that can be deleted to free up disk space.

This option cannot be used with the -on 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.

See also

• Logging database server actions
• -o server option
• -oe server option
• -on server option
• -ot server option