How To Fix HH033 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• 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, 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.
  
  
  Review Configuration Parameters: Open the ONCONFIG file in a text editor and review the parameters. Ensure that the following are correctly set:
  
  DBSERVERNAME: Ensure it matches the server name used in your SAP configuration.
  DBSPACENAME: Check that the database space names are correctly defined.
  Memory Settings: Verify that memory-related parameters (like SHMBASE, SHMVIRTSIZE, etc.) are set according to your system's resources.
  Other SAP-Specific Parameters: Depending on your SAP version, there may be additional parameters that need to be configured.
  
  
  
  Consult Documentation: Refer to the SAP and Informix documentation for specific configuration requirements. This can provide insights into what parameters are necessary for your specific setup.
  
  
  Restart Informix: After making changes to the ONCONFIG file, restart the Informix database server to apply the changes.
  
  
  Test the Configuration: After restarting, test the SAP application to see if the error persists. Monitor the logs for any additional errors or warnings.
  
  
  Seek Support: If the issue continues, consider reaching out to SAP support or consulting with a database administrator who has experience with Informix and SAP.
  
  
  Related Information:
  
  Informix Documentation: Review the official Informix documentation for detailed information on the ONCONFIG file and its parameters.
  SAP Notes: Check SAP Notes for any specific guidance or patches related to the HH033 error.
  Community Forums: Engage with community forums or user groups for SAP and Informix, as other users may have encountered and resolved similar issues.
  
  By following these steps, you should be able to address the HH033 error and ensure that your Informix database is properly configured for use with your SAP application.