Other additions in DB2 Version 8 include enhanced support for Web services and improved capabilities for integrating data from diverse sources across the enterprise.
A feature called the Health Center automatically provides database administrators (DBAs) with updates about system performance, offers advice about problems, and sends alerts when a fix has been generated.
If a database system runs short of memory or if a query is taking too much time to run, alerts are sent via e-mail or to a pager or PDA. DBAs can then make the required adjustments to the database through a Web browser.
The Configuration Advisor is designed to cut the time it takes to configure a database and reduce the need for manual tuning. DBAs typically need to configure up to 100 parameters for a database. DB2 can now set some of these automatically, based on questions about how the database will be used.
By improving DB2's federation capabilities, IBM has made it easier to pull together information stored in databases from rivals such as Oracle and Microsoft. Developers can also create a single SQL query that will allow DB2 to access information in the form of Web services.