Specifies whether the access service records statistics about transfers.
LogTransferStatistics=[no | yes]
no
no means the access service does not record transfer statistics.
yes means the access service records transfer statistics.
The access service records the transfer statistics shown in Table 2-5:
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. |
