Specifies whether the DB2 access service records statistics about transfers.
LogTransferStatistics=[no | yes]
no
no means the DB2 access service does not record transfer statistics.
yes means the DB2 access service records statistics about each transfer.
The DB2 access service records transfer statistics as shown in the following table.
Log Field Data |
Description |
|---|---|
Buffer size |
The number of bytes in the transfer statement received by the DB2 access service. |
Transfer setup time |
The elapsed time in seconds from when the DB2 access service receives a transfer statement until it issues the source select against the secondary database. This includes connection time to the secondary database. |
Source DBMS processing time |
The elapsed time in seconds from when the DB2 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. This includes the time the DB2 access service takes to obtain datatype information for target columns. |
Time to transfer rows |
The elapsed time in seconds from when the source database returns the first row to the DB2 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 DB2 access service receives the transfer statement until the last row of the transfer 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. |
Command type |
This is either bulk transfer or template transfer. |
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
