Close
  • Latest News
  • Artificial Intelligence
  • Video
  • 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
  • Artificial Intelligence
  • Video
  • 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

    Written by

    Matthew Hicks
    Published July 29, 2002
    Share
    Facebook
    Twitter
    Linkedin

      eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

      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
      Matthew Hicks
      Matt Hicks covers the fast-changing developments in Internet technologies. His coverage includes the growing field of Web conferencing software and services. With over 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. Along with Web conferencing, he follows search engines, Web browsers, speech technology and the Internet domain-naming system.

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      MOST POPULAR ARTICLES

      Artificial Intelligence

      9 Best AI 3D Generators You Need...

      Sam Rinko - June 25, 2024 0
      AI 3D Generators are powerful tools for many different industries. Discover the best AI 3D Generators, and learn which is best for your specific use case.
      Read more
      Cloud

      RingCentral Expands Its Collaboration Platform

      Zeus Kerravala - November 22, 2023 0
      RingCentral adds AI-enabled contact center and hybrid event products to its suite of collaboration services.
      Read more
      Artificial Intelligence

      8 Best AI Data Analytics Software &...

      Aminu Abdullahi - January 18, 2024 0
      Learn the top AI data analytics software to use. Compare AI data analytics solutions & features to make the best choice for your business.
      Read more
      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Video

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      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.
      © 2024 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.

      ×