DB2 10.5 for Linux, UNIX, and WindowsMaintenance health indicators
db.tb_reorg_req - Reorganization Required health indicator
This health indicator tracks the need to reorganize tables or indexes within a database. Tables or all indexes defined on a table require reorganization to eliminate fragmented data. The reorganization is accomplished by compacting the information and reconstructing the rows or index data.
The result might yield an improved performance and freed space in the table or indexes.- Identifier
- db.tb_reorg_req
- Health monitor level
- Database
- Category
- Database Maintenance
- Type
- Collection state-based
- Unit
- Not applicable
You can filter the set of tables evaluated by this health indicator by specifying in your automatic maintenance policy the names of the tables to be evaluated. This can be done using the Automatic Maintenance wizard.
An attention alert might be generated to indicate that reorganization is required. Reorganization can be automated by setting the AUTO_REORG database configuration parameter to ON. If automatic reorganization is enabled, the attention alert indicates either that one or more automatic reorganizations could not complete successfully or that there are tables which require reorganization, but automatic reorganization is not being performed because the size of the table per database partition exceeds the maximum size criteria for tables that should be considered for offline reorganization. Refer to the collection details of this health indicator for the list of objects that need attention.
db.tb_runstats_req - Statistics Collection Required health indicator
This health indicator tracks the need to collect statistics for tables and their indexes within a database. Tables and all indexes defined on a table require statistics to improve query execution time.
- Identifier
- db.tb_runstats_req
- Health monitor level
- Database
- Category
- Database Maintenance
- Type
- Collection state-based
- Unit
- Not applicable
The tables considered by this health indicator can be limited using an SQL query. The scope in the additional information displays the subselect clause on system tables for this query.
An attention alert may be generated to indicate that statistics collection is required. Statistics can be automatically collected by setting the AUTO_RUNSTATS database configuration parameter to ON. If automatic statistics collection is enabled, the attention alert indicates that one or more automatic statistics collection actions did not complete successfully.
db.db_backup_req - Database Backup Required health indicator
This health indicator tracks the need for a backup on the database. Backups should be taken regularly as part of a recovery strategy to protect your data against the possibility of loss in the event of a hardware or software failure.
- Identifier
- db.db_backup_req
- Health monitor level
- Database
- Category
- Database Maintenance
- Type
- State-based
- Unit
- Not applicable
This health indicator determines when a database backup is required based on the time elapsed and amount of data changed since the last backup.
An attention alert might be generated to indicate that a database backup is required. Database backups can be automated by setting the AUTO_DB_BACKUP database configuration parameter to ON. If automatic database backups are enabled, the attention alert indicates that one or more automatic database backups did not complete successfully.