When you should reorganize a database

You should reorganize your database in the following circumstances.

• Database performance has deteriorated. This can happen either because segments in a database record are stored across too many CIs or blocks, or because you are running out of free space in your database.
• There is too much physical I/O to DASD.
• The database structure has changed. For example, you should reorganize a HALDB partition after changing its boundaries or high key.
• The HDAM or PHDAM randomizing routine has changed.
• If a PHIDAM or HIDAM database has large amounts of inserts in a range of root keys without deletes in the same range.
• The HALDB Partitions Selection exit routine has changed.

The DB Monitor can aid in monitoring a database to help you determine when it is time to reorganize your database.