How To Fix HH039 - Edit the Informix ONCONFIG file

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 039

• Message text: Edit the Informix ONCONFIG file

What causes this issue?

You configured ONCONFIG parameter 'TAPEBLK' or 'LTAPEBLK'
to be greater than '128'.
Parameter 'TAPEBLK' specifies the block size with which the backup
tool 'ontape' saves the dbspaces on tape.
'LTAPEBLK' specifies the block size with which
'ontape' saves the logical logs on tape.
If you define 'ontape', your backup will fail since SNI tape stations
can only handle a maximum of '128' at the moment
(see Note 53970).

System Response

How to fix this error?

To reconfigure 'TAPEBLK' or 'LTAPEBLK', edit file
'$INFORMIXDIR/etc/$ONCONFIG' (as user 'informix')('ontape' should not
be running at the time of editing).

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

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

  The SAP error message HH039, which indicates "Edit the Informix ONCONFIG file," typically arises in the context of SAP systems that use Informix as their 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:
  
  Incorrect Configuration: The ONCONFIG file may have incorrect parameters or settings that do not align with the requirements of the SAP application or the Informix database.
  Missing Parameters: Certain required parameters may be missing from the ONCONFIG file, leading to operational issues.
  Incompatibility: The configuration settings may not be compatible with the version of Informix being used or the specific requirements of the SAP application.
  Resource Limitations: The ONCONFIG file may not be configured to allocate sufficient resources (like memory or disk space) for the database operations.
  
  Solution:
  To resolve the HH039 error, follow these steps:
  
  
  Locate the ONCONFIG File: Identify the location of the ONCONFIG file, which is typically found in the Informix installation directory.
  
  
  Backup the ONCONFIG File: Before making any changes, create a backup of the existing ONCONFIG file to prevent data loss.
  
  
  Edit the ONCONFIG File:
  
  Open the ONCONFIG file in a text editor.
  Review the parameters and settings. Common parameters to check include:
  
  DBSPACENAME
  LOGFILE
  BUFFERPOOL
  SHMVIRTSIZE
  DYNAMIC_LOGS
  
  
  Ensure that all required parameters are present and correctly configured according to the SAP and Informix documentation.
  
  
  
  Consult Documentation: Refer to the SAP and Informix documentation for recommended settings and configurations specific to your version and use case.
  
  
  Restart the Informix Database: After making changes to the ONCONFIG file, restart the Informix database server to apply the new settings.
  
  
  Test the SAP Application: Once the database is restarted, test the SAP application to see if the error persists.
  
  
  Related Information:
  
  Informix Documentation: Review 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 HH039 error and Informix configurations.
  System Logs: Review system logs for additional error messages or warnings that may provide more context about the issue.
  
  If the problem persists after following these steps, consider reaching out to SAP support or your database administrator for further assistance.