How To Fix DB6128 - The table statistics are no longer current

DB6128 - Overview

• Message type: E = Error

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

• Message number: 128

• Message text: The table statistics are no longer current

Copy of DB6 126

What causes this issue?

Among other things, statistical information about tables (size,
distribution of values, and so on) is stored in the database system
tables (system catalog). The optimizer then analyzes this informaiton
when creating access plans for SQL statements.
For tables with variable datasets (transaction data), this statistical
information must be regularly adjusted.

System Response

The better these statistics, the better the optimizer can create plans.
Conversely, obsolete data or statistics that are missing completely can
cause poor access plans and therefore poor performance.

How to fix this error?

Maintain the table statistics with the help of the predefined actions
in the DB13 planning calendar. You can find more information about this
topic in the online documentation for the planning calendar. In the
special case of a BW system, there is a special report:
SAP_ANALYZE_ALL_INFOCUBES. This produces distributed statistics.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DB6128 - The table statistics are no longer current ?

  The SAP error message DB6128 indicates that the table statistics for a specific database table are outdated or no longer current. This can lead to suboptimal query performance because the database optimizer relies on accurate statistics to determine the most efficient way to execute queries.
  
  Cause:
  The statistics for a table can become outdated due to several reasons:
  
  Data Changes: Significant changes in the data, such as bulk inserts, updates, or deletes, can render existing statistics inaccurate.
  Time: Over time, as data is modified, the statistics may no longer reflect the current state of the data.
  Database Maintenance: Certain maintenance operations, like reorganizing or rebuilding indexes, can also affect the accuracy of statistics.
  
  
  Solution:
  To resolve the DB6128 error, you need to update the table statistics. Here are the steps to do this:
  
  
  Use SAP Transaction Code:
  
  You can use transaction code DBACOCKPIT or ST04 to access the database performance monitoring tools.
  Navigate to the relevant section for updating statistics.
  
  
  
  Run