How To Fix HH076 - La última ejecución de estadísticas de actualización es antigua

SAP Error Message - Details

• Message type: E = Error

• Message class: HH - (Long) text for check tool 'infcfgcheck'

• Message number: 076

• Message text: La última ejecución de estadísticas de actualización es antigua

¿Qué causa este problema?

The last update statistics session occurred quite a long time ago.
Determine when the last session run by analyzing the SAPDBA log table
DBSTATTINF (maximum value in field LUPDSTAT).
You have either forgotten to schedule regular update statistics
sessions (Planning Calendar in Transaction DB13 or 'cronjob'), or the
scheduled interval is too large.
Only regularly executed update statistics sessions (for all tables)
can ensure that the Informix cost-based optimizer makes the correct
decisions (index instead of 'Seq. Scan',
which index, and so on).

Respuesta del sistema

¿Cómo arreglar este error?

Call Transaction DB13 (Planning Calendar) and schedule regular complete
update statistics sessions. We recommend a weekly update statistics
(for all tables) with a threshold of '10' (default value). The sessions
should run when system activity is as low as possible (for example,
during the night on the weekend).
A threshold greater than 0% insures that all tables are not processed
(-> long update statistics runtime). Instead, the system only processes
those tables whose number of records has grown or shrunk by the
specified percentage since the last update statistics session.

Extracto de mensaje de error del sistema SAP. Copyright SAP SE.