-o server option

Prints all database server messages to the database server message log file.

Syntax
{ dbsrv11 | dbeng11 } -o filename ...
Applies to

All operating systems and database servers.

Remarks

Print all database server messages, including informational messages, errors, warnings, and MESSAGE statement output, to the specified file, as well as to the database server messages window. If you specify the -qi option with -o, all messages appear only in the database server message log file.

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

You can obtain the name of the database server message log file by executing the following command:

SELECT PROPERTY ( 'ConsoleLogFile' );
See also