Through Database Reorganization

Database reorganization includes:

Reducing full pages by changing the size of a database page or increasing the number of pages
Reducing overflow by changing the size of a database page or increasing the number of pages
Decreasing fragmentation for non-SQL defined databases by:
- Specifying page reserve
- Changing page size
- Reassigning records
- Redefining fragmentation specifications
- Increasing the number of pages
Increasing the efficiency of an index's structure by decreasing the number of levels in the index and/or assigning SR8 records to a separate page range
Reducing logically deleted and/or relocated records by physically deleting logically deleted occurrences using the CLEANUP utility statement and/or unloading and reloading the data
Reducing the number of fragments and/or relocated records by increasing the page size and reading all records in an update mode