How To Fix HH036 - Edit the Informix ONCONFIG file

HH036 - Overview

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

HH036 - Details

• 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