Change history event monitoring
The change history event monitor captures information about events on the database server that might impact the running of your regular database workload. You can use the data captured by this event monitor to understand changes in the behavior, performance, or stability of your databases and database management system.
- The unexpected creation or dropping of an index
- The failure of scheduled maintenance to run
- The changing of a database configuration parameter or database registry variable
Manually tracking changes to the database server can be a difficult task. Historically, the information for different types of changes has been captured through different interfaces. For example, configuration updates are written to the diagnostic log files (for example, the db2diag log files), while utility progress is captured in the database history file. The change history event monitor provides you with a single interface that captures the events that change the behavior and performance characteristics of your database system. Using the event monitor tables, you can investigate any change events that are of interest.
- Database and database manager configuration parameter changes
- Registry variable changes
- Execution of DDL statements
- Change history event monitor startup
- Execution of the following database utilities
- ADMIN_MOVE_TABLE procedure invocations
- BACKUP DATABASE (ONLINE option only)
- RESTORE DATABASE (ONLINE option only)
- ROLLFORWARD DATABASE (ONLINE option only)
- REDISTRIBUTE DATABASE PARTITION GROUP