262 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
Good housekeeping and attention to regular administration tasks can help
maintain a healthy system, as listed here:
Performing regular backups.
Pruning the recovery history file.
Managing the data lifecycle to maintain a high ratio of active data in your
database.
Using MDC tables where appropriate to avoid costly reorganization tasks.
Referencing system logs on a regular basis.
Adhering to best practice recommendations for database design.
Regularly evaluating distribution keys to avoid data skew.
Optim Performance Manager provides two key features that can help you detect
potential problems in advance:
Health monitoring
Performance baselines
6.7.1 Health monitoring
The health monitoring feature allows you to quickly view a list of utilities in
operation, connected applications, and table space details. This can help you
quickly identify if there are anomalies in your environment. You can also set Alert
thresholds to allow you to let Optim Performance Manager monitor your
database and notify you when a threshold has been breached.
Alerts are triggered when a predefined threshold or condition exists on the
configured database or within the Optim Performance Manager application.
Alerts are generated against Performance, Health, and Operational thresholds
Chapter 6. Managing complex query workloads in an operational warehouse environment 263
and events. You configure alerts through the Alert dashboard, as illustrated in
Figure 6-21.
Figure 6-21 An alert to notify of database partition failure
Alerts thresholds can be enabled for a wide and extensive predefined list of
events; for example, the number of connections to the database, table space
container utilization, log space used, application timeouts, or deadlocks. In
addition, alert thresholds can be assigned to an individual database partition or
role.
When enabling performance alerts, keep the following recommendations in
mind:
Limit the number of alert thresholds to those that have a demonstrable effect
on the performance or health of the monitored database.
Get Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
