How To Fix HH067 - The no. of Dbspace chunks is (highly) critical (due to ontape/onarchive)

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 067

• Message text: The no. of Dbspace chunks is (highly) critical (due to ontape/onarchive)

What causes this issue?

The specified dbspace consists of many chunks:
Background: The Informix backup tools 'ontape' and 'onarchive' have
difficulties restoring dbspaces that consist of more than 32 chunks.
This bug is fixed at 'ontape' in the Informix version '7.21.UC2'
and at 'onarchive' in the version '7.23.UC3'.

How to fix this error?

Even if you have not reached the critical figure of '32' read Note
82501 for detailed information and further procedures.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message HH067 - The no. of Dbspace chunks is (highly) critical (due to ontape/onarchive) ?

  The SAP error message HH067 indicates that the number of database space chunks is critically low, which can lead to issues with database operations, particularly when using backup tools like ontape or onarchive. This situation typically arises in environments using IBM Informix as the database management system.
  Cause:
  
  Database Space Management: The error is triggered when the number of chunks allocated for the database exceeds a critical threshold. Chunks are segments of disk space allocated for database storage, and if they are running low, it can hinder the database's ability to perform operations such as backups or data writes.
  High Data Volume: An increase in data volume without adequate planning for space can lead to this issue.
  Improper Configuration: If the database was not configured with sufficient chunks from the beginning, it may run into this problem as data grows.
  Fragmentation: Over time, database fragmentation can lead to inefficient use of space, causing the system to run out of available chunks.
  
  Solution:
  
  
  Add More Chunks: The most direct solution is to add more chunks to the database. This can be done using the onspaces command to create new chunks and then adding them to the database.
  
  Example command: 
  onspaces -c -d <dbspace_name> -p <path_to_chunk> -o <offset> -s <size>
  
  Ensure that the new chunk is placed on a disk with sufficient space.
  
  
  
  Monitor Database Usage: Regularly monitor the database space usage to anticipate when you might need to add more chunks. Use tools like onstat -d to check the current status of dbspaces and chunks.
  
  
  Optimize Data Storage: Review and optimize the data stored in the database. This may include archiving old data, purging unnecessary records, or optimizing data structures.
  
  
  Database Configuration Review: Review the initial configuration of the database to ensure that it is set up to handle the expected data volume. Adjust configurations as necessary.
  
  
  Backup and Maintenance: Regularly perform backups and maintenance tasks to ensure that the database is running efficiently and to prevent issues related to space.
  
  
  Related Information:
  
  Documentation: Refer to the IBM Informix documentation for detailed instructions on managing dbspaces and chunks.
  SAP Notes: Check SAP Notes for any specific recommendations or patches related to this error message.
  Database Monitoring Tools: Consider using database monitoring tools that can alert you when space is running low, allowing for proactive management.
  
  By addressing the underlying causes and implementing the solutions mentioned, you can resolve the HH067 error and maintain the health of your SAP database environment.