The system table <DATABASE_SYSTEM_ADMINISTRATOR>.SYSCHECKSTATISTICSLOG logs all calls of the database procedure SYSCHECKSTATISTICS.
EXECUTIONSTART |
TIMESTAMP |
Start time of SYSCHECKSTATISTICS call |
EXECUTIONEND |
TIMESTAMP |
End time of SYSCHECKSTATISTICS call |
CALLER |
CHAR(32) |
Name of the user calling SYSCHECKSTATISTICS |
TABLECOUNT |
FIXED(5) |
Number of tables with an entry in the system table SYSUPDSTATWANTED |
RETURNCODE |
FIXED(5) |
Returncode of SYSCHECKSTATISTICS call. |
The database procedure SYSCHECKSTATISTICS checks the growth of all tables owned by the current database user. If the current size of a table differs more than CHANGETHRESHOLD percent from the table size at last update statistics run, the database procedure SYSCHECKSTATISTICS inserts for this table the relevant information into the system table SYSUPDSTATWANTED. If the database procedure SYSCHECKSTATISTICS is called by the database system administrator the described check is performed for all tables in the database system.
Database Administration, SQL Optimizer Statistics
SQL Reference Manual, UPDATE STATISTICS Statement