Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database

    DB2 Update Frees DBAs From Mundane Tasks

    By
    Matthew Hicks
    -
    July 29, 2002
    Share
    Facebook
    Twitter
    Linkedin

      IBM is aiming to ease the lives of database administrators with Version 8 of its DB2 Universal Database that includes new, automated management features.

      The upgrade, which went into beta testing last week, taps the Armonk, N.Y., companys autonomic computing project to enable the database to manage and tune itself, as well as adds integration capabilities for Web services and performance improvements for analytical applications.

      To tackle management and tuning, the beta includes two key features— Health Center and Configuration Advisor. Health Center not only monitors the database and automatically reports problems, such as performance degradations, to database administrators by e-mail, pager or personal digital assistant but also suggests fixes.

      Beta tester Tim Kuchlein said the capability in Version 8 to conduct more tuning in run-time means fewer chances of disrupting customers. Kuchlein, director of IS at Clarity Incentive Systems Inc., relies on DB2 for issuing and processing debit card information. “Were a 24-by-7 shop, so stopping the database needs to be planned and managed, and the less of that we can get, the better,” said Kuchlein, in New York.

      However, DBAs said IBM still has gaps to fill in helping users avoid database downtime. Version 8 has made strides in cutting out the need for planned downtime, but IBM next must reduce or prevent unplanned downtime as it has done for mainframe databases, said Martin Hubel, an independent consultant in Thornhill, Ontario.

      “It means not only being informed [of outages], but can the software disguise the outage and make sure that there doesnt appear to be an outage [to users]?” Hubel asked.

      Configuration Advisor automates the setup of a database, which often requires DBAs to map parameters such as buffer pool size or size of memory and variables such as the number of users and the amount of memory on a machine. IBMs configurator asks a DBA a series of questions. As a result, a setup process that often took about two weeks can be reduced to about 20 minutes, said Janet Perna, IBMs general manager of data management.

      Version 8 adds support for integrating Web services information, such as a stock feed or other real-time information, Perna said.

      In addition, the upgrade performs some queries up to 100 percent faster through its multidimensional clustering feature, which allows users to cluster information physically on disk, helping to reduce the database I/O overhead during a query, officials said.

      Multidimensional clustering differentiates DB2 from its competitors, said David Beulke, president-elect of the International DB2 Users Group and a consultant at Pragmatic Solutions Inc. “The way it does space management for the database and the way it clusters data is breakthrough technology,” said Beulke, in Alexandria, Va.

      Version 8 will be generally available within six to nine months, Perna said.

      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.

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cybersecurity

      Visa’s Michael Jabbara on Cybersecurity and Digital...

      James Maguire - May 17, 2022 0
      I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      Chris Preimesberger - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cloud

      Yotascale CEO Asim Razzaq on Controlling Multicloud...

      James Maguire - May 5, 2022 0
      Asim Razzaq, CEO of Yotascale, provides guidance on understanding—and containing—the complex cost structure of multicloud computing. Among the topics we covered:  As you survey the...
      Read more
      Big Data and Analytics

      GoodData CEO Roman Stanek on Business Intelligence...

      James Maguire - May 4, 2022 0
      I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×