How To Fix HH076 - The last update statistics session took place a long time ago

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 076

• Message text: The last update statistics session took place a long time ago

What causes this issue?

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

System Response

How to fix this 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.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message HH076 - The last update statistics session took place a long time ago ?

  The SAP error message HH076 indicates that the last update statistics session for a particular database table or index has not been executed for a long time. This can lead to performance issues because the database optimizer relies on up-to-date statistics to make informed decisions about how to execute queries efficiently.
  Cause:
  
  Outdated Statistics: The primary cause of this error is that the statistics for the specified table or index have not been updated for an extended period. This can happen due to infrequent maintenance tasks or if the automatic statistics update feature is disabled.
  Database Configuration: In some cases, the database configuration may not be set to automatically gather statistics, leading to outdated information.
  Low Activity: If a table is not frequently accessed or modified, the statistics may not be updated regularly.
  
  Solution:
  
  
  Manually Update Statistics: You can manually trigger an update of the statistics for the affected table or index. This can typically be done using transaction codes like DB02 or ST03N in SAP, or by executing a specific SQL command depending on your database (e.g., ANALYZE TABLE for Oracle).
  
  For example, in SAP, you can use the following steps:
  
  Go to transaction DB02.
  Navigate to the "Database Performance" section.
  Select the "Statistics" tab.
  Choose the relevant table and execute the statistics update.
  
  
  
  
  
  Schedule Regular Updates: Implement a regular maintenance schedule to update statistics automatically. This can be done through background jobs in SAP or by configuring the database to gather statistics at regular intervals.
  
  
  Check Database Settings: Ensure that your database settings allow for automatic statistics updates. This may involve checking the database documentation for specific configurations related to statistics gathering.
  
  
  Monitor Performance: After updating the statistics, monitor the performance of the affected queries and transactions to ensure that the changes have had a positive impact.
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as DB02, ST03N, and ST04 for monitoring database performance and statistics.
  Database Documentation: Refer to the documentation for your specific database (e.g., Oracle, SQL Server, HANA) for detailed instructions on updating statistics.
  SAP Notes: Check SAP Notes for any specific recommendations or patches related to performance issues and statistics updates.
  
  By addressing the HH076 error promptly and ensuring that statistics are kept up to date, you can help maintain optimal database performance and avoid potential issues in the future.