How To Fix DB6607 - Resetting old RUNSTATS check control table entries

DB6607 - Overview

• Message type: E = Error

• Message class: DB6 - DB6: Alert Monitoring and Alert Configuration

• Message number: 607

• Message text: Resetting old RUNSTATS check control table entries

What causes this issue?

For database monitoring, the system fills various tables with temporary
data, which is regularly deleted or reset. This is a check control
table that contains the snapshot data for RUNSTATS. RUNSTATS is
executed for tables selected in DBSTATC.

System Response

This monitor attribute is for informational purposes.

How to fix this error?

If there is an error, use transaction RZ20 to analyse the cause of the
error (monitor set <LS>CCMS Monitor Templates</> -> <LS>Database</>
monitor.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DB6607 - Resetting old RUNSTATS check control table entries ?

  The SAP error message DB6607, which states "Resetting old RUNSTATS check control table entries," typically relates to issues with the database statistics collection process in SAP systems. This message is often associated with the database management system (DBMS) that SAP is using, such as Oracle, DB2, or others.
  
  Cause:
  The error message DB6607 indicates that the system has detected old entries in the RUNSTATS check control table. This can happen due to various reasons, including:
  
  Outdated Statistics: The database statistics may not have been updated for a long time, leading to stale entries.
  Database 
  Configuration Issues: There may be configuration issues in the database that prevent the RUNSTATS process from executing correctly.
  Job Failures: If the scheduled jobs for collecting statistics have failed or been interrupted, it can lead to old entries remaining in the control table.
  Database Maintenance: Regular maintenance tasks may not have been performed, leading to inconsistencies in the statistics.
  
  
  Solution:
  To resolve the DB6607