• Table statistics

    From Jonathan Ball@21:1/5 to All on Mon Feb 11 12:57:05 2019
    The catalog views SYSTABLESTAT and SYSTABLEINDEXSTAT contain days-used
    columns. The descriptions of them in the database documentation, e.g. for SYSTABLESTAT, reads:

    Maximum number of days any partition or member was used directly
    by an application for native record I/O or SQL operations since
    the last time the usage statistics were reset.

    What causes usage statistics to be reset? I can find a procedure RESET_TABLE_INDEX_STATISTICS that resets them for indexes (and presumably logical files), but how about for the underlying tables? Is there some
    other system activity that would cause a usage statistics reset?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)