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, 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 are present and correctly configured. Common parameters to check include:
  
  DBSPACENAME
  LOGFILE
  DYNAMIC_LOGS
  SHMVIRTSIZE
  PHYSFILE
  
  
  Compare the parameters with the SAP documentation or the recommended settings for your specific SAP version.
  
  
  
  Adjust Resource Settings: If you find that resource settings (like memory allocation) are insufficient, adjust them according to the requirements of your SAP application.
  
  
  Check for Errors in the Informix Logs: Review the Informix database logs for any additional error messages that might provide more context about the issue.
  
  
  Restart the Informix Database: After making changes to the ONCONFIG file, restart the Informix database to apply the new settings.
  
  
  Test the SAP Connection: Once the database is restarted, test the connection from SAP to Informix to ensure that the error has been resolved.
  
  
  Related Information:
  
  Documentation: Refer to the official SAP and Informix documentation for specific configuration guidelines and best practices.
  SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address this error or provide additional troubleshooting steps.
  Informix Community: Engage with the Informix community or forums for insights from other users who may have encountered similar issues.
  
  If the problem persists after following these steps, consider reaching out to SAP support or your database administrator for further assistance.