Logging database server messages to a file

By default, database server messages are sent to the database server messages window. In addition, you can send the output to a log file using the -o option. The following command sends output to a log file named mydbserver_messages.txt:

dbsrv11 -o mydbserver_messages.txt -c ...

You can control the size of the database server message log file, and specify what you want done when a file reaches its maximum size:

Use the -o option to specify that a database server message log file should be used and to provide a name.
Use the -ot option to specify that a database server message log file should be used and provide a name when you want the previous contents of the file to be deleted before messages are sent to it.
In addition to -o or -ot, use the -on option to specify the size at which the database server message log file is renamed with the extension .old and a new file is started with the original name.
In addition to -o or -ot, use the -os option to specify the size at which a new database server message log file is started with a new name based on the date and a sequential number.

You can specify a separate file where startup errors, fatal errors, and assertions are logged using the -oe 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.

Logging database server messages to a file

See also