| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Access Service User's Guide DirectConnect for AS/400 |
![[-]](/dwicons/i_colpse.gif)
| Chapter 2 Configuring the DirectConnect Access Service Library |
|
| Access service library Logging properties |
|
| LogSvclibStatistics |
Specifies how often the access service library records accumulated statistics about requests made by connections to all access services associated with this access service library during the reporting interval.
LogSvclibStatistics=integer
0-2147483646
0
integer is a number of seconds.
A value of 0 specifies that the access service library does not record statistics in the server log file.
If you enable both LogSvclibStatistics (service library-level) and LogServiceStatistics (service-level) properties, we recommend that you set the LogSvclibStatistics property to the same property value as the LogServiceStatistics or a multiple thereof. For example, if you configure LogSvclibStatistics for 60 seconds, you would configure LogServiceStatistics for either 60, 120, 180 seconds and so on. If you use DirectConnect Manager to change these two property values, set the LogSvclibStatistics property last for better synchronization.
You use this property to:
Monitor load on the entire access service library
Monitor load on the target database through this DirectConnect Server
If the LogSvclibStatistics property value is greater than 0, the access service library records totals of the statistics for all access services in the access service library.
For example, if an access service library contains access services named Service A and Service B, the data recorded for the maximum number of client connections would contain the total of the Service A maximum number of client connections plus the Service B maximum number of client connections at any given time during the time period.
The following table shows access service library 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 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) |
Number of rows returned | The number of result rows returned to the client application |
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 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 |
|
|