How To Fix HH081 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 081

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

The ONCONFIG parameter 'OPT_GOAL' in your system is not set to the
recommended value. This parameter influences the behavior of the cost-
based Informix optimizer. For example, if the value is '0', the
optimizer optimizes using FIRST_ROWS. However, this is not the correct
standard setting. The correct setting is '-1' (or not set at all),
which means the optimizer uses ALL_ROWS.
'OPT_GOAL' in an SAP R/3 database must be set to the SAP recommended
and tested value. Any other value will reduce performance considerably.

System Response

How to fix this error?

To change 'OPT_GOAL', log on as user 'informix' and edit the file
'$INFORMIXDIR/etc/$ONCONFIG'.
CAUTION: The change is not active until the database is restarted.

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

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

  The SAP error message HH081, which indicates that you need to edit the Informix ONCONFIG file, typically arises in the context of SAP applications that use Informix as the database management system. This error suggests that there are configuration issues in the ONCONFIG file that need to be addressed to ensure proper database operation.
  Cause:
  The error HH081 can be caused by several factors, including:
  
  Incorrect Configuration Parameters: The ONCONFIG file may have incorrect or missing parameters that are essential for the database's operation.
  Resource Limitations: The database may not have sufficient resources allocated (e.g., memory, disk space) as defined in the ONCONFIG file.
  Version Compatibility: The version of Informix being used may not be compatible with the SAP application, leading to configuration issues.
  Database Initialization: The database may not have been initialized correctly, or certain parameters may not have been set up properly during installation.
  
  Solution:
  To resolve the HH081 error, follow these steps:
  
  
  Locate the ONCONFIG File: The ONCONFIG file is typically located in the Informix installation directory. The exact path may vary based on your installation.
  
  
  Edit the ONCONFIG File:
  
  Open the ONCONFIG file in a text editor.
  Review the configuration parameters. Common parameters to check include:
  
  DBSPACENAME: Ensure that the database space is correctly defined.
  PHYSDBS: Check that physical database sizes are appropriate.
  SHMVIRTSIZE: Ensure that shared memory settings are adequate.
  LOGFILES: Verify that the log file settings are correct.
  
  
  Make necessary adjustments based on your system's requirements and SAP's recommendations.
  
  
  
  Validate Changes: After editing the ONCONFIG file, validate the changes to ensure there are no syntax errors or misconfigurations.
  
  
  Restart the Informix Database: After making changes, restart the Informix database server to apply the new configuration settings.
  
  
  Check SAP Notes: Consult SAP Notes or the SAP Help Portal for any specific recommendations or patches related to the version of SAP and Informix you are using.
  
  
  Monitor Logs: After restarting, monitor the Informix and SAP logs for any further errors or warnings that may indicate additional issues.
  
  
  Related Information:
  
  Documentation: Refer to the official Informix documentation for detailed information on the ONCONFIG parameters and their implications.
  SAP Support: If the issue persists, consider reaching out to SAP support for assistance, especially if you suspect a deeper compatibility or configuration issue.
  Community Forums: Engage with community forums or user groups for SAP and Informix, as other users may have encountered similar issues and can provide insights.
  
  By following these steps, you should be able to address the HH081 error and ensure that your Informix database is properly configured for use with your SAP application.