The access service fields that record transfer statistics.
|
Log Field Data |
Description |
|---|---|
|
Buffer size |
The number of bytes in the transfer statement. |
|
Transfer setup time |
The elapsed time, in seconds, from the time 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 the time 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 the time 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 the time 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. |