SET PRO_SERVER LOG

Controls logging for all connections to all OpenEdge SQL Servers.

Syntax

SET PRO_SERVER LOG [ ON | OFF ]
[ WITH ({ STATEMENT, INOUT, QUERY_PLAN })]
[[AND] WITH LEVEL 1|LEVEL 2|LEVEL 3|LEVEL 4];

Parameters

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.

QUERY_PLAN

Indicates that query plan information is written to the log file.

INOUT

Logs information to the output server log about the following:

Input LOB data and LOB locator information

Output LOB data

Output parameters for statements like the select list for the SELECT statement

Log Level

The level of detail in the log entry depends on the level of logging that is chosen. Level 1 logs the most basic and most important information. Level 2 adds more details, and Level 3 adds still more details. Level 4 adds detailed information about connection events, when the client connects to SQL and to the database.

Notes

When logging is set ON, each SQL Server begins logging to a file named as 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 created in the location from where you execute the proserve command.

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 string

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

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