Logging properties

Logging properties control whether access service data is recorded in the DirectConnect server log file. The log statistics properties record similar types of data. You can use these properties independently or in combination to record statistics.

Table 2-1 describes the logging statistics properties:

**Table 2-1: Logging statistics properties**
Property Name	Description
LogConnectionStatistics	Records accumulated statistics about requests made by each client connection. Statistics are recorded when the client disconnects.
LogRequestStatistics	Records statistics about individual SQL requests.
LogServiceStatistics	Records accumulated statistics about requests made by all connections to this access service.
LogTransferStatistics	Records statistics about individual transfer requests.

Table 2-2 shows the statistics recorded when the LogServiceStatistics property is turned on:

**Table 2-2: LogServiceStatistics data and Log Service statistics**
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:

**Table 2-3: LogConnectionStatistics data and Log Service statistics**
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.

**Table 2-4: LogRequestStatistics data and Log Service statistics**
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.

For information about the server log file, see the Enterprise Connect Data Access and Mainframe Connect Server Administration Guide.

The subsection heading and a list of the properties must appear in the access service library configuration file as shown:

{Logging}
LogConnectionStatistics=
LogReceivedSQL=
LogRequestStatistics=
LogServiceStatistics=
LogTargetActivity=
LogTransferStatistics=
LogTransformedSQL=