How To Fix HH037 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 037

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

You set ONCONFIG parameter 'TAPEDEV' to '/dev/null'.
'TAPEDEV' specifies the device (usually a tape drive) on which the
backup tool 'ontape' should save the dbspaces. If you define 'ontape',
your dbspaces will be saved to '/dev/null' at the time of backup,
that is, they are NOT saved!

System Response

How to fix this error?

To configure 'TAPEDEV' to a correct device, edit file
'$INFORMIXDIR/etc/$ONCONFIG' (as user 'informix')('ontape' should not
be running at the time of editing).

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

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

  The SAP error message HH037, 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 initialized correctly, it may lead to this error.
  Resource Limitations: The ONCONFIG file may not be configured to allocate sufficient resources (like memory or disk space) for the database operations required by SAP.
  Version Compatibility: There may be compatibility issues between the version of SAP and the version of Informix being used.
  
  Solution:
  To resolve the HH037 error, follow these steps:
  
  
  Locate the ONCONFIG File: The ONCONFIG file is typically located in the Informix installation directory. The name of the file is usually ONCONFIG or may have a specific name defined during the installation.
  
  
  Edit the ONCONFIG File:
  
  Open the ONCONFIG file in a text editor.
  Review the configuration parameters. Ensure that all necessary parameters for SAP are present and correctly set. Common parameters to check include:
  
  DBSPACENAME
  LOGFILE
  DYNAMIC_LOGS
  SHMVIRTSIZE
  SHMADD
  
  
  Adjust the values as needed based on the requirements of your SAP application and the resources available on your server.
  
  
  
  Check Informix Documentation: Refer to the Informix documentation for detailed descriptions of the parameters and their recommended values, especially in the context of SAP.
  
  
  Restart the Informix Database: After making changes to the ONCONFIG file, restart the Informix database server to apply the changes.
  
  
  Test the SAP Application: After restarting, test the SAP application to see if the error persists.
  
  
  Related Information:
  
  Informix Documentation: Always refer to the official IBM Informix documentation for the most accurate and detailed information regarding configuration parameters.
  SAP Notes: Check SAP Notes and Knowledge Base Articles for any specific recommendations or patches related to the HH037 error.
  System Resources: Monitor system resources (CPU, memory, disk space) to ensure that the database has adequate resources to operate effectively.
  Backup Configuration: Before making changes to the ONCONFIG file, ensure that you have a backup of the original file in case you need to revert your changes.
  
  If the issue persists after following these steps, consider reaching out to SAP support or your database administrator for further assistance.