How To Fix HH060 - The number of allocated pages has almost reached the Informix limit

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 060

• Message text: The number of allocated pages has almost reached the Informix limit

What causes this issue?

The specified table (belonging to 'sapr3') allocated a very large
number of pages and is approaching the limit for Informix. If the
single check was classified as a 'warning', more than 70% of the
upper limit was reached. If the single check was classified as 'error',
more than 90% has already been reached!

System Response

How to fix this error?

Check whether records of the table can be archived (or physically
deleted if they are only logically deleted [selected]).
If this does not result in a drastic reduction in the number of pages,
you must use a different strategy, for example roll out the relevant
indexes. If you have questions, please contact the SAP/Informix
HelpDesk).

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message HH060 - The number of allocated pages has almost reached the Informix limit ?

  The SAP error message HH060, which states "The number of allocated pages has almost reached the Informix limit," typically indicates that the Informix database is nearing its maximum limit for allocated pages. This can lead to performance issues or even prevent new data from being written to the database if the limit is reached.
  Cause:
  
  
  Database Configuration: The Informix database has a predefined limit on the number of pages it can allocate. This limit can be reached due to:
  
  High volume of data being processed.
  Inefficient database design or queries that lead to excessive page allocation.
  Insufficient configuration settings for the database.
  
  
  
  Memory Management: The database may not be configured to utilize available memory efficiently, leading to premature exhaustion of allocated pages.
  
  
  Fragmentation: Over time, the database can become fragmented, which can lead to inefficient use of allocated pages.
  
  
  Solution:
  
  
  Increase Page Limit:
  
  Review and, if necessary, increase the DBSPACED or DBSPACED configuration parameters in Informix to allow for more allocated pages.
  You may need to adjust the PHYSDBSPACED parameter to increase the physical space available for the database.
  
  
  
  Optimize Database Design:
  
  Analyze the database schema and queries to identify inefficiencies. Consider normalizing tables or optimizing indexes to reduce the number of pages required for operations.
  
  
  
  Monitor and Manage Memory:
  
  Ensure that the Informix database is configured to use available system memory effectively. Adjust parameters like SHMVIRTSIZE and SHMADD to allocate more shared memory if needed.
  
  
  
  Database Maintenance:
  
  Regularly perform database maintenance tasks such as reorganization and defragmentation to optimize space usage.
  Use Informix utilities to monitor and manage database performance.
  
  
  
  Consult Documentation:
  
  Refer to the Informix documentation for specific configuration settings and best practices related to page allocation and memory management.
  
  
  
  Contact Support:
  
  If the issue persists after attempting the above solutions, consider reaching out to SAP or Informix support for further assistance.
  
  
  
  Related Information:
  
  Informix Documentation: Review the official Informix documentation for detailed information on configuration parameters and best practices.
  SAP Notes: Check SAP Notes for any specific recommendations or patches related to this error message.
  Performance Monitoring Tools: Utilize performance monitoring tools to analyze database performance and identify bottlenecks.
  
  By addressing the underlying causes and implementing the suggested solutions, you should be able to resolve the HH060 error and improve the performance of your SAP system using Informix.