How To Fix HH027 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 027

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

ONCONFIG parameter WSTATS is not configured as recommended.
CAUTION: Due to an Informix bug, this single check could under certain
circumstances display an incorrect configuration of the
'<CONFIG. table>' value although the configuration is correct in
the ONCONFIG file (and the database was started up) (see Note 61150).
To be on the safe side, proceed as described below.

System Response

How to fix this error?

To set WSTATS to the recommended value, edit (as user 'informix')
file '$INFORMIXDIR/etc/$ONCONFIG'.
CAUTION: The change will only become active when the database is
started up.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

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

  The SAP error message HH027, 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 HH027 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 HH027 error, follow these steps:
  
  
  Locate the ONCONFIG File: The ONCONFIG file is typically located in the Informix installation directory. The default name is usually ONCONFIG or onconfig.<dbname>.
  
  
  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
  LOGFILE
  DYNAMIC_LOGS
  BUFFERPOOL
  SHMVIRTSIZE
  
  
  Ensure that all necessary parameters are defined and that their values are appropriate for your SAP application and system resources.
  
  
  
  Consult Documentation: Refer to the Informix documentation and SAP notes for specific configuration recommendations related to your version of SAP and Informix.
  
  
  Restart the Informix Database: After making changes to the ONCONFIG file, restart the Informix database server to apply the changes.
  
  
  Check Logs: After restarting, check the Informix logs for any additional errors or warnings that may provide further insight into the issue.
  
  
  Test the SAP Application: Once the database is restarted, test the SAP application to see if the error persists.
  
  
  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 or recommendations related to the HH027 error and Informix configurations.
  Community Forums: Engage with SAP and Informix community forums for shared experiences and solutions from other users who may have encountered similar issues.
  
  If the problem persists after following these steps, consider reaching out to SAP support or your database administrator for further assistance.