How To Fix HH069 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 069

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

The ONCONFIG parameter 'STACKSIZE' is set very low in your system.
As of R/3 Release 4.5A recommends a minimum setting of
64 K (for example, to prevent termination of transactions due to
complex
SQL statements (with 'FOR ALL ENTRIES' clauses). If you choose another
setting, you should avoid setting 'STACKSIZE' too high (to the maximum
value of 256K, for example) to minimize shared memory use. For more
information, 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 change 'STACKSIZE', edit (as the user 'informix') the file
'$INFORMIXDIR/etc/$ONCONFIG'.
CAUTION: The change is only activated after 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 HH069 - Edit the Informix ONCONFIG file ?

  The SAP error message HH069, 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 HH069 can be caused by several factors, including:
  
  Incorrect Configuration: The ONCONFIG file may have incorrect parameters or settings that do not align with the requirements of the SAP application.
  Missing Parameters: Certain required parameters may be missing from the ONCONFIG file.
  Incompatibility: The settings in the ONCONFIG file may not be compatible with the version of Informix or the SAP application being used.
  Resource Limitations: The configuration may not allocate sufficient resources (like memory or disk space) for the database operations required by SAP.
  
  Solution:
  To resolve the HH069 error, you can follow these steps:
  
  
  Locate the ONCONFIG File: Find the ONCONFIG file, which is usually located in the Informix installation directory. The file name is typically 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 parameters. Pay attention to the following:
  
  DBHEAP: Ensure that the database heap size is sufficient.
  SHMVIRTSIZE: Check if the shared memory size is adequate.
  LOGFILES: Ensure that the log file settings are correctly configured.
  Other Parameters: Look for any other parameters that may be relevant to your SAP installation.
  
  
  
  Modify Parameters: If you identify any incorrect or missing parameters, modify them according to the SAP and Informix documentation. Ensure that the values are appropriate for your system's resources.
  
  
  Restart Informix: After making changes to the ONCONFIG file, restart the Informix database server to apply the new configuration.
  
  
  Check SAP Documentation: Refer to the SAP documentation for any specific requirements or recommendations regarding the Informix configuration.
  
  
  Test the Connection: After making the changes and restarting the database, test the connection from the SAP application to ensure that the error is resolved.
  
  
  Related Information:
  
  Informix Documentation: Consult the official Informix documentation for detailed information on the ONCONFIG file and its parameters.
  SAP Notes: Check SAP Notes and Knowledge Base Articles for any specific guidance related to the HH069 error and Informix configurations.
  System Resources: Monitor system resources (CPU, memory, disk space) to ensure that the database has enough resources to operate effectively.
  
  If the issue persists after following these steps, consider reaching out to SAP support or your database administrator for further assistance.