How To Fix HH078 - Edit the Informix ONCONFIG file

HH078 - Overview

• 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.

Smart SAP Assistant

• 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