How To Fix HH033 - Edit the Informix ONCONFIG file

HH033 - Overview

• Message type: E = Error

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

• Message number: 033

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

You configured the ONCONFIG parameter 'LOCKS' to be very large.
Background: Each 'lock' reserves 43 bytes (OSF/1: 72 bytes) in the
resident shared memory area, so you should make sure that you do not
configure more 'locks' than necessary.
Using the UNIX command 'onstat -k | grep total', you can check the
number of 'locks' currently reserved: 'active' designates this value,
'total' is the configured maximum.
However, you should bear in mind that there are 'special' DB actions
(for example, CLIENT COPY) or customer developments that temporarily
require considerably more locks!!!
In the case of customer developments, you should make sure - if
the logic allows this - that commits are performed more frequently
or tables locked completely, if necessary (-> fewer locks).
If the preconfigured maximum threshold value is clearly too low, you
can use transaction DB17 to increase the threshold value or deactivate
the individual check.
Refer to Note '18993'in any case. It contains the latest information
regarding 'LOCKS'.

System Response

How to fix this error?

To reconfigure the parameter, edit the file
'$INFORMIXDIR/etc/$ONCONFIG' (as user'informix'). However, you should
not configure 'LOCKS' smaller than '500,000', if possible.
CAUTION: The change only takes effect when the database is restarted.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

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

  The SAP error message HH033, 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 misconfigurations in the ONCONFIG file.
  Version Compatibility: There may be compatibility issues between the SAP application and the version of Informix being used, requiring specific settings in the ONCONFIG file.
  Resource Limitations: Insufficient resources (like memory or disk space) may lead to the need for adjustments in the ONCONFIG file.
  
  
  Solution:
  To resolve the HH033 error,