How To Fix HH036 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 036

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

You defined ONCONFIG parameter 'BUFFERS' to be less than the
recommended minimum value.
'BUFFERS' defines the size of the database buffer in shared memory,
or, to be more precise, defines the number of pages. The value
'BUFFERS * pagesize' (page size can be determined from the output of
the shell command 'oncheck -pr') should not be less than the
specified minimum value (exception: main memory of the DB server is
very small or is used elsewhere). A small configuration of
'BUFFERS' results in a high displacement rate in the buffer, that is
in loss of performance. As a rough formula for dimensioning the
database buffer, define 20% of the physical memory (see Note 38307).

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

System Response

How to fix this error?

To configure 'BUFFERS' larger, edit (as user 'informix')
file '$INFORMIXDIR/etc/$ONCONFIG'.
CAUTION: The change only becomes active after starting up the database.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

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

  The SAP error message HH036, 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 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 HH036 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.
  
  
  Review Configuration Parameters: Open the ONCONFIG file in a text editor and review the configuration parameters. Ensure that the following parameters are correctly set:
  
  DBSPACENAME: Ensure that the database space names are correctly defined.
  LOGFILE: Check that the log file paths are valid and accessible.
  DBSERVERNAME: Ensure that the server name matches the one used in the SAP configuration.
  SHMBASE, SHMVIRTSIZE, and other memory-related parameters should be set according to the system's resources.
  
  
  
  Adjust Parameters: If you identify any missing or incorrect parameters, adjust them according to the SAP and Informix documentation. You may need to consult the SAP Basis guide or Informix documentation for recommended settings.
  
  
  Restart Informix: After making changes to the ONCONFIG file, restart the Informix database server to apply the changes.
  
  
  Check SAP Configuration: Ensure that the SAP system is correctly configured to connect to the Informix database. This includes checking the database connection settings in the SAP system.
  
  
  Consult Logs: If the error persists, check the Informix and SAP logs for additional error messages that may provide more context about the issue.
  
  
  Related Information:
  
  Documentation: Refer to the official SAP and Informix documentation for detailed information on configuration parameters and best practices.
  SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address specific issues related to the HH036 error.
  Informix Community: Engage with the Informix community or forums for additional insights and troubleshooting tips.
  
  By following these steps, you should be able to resolve the HH036 error and ensure that your Informix database is properly configured for use with your SAP application.