The system table SYSINFO.COMMANDCACHESTATISTICSRESET contains the statistical information collected about the command cache activities since the last RESET COMMANDCACHESTATISTICS or RESET ALL. The command cache contains the SQL statements and their execution plans shared by different database sessions (the following refers to the SQL statement and execution plan collectively as a command).
RESETDATE |
TIMESTAMP |
Time of the last RESET for these entries |
USABLESIZE |
FIXED(10) |
Size of the command cache (KB) |
MAXUSEDSIZE |
FIXED(10) |
Maximum used area of the command cache (KB) |
MAXUSEDSIZEPERCENTAGE |
FIXED(3) |
Maximum used area of the command cache (%) |
MAXCOMMANDCOUNT |
FIXED(10) |
Maximum number of stored commands |
INSERTCOMMANDCOUNT |
FIXED(10) |
Number of inserts |
DELETECOMMANDCOUNT |
FIXED(10) |
Number of deletions |
FAILEDALLOCATECOUNT |
FIXED(10) |
Number of memory requests not fulfilled |
CLEANUPCOUNT |
FIXED(10) |
Number of operations that encountered a lack of space in the main memory |
CLEANUPCOMMANDCOUNT |
FIXED(10) |
Number of commands modified due to lack of space in the main memory |
INVALIDATECOUNT |
FIXED(10) |
Number of data definition statements that made execution plans invalid |
UNLOADSTATEMENTCOUNT |
FIXED(10) |
Number of SQL statements displaced to disk |
RELOADSTATEMENTCOUNT |
FIXED(10) |
Number of SQL statements reloaded to the main memory |
DELETEPLANCOUNT |
FIXED(10) |
Number of execution plans deleted due to lack of space in the main memory |
MAXUSEDHASHTABLESLOTCOUNT |
FIXED(5) |
Maximum number of used slots in the hash table |
MAXHASHTABLECHAINENTRYCOUNT |
FIXED(5) |
Maximum length of the hash entry overflow chains |