COMMANDSTATISTICSRESET 
The system table SYSINFO.COMMANDSTATISTICSRESET describes SQL statements that are stored in the command cache, and also contains statistical information on the activities of these SQL statements collected since the last RESET COMMANDSTATISTICS or RESET ALL. The command cache contains the SQL statements and their execution plans shared by different database sessions.
Structure
RESETDATE |
TIMESTAMP |
Time of the last RESET for these entries |
COMMANDID |
CHAR(8) BYTE |
Identification of the SQL statement |
PREPARECOUNT |
FIXED(10) |
Number of execution preparations |
EXECUTECOUNT |
FIXED(10) |
Number of executions |
EXECUTETIME |
FIXED(20) |
Total duration of executions (µs) |
AVGEXECUTETIME |
FIXED(20) |
Average execution time (µs) |
MINEXECUTETIME |
FIXED(20) |
Minimum execution time (µs) |
MAXEXECUTETIME |
FIXED(20) |
Maximum execution time (µs) |
READROWCOUNT |
FIXED(20) |
Number of rows read |
QUALIFIEDROWCOUNT |
FIXED(20) |
Number of qualified rows |
VIRTUALREADCOUNT |
FIXED(20) |
Number of reads in the data cache |
PHYSICALREADCOUNT |
FIXED(20) |
Number of reads in the data cache that triggered reads on the disk |
FETCHROWCOUNT |
FIXED(20) |
Number of rows (in the result tables generated by the SQL statement) sent to the application |
SUSPENDCOUNT |
FIXED(20) |
Number of suspends |
WAITCOUNT |
FIXED(20) |
Number of waits caused by lock collisions |
READAHEADREQUESTCOUNT |
FIXED(20) |
Number of read ahead requests |
READAHEADIGNOREREQUESTCOUNT |
FIXED(20) |
Number of ignored read ahead requests |
READAHEADPHYSICALREADPAGECOUNT |
FIXED(20) |
Number of pages read via read ahead |