Analyzing and resolving fragmentation and optimization exceptions for index databases

Analyzing and tuning index databases such as HIDAM primary indexes, secondary indexes, and HALDB partitioned secondary indexes includes four major tasks: analyzing space use exceptions, analyzing fragmentation exceptions, analyzing optimization exceptions, and resolving these exceptions.

The following topics explain how to analyze the database states based on the exceptions that you received and how to recover from the exceptional states.