Specifies whether the access service records statistics about
transfers.
The access service records the transfer statistics shown in
the following table.
Table 2-3: LogTransferStatistics
data
Log Field
Data
|
Description
|
Buffer size
|
The number of bytes in
the transfer statement received by the access
service.
|
Transfer
setup time
|
The elapsed time in seconds
from when the access service receives a transfer statement
until it issues the source select against the
secondary database. This includes connection time to the secondary
database and the time the access service takes to obtain datatype information
for target columns.
|
Source DBMS processing
time
|
The elapsed time in seconds
from when the access service issues the select part
of the transfer statement against the source
database until it receives the first result row from the source
of the transfer.
|
Time to transfer
rows
|
The elapsed time in seconds
from when the source database returns the first row to the access
service until the last row is inserted into the target of the transfer.
|
Total processing
time
|
The elapsed time in seconds
from when the access service receives the transfer statement
until the last row of the transfer data is inserted
into the target database.
|
Number of
rows transferred
|
The number of rows transferred.
|
Number of conversion
errors
|
The number of rows that
contain data conversion errors.
|
Number of
kilobytes returned
|
The total number of kilobytes
transferred (to a scale of 3 in the format n.nnn).
|
Command type
|
The first token (command)
from the SQL buffer. This is always a transfer.
|