How To Fix HH040 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 040

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

Your configuration of the ONCONFIG parameter 'LTXHWM' (long-transaction
high-water mark) differs from the recommended value.
Parameter 'LTXHWM' specifies the max. filling level in percent
of the logical log space which a DB transaction may cover.
If a DB transaction exceeds this space, it is automatically
terminated (that is, rolled back).
The configuration for 'LTXHWM' in the R/3 database

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

should adhere to the recommended value. If a warning is generated
in the Informix log file, it can be ignored:
"WARNING! LTXHWM (70) and/or LTXEHWM (80) config parameters
exceed recommended values of 50 and 60. This may
cause On-Line to wait too long before rolling
back a long transaction and allow it to completely
fill the logs. See the OnLine Administrators Guide
and $INFORMIXDIR/release/SERVERS_7.1 for more
information on resetting LTXHWM and LTXEHWM".

System Response

How to fix this error?

To change 'LTXHWM', edit file '$INFORMIXDIR/etc/$ONCONFIG' (as user
'informix').
CAUTION: The change only becomes active when the database is started
up.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

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

  The SAP error message HH040, 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 Environment Issues: The database environment may not be set up correctly, leading to miscommunication between SAP and Informix.
  Resource Limitations: Insufficient resources (like memory or disk space) defined in the ONCONFIG file can lead to operational issues.
  Version Compatibility: There may be compatibility issues between the versions of SAP and Informix being used.
  
  
  Solution:
  To resolve the HH040 error, follow these steps:
  
  
  Locate the ONCONFIG File: Find the ONCONFIG file,