The statistics recorded when LogRequestStatistics is set to on.
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 the time the DB2 access service receives a SQL statement until it sends the statement to the database |
DBMS processing time |
The elapsed time, in seconds, from the time the DB2 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 the time 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 the time the DB2 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). |
Command name |
SQL keyword for request, such as select, disconnect, and insert. |