How To Fix HH071 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 071

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

The ONCONFIG parameter 'DD_HASHMAX' is set very low in your system.
As of Release 4.5A, we recommend a minimum setting of
'30'. If you choose another setting, 'DD_HASHMAX' should not be set
unnecessarily high, in order to minimize use of shared memory.
For information about setting a suitable value ('onstat -g dic ...'),
see note 38307.

System Response

How to fix this error?

To change 'DD_HASHMAX', edit (as the user
'informix') the file '$INFORMIXDIR/etc/$ONCONFIG'.
CAUTION: The change is only activated after the database is restarted.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

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

  The SAP error message HH071, 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 Parameters: The ONCONFIG file may be missing essential parameters or have incorrect values that do not meet the requirements of the SAP application.
  Database Configuration Issues: The database may not be configured correctly to handle the workload or specific features required by the SAP application.
  Resource Limitations: The settings in the ONCONFIG file may not allocate sufficient resources (like memory, disk space, etc.) for the database operations.
  Version Compatibility: There may be compatibility issues between the version of Informix being used and the SAP application.
  
  Solution:
  To resolve the HH071 error, follow these steps:
  
  
  Locate the ONCONFIG File: Find the ONCONFIG file, which is usually located in the Informix installation directory. The file is typically named ONCONFIG or may have a specific name based on your configuration.
  
  
  Review Configuration Parameters: Open the ONCONFIG file in a text editor and review the parameters. Look for any parameters that may be missing or incorrectly set. Common parameters to check include:
  
  DBSPACENAME
  LOGFILE
  SHMVIRTSIZE
  DBHEAP
  LTAPE (if using tape backups)
  
  
  
  Adjust Resource Settings: Ensure that the resource settings (like memory allocation) are appropriate for your system's capabilities and the requirements of the SAP application.
  
  
  Consult Documentation: Refer to the Informix documentation and SAP notes for specific recommendations on ONCONFIG settings for your version of SAP and Informix.
  
  
  Restart Informix: After making changes to the ONCONFIG file, restart the Informix database server to apply the changes.
  
  
  Test the Configuration: After restarting, test the SAP application to see if the error persists. Monitor the database logs for any additional errors or warnings.
  
  
  Related Information:
  
  Informix Documentation: Review the official IBM Informix documentation for detailed information on the ONCONFIG file and its parameters.
  SAP Notes: Check SAP's support portal for any specific notes related to the HH071 error and Informix configurations.
  Community Forums: Engage with community forums or SAP user groups for shared experiences and solutions related to this error.
  
  If the issue persists after following these steps, consider reaching out to SAP support or your database administrator for further assistance.