Logging properties control whether DB2 access service data is recorded in the server log file. For detailed information about the server log file, see the Enterprise Connect Data Access and Mainframe Connect Server Administration Guide.
Each log entry consists of a number of columns of data, each separated by a tab character. These columns appear in the following order:
Record type
Date/Time
Service Library Name, Service Name, or Server Name
SPID (Server Process ID), the identifier for the current client connection
User ID
Application Name
Specific Information
The server defines the first six columns. However, the Specific Information column contains information specified by the logging properties. Logging properties exist at the server, service library, and service levels.
For detailed information about server properties and the server log file, see the Enterprise Connect Data Access and Mainframe Connect Server Administration Guide.
All statistics properties record some identical types of data. You use these properties independently or in combination to record statistics at whatever level of granularity you need to perform your analysis.
Table 2-1 describes the log statistics properties.
Property name |
Description |
|---|---|
LogRequestStatistics |
A DB2 access service property that records statistics about individual SQL requests. |
LogTransferStatistics |
A DB access service property that records statistics about individual transfer requests. |
LogConnectionStatistics |
A DB2 access service property that records accumulated statistics about requests made by each client connection. Statistics are recorded when the client disconnects. |
LogServiceStatistics |
A DB2 access service property that records accumulated statistics about requests made by all connections to this DB2 access service. |
LogSvclibStatistics |
A DB2 access service library property that records accumulated statistics about requests made by connections to all DB2 access services within this DB2 access service library. |
Statistics are in standard format, tab-delimited columns in the server log file.
Table 2-2 shows the statistics recorded when the LogSvclibStatistics property is turned on.
Log field data |
Description |
|---|---|
Buffer size |
The number of bytes of SQL (after transformation) in the SQL request sent to the database |
Service processing time |
The elapsed time in seconds from when the DB2 access service receives a SQL statement until it sends the statement to the database |
DBMS processing time |
The elapsed time in seconds from when the DB2 access service sends the SQL statement to the database until the database returns the first result row to the client application |
Time to receive rows |
The elapsed time in seconds from when the database sends the first result row to the client application until the client application receives the last result row (in the format ss.nnn) |
Total processing time |
The elapsed time in seconds from when the DB2 access service receives the SQL statement until the client application receives the last result row |
Number of rows returned |
The number of result rows returned to the client application |
Number of conversion errors |
The number of result rows that contain data conversion errors |
Number of kilobytes returned |
The number of kilobytes returned to the client application (to a scale of 3 in the format n.nnn) |
Number of events |
The total number of events that occurred during the time period |
Number of successful connections |
The total number of successful client connections that occurred during the time period |
Maximum number of client connections |
The greatest number of client connections at any given time during the time period |
Table 2-3 shows the statistics recorded when LogConnectionStatistics is turned on.
Log field data |
Description |
|---|---|
Buffer size |
The number of bytes of SQL (after transformation) in the SQL request sent to the database |
Service processing time |
The elapsed time in seconds from when the DB2 access service receives a SQL statement until it sends the statement to the database |
DBMS processing time |
The elapsed time in seconds from when the DB2 access service sends the SQL statement to the database until the database returns the first result row to the client application |
Time to receive rows |
The elapsed time in seconds from when the database sends the first result row to the client application until the client application receives the last result row (in the format ss.nnn) |
Total processing time |
The elapsed time in seconds from when the DB2 access service receives the SQL statement until the client application receives the last result row |
Number of rows returned |
The number of result rows returned to the client application |
Number of conversion errors |
The number of result rows that contain data conversion errors |
Number of kilobytes returned |
The number of kilobytes returned to the client application (to a scale of 3 in the format n.nnn) |
Number of events |
The total number of events that occurred during the time period |
Table 2-4 shows the statistics recorded when LogRequestStatistics is turned on.
Log field data |
Description |
|---|---|
Buffer size |
The number of bytes of SQL (after transformation) in the SQL request sent to the database |
Service processing time |
The elapsed time in seconds from when the DB2 access service receives a SQL statement until it sends the statement to the database |
DBMS processing time |
The elapsed time in seconds from when the DB2 access service sends the SQL statement to the database until the database returns the first result row to the client application |
Time to receive rows |
The elapsed time in seconds from when the database sends the first result row to the client application until the client application receives the last result row (in the format ss.nnn) |
Total processing time |
The elapsed time in seconds from when the DB2 access service receives the SQL statement until the client application receives the last result row |
Number of rows returned |
The number of result rows returned to the client application |
Number of conversion errors |
The number of result rows that contain data conversion errors |
Number of kilobytes returned |
The number of kilobytes returned to the client application (to a scale of 3 in the format n.nnn) |
Command name |
SQL keyword for request, such as select, disconnect, insert |
The subsection heading and the properties must appear in the DB2 access service library configuration file as:
{Logging}
LogConnectionStatistics LogReceivedSQL LogRequestStatistics LogServiceStatistics LogSvclibStatistics LogTargetActivity LogTransferStatistics LogTransformedSQL
