How To Fix HH076 - Der letzte Update-Statistics-Lauf ist schon sehr lange her

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 076

• Message text: Der letzte Update-Statistics-Lauf ist schon sehr lange her

Was verursacht dieses Problem?

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).

Systemantwort

Wie behebe ich diesen Fehler?

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.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE