How To Fix HH041 - Edit the Informix ONCONFIG file

HH041 - Overview

• Message type: E = Error

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

• Message number: 041

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

You have configured the ONCONFIG parameter 'LTXEHWM' (long-transaction
[exclusive- access] high-water mark) to differ from the recommended
value.
Parameter 'LTXEHWM' corresponds to parameter
'LTXHWM' (see 'D-040') and specifies the 2nd (higher)
percentual threshold value at which a DB transaction gets exclusive
access to the logical log so that the transaction can always be
rolled back successfully.
An R/3 database should be configured for 'LIXEHWM' as in the
recommended value. You can ignore any warnings generated in the
Informix log file:

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

"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 'LTXEHWM', 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 HH041 - Edit the Informix ONCONFIG file ?

  The SAP error message HH041, which states "Edit the Informix ONCONFIG file," typically occurs in environments where SAP applications are using Informix as the database management system. This error indicates 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: The database may not have been initialized correctly, leading to configuration mismatches.
  Resource Limitations: The ONCONFIG file may not be configured to allocate sufficient resources (like memory or disk space) for the SAP application.
  Version Compatibility: There may be compatibility issues between the version of SAP and the version of Informix being used.
  
  
  Solution:
  To resolve the HH041 error, follow these steps:
  
  
  Locate the ONCONFIG File: Find the