Configuration: RUNSTATS Settings (DB2 UDB for
UNIX and Windows) 
This function is only available for RFC-monitored systems or if a remote database connection is used to monitor an SAP system.
You can access information on tables with special RUNSTATScharacteristics by calling the DBA Cockpit and choosing Configuration ® RUNSTATS Settings in the navigation frame of the DBA Cockpit.
There are two categories of tables that are treated by the optimizer in a special way due to their characteristics:
· Tables marked as VOLATILE in the system catalog
A volatile table is a table whose content can vary from a few entries to very large amount of entries at lifetime, that is, statistics data is often out-of-date and may result in wrong access plans by the optimizer. These tables should be marked as VOLATILE and should have no statistics at all.
· Tables with RUNSTATS control parameters that are not in accordance with the CCMS standards, for example, special scheduling pattern, different kind of RUNSTATS.
On the basis of the list displayed, you can check system catalog-related information against the DBSTATC control table.
The following information is displayed:
Column |
Description |
Table Schema |
Name of the schema to which the table belongs |
Table Name |
Name of the database table |
VOLATILE |
Indicates whether the table is flagged as VOLATILE in the system catalog or not. If the table is flagged as VOLATILE, statistics are not used by the optimizer. |
Active |
Type of entry in control table DBSTATC. The following entries are displayed: · N No RUNSTATS is run by any CCMS program. This status corresponds to the VOLATILE attribute of a database table, which prevents the query optimizer from using statistics. · R No RUNSTATS is run by any CCMS program, except by using program dmdb6srp and explicitly specifying the table, for example, by the database administrator. · A RUNSTATS may be run by CCMS programs. |
Flagged for RUNSTATS |
Indicates whether the RUNSTATS job in the DBA Planning Calendar (DB13) will select this table for RUNSTATS. |
RUNSTATS Date |
Date of the last RUNSTATS in the system catalog table |
RUNSTATS Time |
Time of the last RUNSTATS in the system catalog table |
Cardinality |
Number of rows as calculated by the last RUNSTATS (–1 indicates that there are no statistics available) |
To receive correct results, the RUNSTATS and REORGCHK for all Tables job should have run at least once.