Alerts:
Database System Monitoring in CCMS (DB2 UDB for UNIX and Windows) 
Use
The alert monitor analyzes and maintains configuration and snapshot data of IBM DB2 Universal Database for UNIX and Windows. It checks the contents of the admin database mirrored in the SAP system. If these checks find critical situations, for example, if given thresholds are exceeded, alerts are raised. This enables early recognition of critical situations by the database administrator.
Integration
The monitoring functions are fully integrated into the new alert monitor and monitoring architecture.
Features
The following categories of information are currently monitored:
· Disk space of the tablespaces and file systems required for the database system
· Parameters relevant to performance
¡ Access behavior of database buffers
¡ Lock behavior of the application, monitoring of deadlock situations and lock escalations
¡ Recognition of potential candidates for updating table statistics
· Availability of backup and recovery mechanisms
¡ Last available backup
¡ Availability of the log files necessary to achieve the current state of the database from the last available backup.
¡ Status of the admin database mirrored in the SAP system
· Configuration parameters
¡ Database and database manager configuration
¡ Availability data of tablespaces and containers
¡ Proper clean-up of the alert and performance monitoring log tables
We recommend that you check the information displayed on database system monitoring daily in the alert monitor.
See also: