How To Fix HH066 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 066

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

The ONCONFIG parameter 'PHYSFILE' is configured very low.
This parameter defines the size of the physical log file in kilobytes.
If the physical log file is configured very low then there is the risk
that it could fill up in certain situations (SAP upgrade) and that the
checkpoint that results from this implicitly (due to an Informix bug)
will not be implemented (checkpoint 'hangs' in a 'critical section').

How to fix this error?

To set 'PHYSFILE' to the recommended value edit (as user 'informix')
the file '$INFORMIXDIR/etc/$ONCONFIG' or use the Informix tool
'onparams'.
CAUTION: The change will only be active after restarting the database.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

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

  The SAP error message HH066, 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 HH066 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 initialized correctly, it may lead to this error.
  Resource Limitations: The ONCONFIG file may not be configured to allocate sufficient resources (like memory, disk space, etc.) 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 HH066 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.
  
  
  Edit the ONCONFIG File:
  
  Open the ONCONFIG file in a text editor.
  Review the configuration parameters. Ensure that all necessary parameters for SAP are defined and correctly set. Common parameters to check include:
  
  DBSPACENAME
  LOGFILE
  DYNAMIC_LOGS
  SHMVIRTSIZE
  SHMADD
  
  
  Make sure that the values are appropriate for your system's resources and the requirements of the SAP application.
  
  
  
  Check for Documentation: Refer to the SAP and Informix documentation for specific configuration settings that are recommended for your version of SAP and Informix.
  
  
  Restart the Informix Database: After making changes to the ONCONFIG file, restart the Informix database server to apply the changes.
  
  
  Test the SAP Application: After restarting, test the SAP application to see if the error persists.
  
  
  Related Information:
  
  Informix Documentation: Consult the official Informix documentation for detailed information on the ONCONFIG file and its parameters.
  SAP Notes: Check SAP Notes and Knowledge Base Articles for any specific guidance related to the HH066 error and Informix configurations.
  System Resources: Monitor system resources to ensure that the database has enough memory and disk space allocated as per the ONCONFIG settings.
  Version Compatibility: Ensure that both SAP and Informix versions are compatible with each other, as mismatches can lead to various issues.
  
  If the problem persists after following these steps, consider reaching out to SAP support or your database administrator for further assistance.