

"I think IBM with Stinger is making a great stride forward with reducing the amount of database administration time."įor clustered environments, the new release offers Automatic High-Availability Disaster Recovery, with automatic client reroute. With Stinger, IBM is continuing its feature war with Oracle, said analyst Donald Feinberg, vice-president at analyst firm Gartner. Additionally, automated maintenance within the database performs administration and maintenance such as table maintenance or data backups.

The autonomic features will enable faster retrieval and management of information such as customer history, product pricing, and product availability. IBM's last release of DB2 Universal Database, Version 8.1, shipped in November 2002. "It's a major release focusing on automation and cost savings," said Jeff Jones, IBM director of strategy for DB2 information management software. With the tool, query jobs in Version 8.2 can be completed nearly seven times faster than if done manually, the supplier said. IBM Learning Optimiser, which allows the database to learn from past experiences and accelerates searches by uncovering the fastest route to information, is featured as part of IBM's autonomic efforts.Īnother tool in the database, DB2 Design Advisor, automatically designs and optimises databases. Version 8.2 of the database, code-named Stinger, features autonomic capabilities for self-managing and tuning, reducing the time required for administration by as much as 65%, according to the company.
