How To Fix HH041 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• 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 ONCONFIG file, which is usually located in the Informix installation directory. The file is typically named ONCONFIG or may have a specific name based on your configuration.
  
  
  Edit the ONCONFIG File:
  
  Open the ONCONFIG file in a text editor.
  Review the parameters defined in the file. Common parameters to check include:
  
  DBSPACENAME: Ensure that the database space is correctly defined.
  LTAPE: Check if the logical tape device is set correctly.
  SHMBASE, SHMVIRTSIZE, SHMADD: Ensure that shared memory settings are appropriate for your system.
  DBSERVERNAME: Verify that the server name matches the one used in your SAP configuration.
  
  
  Make necessary adjustments based on the requirements of your SAP application.
  
  
  
  Save Changes: After making the necessary changes, save the ONCONFIG file.
  
  
  Restart Informix: Restart the Informix database server to apply the changes made to the ONCONFIG file. This can usually be done using the command:
  onmode -ky
  oninit
  
  
  Check SAP Configuration: Ensure that the SAP system is correctly configured to connect to the Informix database. This includes checking the database connection settings in the SAP system.
  
  
  Consult Documentation: Refer to the SAP and Informix documentation for specific configuration requirements and best practices.
  
  
  Related Information:
  
  Informix Documentation: Review the official Informix documentation for detailed information on the ONCONFIG file and its parameters.
  SAP Notes: Check SAP Notes for any specific guidance or patches related to the HH041 error.
  System Logs: Review system logs for 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.