Previous Topic: Optimize Query Performance

Next Topic: DB2 Catalog Statistics


Database Reorganizations

You can maximize ReportCenter performance by reorganizing your ReportCenter database at least once a week.

Testing has shown large decreases in service units resulting from database reorganization alone. The ReportCenter database is volatile. New data is added hourly, and after the initial expiration period passes, data is deleted regularly.

Reorganization also reclaims space. Table data sets in large numbers of extents affect performance. Allocate a database large enough for your needs.