HH078 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 078

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

The ONCONFIG parameter 'DS_TOTAL_MEMORY' in your system is set larger
than the default value. This is unnecessary on a 'normal' R/3 System
(without special Parallel Data Query (PDQ) configuration). and also has
the unwanted side affect that the space allocated by 'DS_TOTAL_MEMORY'
is not available for other database accesses (<> 'PDQ').
For more information, see note 41360 (Search for 'DS_TOTAL_MEMORY' in
this long note.)

System Response

How to fix this error?

To reduce the value, edit (as the user 'informix') the file
'$INFORMIXDIR/etc/$ONCONFIG'. To reset the value to the default,
comment out the parameter.
CAUTION: The change is not activated until the database is restarted.

Error message extract from SAP system. Copyright SAP SE.

AnswerBot

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

  The SAP error message HH078, 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 HH078 error, follow these steps:
  
  
  Locate the ONCONFIG File: Find the ONCONFIG file, which is usually located in the Informix installation directory. The file is typically named ONCONFIG or may have a specific name defined during the installation.
  
  
  Review Configuration Parameters: Open the ONCONFIG file in a text editor and check for the following:
  
  Ensure that all required parameters for SAP are present and correctly configured. Common parameters to check include:
  
  DBSPACENAME
  LOGFILE
  DYNAMIC_LOGS
  BUFFERPOOL
  
  
  Compare the parameters with the SAP documentation or the recommended settings for your specific version of SAP and Informix.
  
  
  
  Adjust Resource Settings: If you suspect resource limitations, adjust the settings for memory, disk space, and other resources to ensure they meet the requirements of your SAP application.
  
  
  Consult SAP Notes: Check the SAP Support Portal for any relevant notes or documentation that may provide specific guidance for your version of SAP and Informix.
  
  
  Restart Informix: After making changes to the ONCONFIG file, restart the Informix database server to apply the new configuration.
  
  
  Test the Connection: After restarting, test the connection between SAP and Informix to ensure that the error has been resolved.
  
  
  Related Information:
  
  Informix Documentation: Refer to the official Informix documentation for detailed information on the ONCONFIG file and its parameters.
  SAP Notes: Search for SAP Notes related to Informix and the specific error message HH078 for additional troubleshooting steps and recommendations.
  System Logs: Check the Informix and SAP system logs for any additional error messages or warnings that may provide more context about the issue.
  
  If the problem persists after following these steps, consider reaching out to SAP support or your database administrator for further assistance.