DB2 gets a raft of new features

IBM has added self-management and self-tuning features to its DB2 database which should help users to reduce maintenance costs,...

IBM has added self-management and self-tuning features to its DB2 database which should help users to reduce maintenance costs, writes Eric Doyle.

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.

Read more on Business applications

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchCIO

SearchSecurity

SearchNetworking

SearchDataCenter

SearchDataManagement

Close