How To Fix HH070 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 070

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

The ONCONFIG parameter 'DD_HASHSIZE' is set very low in your system.
As of Release 4.5A, we recommend a minimum setting of
'613'. If you choose another setting, 'DD_HASHSIZE' 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_HASHSIZE', 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 HH070 - Edit the Informix ONCONFIG file ?

  The SAP error message HH070, which states "Edit the Informix ONCONFIG file," typically occurs in environments where SAP applications are using Informix as the database management system. This error indicates 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 HH070 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 misconfigurations in the ONCONFIG file.
  Version Compatibility: There may be compatibility issues between the SAP application and the version of Informix being used.
  Resource Limitations: Insufficient resources (like memory or disk space) may lead to the need for adjustments in the ONCONFIG file.
  
  Solution:
  To resolve the HH070 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 defined during the installation.
  
  
  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: Ensure that the database space names are correctly defined.
  LOGFILE: Check that the log file paths are valid and accessible.
  BUFFERPOOL: Ensure that the buffer pool settings are appropriate for your system's resources.
  MAXCLIENTS: Verify that the maximum number of clients is set according to your needs.
  
  
  Make necessary adjustments based on the requirements of your SAP application and the resources available on your server.
  
  
  
  Save Changes: After making the necessary changes, save the ONCONFIG file.
  
  
  Restart Informix: For the changes to take effect, restart the Informix database server. This can usually be done using the command line or through the Informix administration tools.
  
  
  Check SAP Configuration: Ensure that the SAP system is correctly configured to connect to the Informix database. This includes checking connection parameters and ensuring that the database is accessible.
  
  
  Consult Documentation: Refer to the SAP and Informix documentation for specific configuration guidelines and best practices.
  
  
  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 HH070 error.
  System Logs: Review system logs for additional error messages or warnings that may provide more context about the issue.
  Support: If the issue persists, consider reaching out to SAP support or Informix support for further assistance.
  
  By following these steps, you should be able to resolve the HH070 error and ensure that your SAP application can properly interact with the Informix database.