Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## SET PRO_SERVER LOG

> Controls logging for all connections to all OpenEdge SQL Servers.

> Syntax

>     SET PRO_SERVER LOG [ ON | OFF ] [ WITH STATEMENT ];

> `ON`

> Indicates that logging is turned on.

> `OFF`

> Indicates that logging is turned off.

> `STATEMENT`

> Indicates that statement tracing information is written to each log file.

> #### Notes

> - When logging is set `ON`, each SQL Server begins logging to a file named as follows:

> `SQL_server_<``server-id``>_<``ddmmmyyyy``>_<``hhmmss``>.``log`

> For example: `SQL_server_1_05MAY2005_112609.log`

> - The `server-id` corresponds to the server ID shown in `database_name``.lg.`

> - Logging files are located in the server’s work directory. The work directory corresponds to the value of the `WRKDIR` environment variable on UNIX systems and the applicable registry settings in Windows systems.

> - The maximum size of each logging file is 500 MB. When `SQL_server_<``server-id``>_<``ddmmmyyyy``>_<``hhmmss``>.log` reaches 500 MB, the server logs a message indicating the file was closed due to reaching the maximum size. After this message is written, all logging stops, logging is set to the `OFF` state, and `SQL_server_<``server-id``>_<``ddmmmyyyy``>_<``hhmmss``>.log` automatically closes.

> - When logging commences to a new file, the file contents begin with information about the SQL Server environment, including:

> - Environment variable settings.
> - Parameter values passed to the server at startup.
> - Logging control values (such as size limits).
> - The SQL Server process ID.
> - Each section of information written to the log file begins with the following string:

> `DDMMMYYYY HH:MM:SS` `<``user-id``>:`

> For example, 19AUG2005 12:00:00 1:

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095