Chapter 2: Configuring the Access Service Library for DirectConnect
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.
The following table 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.
|
LogSvclibStatistics
|
Records accumulated statistics
about requests made by connections to all access services within
this access service library.
|
LogTransferStatistics
|
Records statistics about
individual transfer requests.
|
The following table shows the statistics recorded by the LogConnectionStatistics, LogRequestStatistics,
and LogSvclibStatistics properties.
Table 2-2: Logging statistics data
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 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 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 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 (LogSvclibStatistics and LogConnectionStatistics only)
|
Number of
successful connections
|
The total number of successful
client connections that occurred during the time period (LogSvclibStatistics only)
|
Maximum number
of client connections
|
The greatest number of
client connections at any given time during the time period (LogSvclibStatistics only)
|
Command type
|
The first command (token)
from the SQL buffer (LogRequestStatistics only)
|
For information about the server
log file, see the ECDA and Mainframe Connect Server Administration
Guide for DirectConnect.
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=
LogSvclibStatistics=
LogTargetActivity=
LogTransferStatistics=
LogTransformedSQL=
|
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF 