How To Fix HH081 - Edit the Informix ONCONFIG file

HH081 - Overview

• 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: