How To Fix HH042 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 042

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

ONCONFIG parameter 'OPTCOMPIND' differs from the recommended value.
The value of parameter 'OPTCOMPIND' ('0','1','2') affects the behavior
of the (cost-based) Informix optimizer.
An R/3 database must be configured for 'OPTCOMPIND' to adhere to
the value recommended by SAP.
A configuration which differs from the recommendation will result in
a number of 'sequencial scans', i.e. the performance will deteriorate
significantly!

System Response

How to fix this error?

To change 'OPTCOMPIND', edit (as user
'informix') the file '$INFORMIXDIR/etc/$ONCONFIG'.
CAUTION: The change will only become active when the database has been
started up.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

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

  The SAP error message HH042, 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 be missing essential 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 HH042 error, follow these steps:
  
  
  Locate the ONCONFIG File: Find the ONCONFIG file, which is usually located in the Informix installation directory. The default name is often ONCONFIG or ONCONFIG.<dbname>.
  
  
  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
  LOGFILE
  DYNAMIC_LOGS
  BUFFERPOOL
  SHMVIRTSIZE
  Any other parameters specific to your SAP installation.
  
  
  
  Adjust Parameters: If you identify any missing or incorrect parameters, adjust them according to the SAP documentation or best practices for Informix. 
  
  
  Check Resource Settings: Ensure that the system has adequate resources (memory, disk space, etc.) allocated for the Informix database.
  
  
  Restart Informix: After making changes to the ONCONFIG file, restart the Informix database server to apply the changes.
  
  
  Consult Documentation: Refer to the SAP and Informix documentation for specific configuration settings that are recommended for your version of SAP and Informix.
  
  
  Test the Configuration: After making the necessary changes and restarting the database, test the SAP application to see if the error persists.
  
  
  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 specific guidance or patches related to the HH042 error and Informix configurations.
  Support Forums: Consider visiting SAP community forums or Informix user groups for additional insights and shared experiences from other users who may have encountered similar issues.
  
  If the problem persists after following these steps, it may be beneficial to contact SAP support or your database administrator for further assistance.