How To Fix HH077 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 077

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

The ONCONFIG parameter 'LRUS' in your system is set lower than the
minimum setting we recommend.
For more information, see note 41360 (note: As this is a long note,
search for 'LRUS' in the note).

System Response

How to fix this error?

To change the value, edit (as the user 'informix') the file
'$INFORMIXDIR/etc/$ONCONFIG'. Use the following formula (from note
41360) to determine a suitable value:
On platforms with 2kb page sizes, the ratio between the BUFFER and LRUS
10000 should be 10000 to 1. For 4kb page sizes, 5000 to 1.
CAUTION: The change is not activated until the database is restarted.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message HH077 - Edit the Informix ONCONFIG file ?

  The SAP error message HH077, which indicates "Edit the Informix ONCONFIG file," typically arises in environments where SAP applications are using Informix as the database management system. This error suggests that there is a configuration issue with the Informix ONCONFIG file, which is crucial for the proper functioning of the Informix database.
  Cause:
  The error can be caused by several factors, including:
  
  Missing or Incorrect Configuration Parameters: The ONCONFIG file may lack necessary parameters or have incorrect values that do not meet the requirements of the SAP application.
  Database Environment Issues: The database environment may not be set up correctly, leading to miscommunication between SAP and Informix.
  Version Compatibility: There may be compatibility issues between the versions of SAP and Informix being used.
  Resource Limitations: Insufficient resources (like memory or disk space) configured in the ONCONFIG file can lead to this error.
  
  Solution:
  To resolve the HH077 error, follow these steps:
  
  
  Locate the ONCONFIG File: Identify the location of the ONCONFIG file, which is typically found in the Informix installation directory.
  
  
  Backup the ONCONFIG File: Before making any changes, create a backup of the existing ONCONFIG file.
  
  
  Edit the ONCONFIG File:
  
  Open the ONCONFIG file in a text editor.
  Review the parameters defined in the file. Common parameters to check include:
  
  DBSPACENAME
  LOGFILE
  DYNAMIC_LOGS
  BUFFERPOOL
  SHMVIRTSIZE
  
  
  Ensure that all necessary parameters are defined and that their values are appropriate for your SAP environment.
  
  
  
  Consult SAP Documentation: Refer to the SAP documentation for specific configuration requirements related to Informix. This may include recommended settings for memory allocation, buffer sizes, and other parameters.
  
  
  Restart the Informix Database: After making changes to the ONCONFIG file, restart the Informix database to apply the new configuration.
  
  
  Test the SAP Application: Once the database is restarted, test the SAP application to see if the error persists.
  
  
  Related Information:
  
  Informix Documentation: Review the official Informix documentation for detailed information on the ONCONFIG file and its parameters.
  SAP Notes: Check SAP Notes for any specific guidance or patches related to the HH077 error and Informix integration.
  System Logs: Review system logs for additional error messages or warnings that may provide more context about the issue.
  
  If the problem persists after following these steps, consider reaching out to SAP support or your database administrator for further assistance.