How To Fix HH021 - Reorganize the specified table

HH021 - Overview

• Message type: E = Error

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

• Message number: 021

• Message text: Reorganize the specified table

What causes this issue?

The number of extents of the specified table is very high.
The table should be reorganized since the Informix server only
provides a limited number of extents and this value has nearly been
reached.

System Response

How to fix this error?

The sapdba tool is a good means of reorganizing a table.
Also read Note 22941!

Error message extract from SAP system. Copyright SAP SE.

HH021 - Details

• The SAP error message HH021, which states "Reorganize the specified table," typically indicates that a database table has reached a certain threshold of fragmentation or has accumulated a significant amount of obsolete data. This can lead to performance issues and may prevent further data operations on that table.
  
  Cause:
  
  Table Fragmentation: Over time, as records are added, modified, or deleted, the physical storage of the table can become fragmented. This can lead to inefficient data access and slower performance.
  Obsolete Data: Tables may contain a large amount of obsolete or unnecessary data that needs to be cleaned up.
  Database Size Limits: Some databases have size limits for tables, and if a table approaches this limit, it may trigger the need for reorganization.
  System Performance: High levels of fragmentation can lead to degraded performance, which may trigger this error.
  
  
  Solution:
  To resolve the HH021 error, you can follow these steps:
  
  
  Reorganize the Table:
  
  Use the transaction code SE14 (Database Utility)