How To Fix DB6126 - Vergangene Zeit seit der letzten Aktualisierung der Tabellenstatistiken

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 126

• Message text: Vergangene Zeit seit der letzten Aktualisierung der Tabellenstatistiken

Was verursacht dieses Problem?

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.

Systemantwort

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.

Wie behebe ich diesen Fehler?

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.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE