Home

	Expand Search

Access Service User's Guide DirectConnect

Chapter 2 Configuring the DirectConnect Access Service Library

Access Service Library Logging properties

Access Service Library Logging properties

Access service library logging properties control whether or not data is recorded in the server log file. These properties apply to the access service library as a whole.

The subsection heading for these properties must appear in the service library configuration file as:

{Logging}

General Server log file information

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 DirectConnect Server Administration Guide.

General log statistics information

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 necessary to perform your analysis (see "Access Service Logging properties" ).

The following table describes the log statistics properties.

Statistics are in standard format, tab-delimited columns in the server log file.

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.

Syntax

LogSvclibStatistics=integer

Range

0-2147483646

Default

0

Values

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.

Comments

• 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 clients connections at any given time during the time period.

  The following table shows access service library statistics.

  LogSvclibStatistics 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
  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