Alert objects identified during the last successful iteration of a policy evaluation are saved in these alert object repository tables, depending on their object type.
The alert objects are:DB2® creates a number of views on these alert object repository tables. The views and alert object repository tables are created by the DSNTIJCC installation job. Table 1 lists the tables on which each view is defined and the view descriptions. All view names and table names have the qualifier DSNACC.
| View Name | On Table | View Description |
|---|---|---|
| HM_ALERT_TS_RS | HM_MAINT_TS | Displays all table spaces in restricted state |
| HM_ALERT_TS_EX | HM_MAINT_TS | Displays all table spaces whose extents have exceeded a user-specified limit |
| HM_ALERT_TS_RR | HM_MAINT_TS | Displays all table spaces that require REORG |
| HM_ALERT_TS_CR | HM_MAINT_TS | Displays all table spaces that require COPY |
| HM_ALERT_TS_RT | HM_MAINT_TS | Displays all table spaces that require RUNSTATS |
| HM_ALERT_IX_RS | HM_MAINT_IX | Displays all indexes that are in restricted state |
| HM_ALERT_IX_EX | HM_MAINT_IX | Displays all indexes whose extents have exceeded a user-specified limit |
| HM_ALERT_IX_RR | HM_MAINT_IX | Displays all indexes spaces that require REORG |
| HM_ALERT_IX_CR | HM_MAINT_IX | Displays all indexes that require COPY |
| HM_ALERT_IX_RT | HM_MAINT_IX | Displays all indexes that require RUNSTATS |
| HM_ALERT_SG_SS | HM_MAINT_SG | Displays all storage groups that require STOSPACE |