DB2 Universal Database Hits

By Matthew Hicks  |  Posted 2002-07-22 Print this article Print

Open Beta"> Self-tuning features are critical to Tim Kuchlein, director of information systems at Clarity Incentive Systems, in New York. He has been beta testing DB2 Version 8 and said that the ability to conduct more tuning in run time without having any database downtime means fewer chances of disrupting customers, who rely on the companys IBM DB2-based database for issuing and processing debit cards. "Were a 24-by-7 shop so stopping the database needs planned and managed, and the less of that we can get the better," Kuchlein said.
He expects features like the Health Center to be helpful for DBAs diagnosing problems but also is taking a wait-and-see attitude about relying exclusively on the automated advice from DB2 over that of experienced DBAs.
"I would imagine 90 percent of the time it would be right on, but until I run it for a while I wont be overly keen to hand over control of the database engine," he said. Along with the autonomic computing focus, IBM also is expanding one of its most touted features of DB2 UDB—federation. Version 8 will expand on the databases ability to tie together data sources that are outside DB2, such as other vendors database systems, by adding support for integrating information from Web services. The capability will allow, for example, a user to join data from a SOAP-based Web service, like a stock feed, with data from other databases and DB2, like customer information, to perform a function, Perna said. "Now DB2 through SQL can evoke data through Web services and federate it," she said. As with most every new database release, IBM also is focusing on beefing up performance and availability. On the performance front, Version 8 offers faster queries for analytical applications. A feature called Multidimensional Clustering allows users to cluster information physically on disk. If an analytical application requires a set of queries they can tell DB2 when they create tables to cluster specific data on disk, which reduces the database I/O overhead during a query. DB2 Version 8 can perform these queries 100 percent faster, Perna said. The feature particularly benefits front-end analytical tools vendors or users who have written their own analytical applications. To improve availability, Version 8 offers additional online reorganization capabilities. The Online Table Reorganization with Data in Place feature keeps data in place during reorganization, rather than moving it to multiple sets of disk, making the table available. The features is making use of capabilities already on IBM DB2 for the OS/390, Perna said. Users interested in the open beta of DB2 Version 8 should go to www.ibm.com/db2/v8beta beginning Tuesday. Related Stories:
  • IBM Gets SMART About Managing DB2
  • DB2 to Widen Reach Again

    Matthew Hicks As an online reporter for eWEEK.com, Matt Hicks covers the fast-changing developments in Internet technologies. His coverage includes the growing field of Web conferencing software and services. With eight years as a business and technology journalist, Matt has gained insight into the market strategies of IT vendors as well as the needs of enterprise IT managers. He joined Ziff Davis in 1999 as a staff writer for the former Strategies section of eWEEK, where he wrote in-depth features about corporate strategies for e-business and enterprise software. In 2002, he moved to the News department at the magazine as a senior writer specializing in coverage of database software and enterprise networking. Later that year Matt started a yearlong fellowship in Washington, DC, after being awarded an American Political Science Association Congressional Fellowship for Journalist. As a fellow, he spent nine months working on policy issues, including technology policy, in for a Member of the U.S. House of Representatives. He rejoined Ziff Davis in August 2003 as a reporter dedicated to online coverage for eWEEK.com. Along with Web conferencing, he follows search engines, Web browsers, speech technology and the Internet domain-naming system.

    Submit a Comment

    Loading Comments...
    Manage your Newsletters: Login   Register My Newsletters

    Rocket Fuel