How To Fix HH034 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 034

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

You configured ONCONFIG parameter USEOSTIME to be detrimental to the
performance.
Background: USEOSTIME defines whether the time is determined by
system calls of the operating system (value '1') or by the internal
clock of the database system (value '0').
SAP recommends setting the configuration to '0', since setting it to
'1' could result in a loss of performance of up to 5%.

System Response

How to fix this error?

To configure the parameter as recommended, edit (as user 'informix')
the 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 HH034 - Edit the Informix ONCONFIG file ?

  The SAP error message HH034, 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 HH034 can be caused by several factors, including:
  
  Incorrect Configuration Parameters: The ONCONFIG file may have incorrect or missing parameters that are necessary for the database to operate correctly.
  Resource Limitations: The database may be configured with insufficient resources (e.g., memory, disk space) that do not meet the requirements of the SAP application.
  Version Compatibility: There may be compatibility issues between the version of SAP and the version of Informix being used.
  Environment Variables: Incorrect or missing environment variables related to Informix may lead to this error.
  
  Solution:
  To resolve the HH034 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>.
  
  
  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
  DBSERVERNAME
  DBSERVERNUM
  DYNAMIC_LOGS
  BUFFERPOOL
  Any other parameters relevant to your SAP installation.
  
  
  
  Adjust Resource Settings: If you suspect resource limitations, consider increasing memory allocation or disk space in the ONCONFIG file. Parameters like SHMVIRTSIZE, SHMADD, and LOCKS may need to be adjusted.
  
  
  Check for Compatibility: Ensure that the versions of SAP and Informix are compatible. Refer to the SAP Product Availability Matrix for guidance.
  
  
  Set Environment Variables: Verify that the necessary environment variables for Informix are set correctly. Common variables include INFORMIXDIR, INFORMIXSERVER, and PATH.
  
  
  Restart Informix: After making changes to the ONCONFIG file, restart the Informix database server to apply the changes.
  
  
  Consult Documentation: Refer to the Informix documentation and SAP notes for specific configuration recommendations and best practices.
  
  
  Check Logs: Review the Informix and SAP logs for any additional error messages or warnings that may provide further insight into the issue.
  
  
  Related Information:
  
  Informix Documentation: Consult the official IBM Informix documentation for detailed information on the ONCONFIG file and its parameters.
  SAP Notes: Check SAP Notes related to Informix and the specific version of SAP you are using for any known issues or patches.
  Community Forums: Engage with SAP and Informix community forums for shared experiences and solutions from other users who may have encountered similar issues.
  
  By following these steps, you should be able to identify and resolve the cause of the HH034 error in your SAP environment using Informix.