How To Fix HH032 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 032

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

ONCONFIG parameter LBU_PRESERVE does not have the recommended value
'1'.
If LBU_PRESERVE is set to '1', transactions may not be written to the
last logical log file. This has the advantage that an emergency
backup does not have to be made in case the logical files are not
saved (see Note 32211). As a preventive measure, LBU_PRESERVE should
always be set to '1'!

System Response

How to fix this error?

To set it to the recommended value, 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 HH032 - Edit the Informix ONCONFIG file ?

  The SAP error message HH032, 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 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 Initialization Issues: If the database has not been properly initialized or configured, it may lead to this error.
  Resource Limitations: Insufficient resources (like memory or disk space) defined in the ONCONFIG file can trigger this error.
  Version Compatibility: There may be compatibility issues between the SAP application and the version of Informix being used.
  
  Solution:
  To resolve the HH032 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 configuration parameters. Ensure that all necessary parameters for SAP are correctly set. Common parameters to check include:
  
  DBSPACENAME
  LOGFILE
  DYNAMIC_LOGS
  BUFFERPOOL
  SHMVIRTSIZE
  
  
  Make sure that the values are appropriate for your system's resources and the requirements of the SAP application.
  
  
  
  Check for Required Parameters: Refer to the SAP documentation for the specific parameters that need to be configured for 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.
  
  
  Monitor Logs: Check the Informix logs for any additional errors or warnings that may provide further insight into the issue.
  
  
  Consult Documentation: If you are unsure about specific parameters, consult the Informix documentation or SAP notes related to your version of the software.
  
  
  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 known issues or specific configurations required for your version of SAP with Informix.
  Support Forums: Consider visiting SAP community forums or Informix user groups for additional insights and shared experiences from other users.
  
  If the problem persists after following these steps, it may be beneficial to reach out to SAP support or your database administrator for further assistance.