The logging information and the various levels of logging recorded in the file SQL_server_<server-id>_<ddmmmyyyy>_<hhmmss>.log are described in the following table for the respective logging option:

Logging Option Logging Level Type of information logged
STATEMENT 
LEVEL 1
 Shows the sql statement and information on these sql operations:
  • Transactions
  • Preparing a SQL statement
  • Describing a SQL statement
  • Opening and closing a SQL statement
  • Return status from the above operations

Prepare, Describe, and Close occur only once for each statement execution.

Level 1 shows the least amount of output data for the log.

 
LEVEL 2
 The same information as that of Level 1 is logged and in addition, information on the SQL operation: executing SQL statement, once for each statement. 
LEVEL 3
 The same information as that of Level 1 is logged 
LEVEL 4
 Information that is logged for Level 1 and additionally the following:

Information on SQL operations like fetching Result Set data from the server, connection time steps including the authentication system

Note: Fetching occurs once for each block of Result Set data sent to the client. The Result Set data clould be sent to the client any number of times.

Level 4 shows the largest amount of output data for the log.
INOUT 
LEVEL 1
 No information is logged 
LEVEL 2
 No information is logged 
LEVEL 3
 Input parameters to a query or statement and output parameters from a query are logged 
LEVEL 4
 The input/output parameters of the display LOB are logged
QUERY_PLAN 
LEVEL 1
 Query and optimized query plan are logged 
LEVEL 2
 The same information as that of Level 1 is logged 
LEVEL 3
 The same information as that of Level 1 is logged 
LEVEL 4
 The same information as that of Level 1 is logged
EXEC 
LEVEL 1
 No logging is done 
LEVEL 2
 No logging is done 
LEVEL 3
 No logging is done 
LEVEL 4
 No logging is done
PRO_TABLESCAN_EVENT 
LEVEL 1
 The details about tables on which table scan was performed 
LEVEL 2
 The same information as that of Level 1 is logged 
LEVEL 3
 The same information as that of Level 1 is logged 
LEVEL 4
 The same information as that of Level 1 is logged
CACHE 
LEVEL 1
 No logging is done 
LEVEL 2
 No logging is done 
LEVEL 3
 No logging is done 
LEVEL 4
 No logging is done
MEMORY 
LEVEL 1
 No logging is done 
LEVEL 2
 No logging is done 
LEVEL 3
 No logging is done 
LEVEL 4
 No logging is done
PROC 
LEVEL 1
 No logging is done 
LEVEL 2
 No logging is done 
LEVEL 3
 No logging is done 
LEVEL 4
 No logging is done
Communication 
LEVEL 1
 No logging is done 
LEVEL 2
 No logging is done 
LEVEL 3
 No logging is done 
LEVEL 4
 No logging is done

For more information on using PRO_SERVER LOG and PRO_CONNECT LOG, see OpenEdge SQL Reference.