Upcoming Events

Executive conference

Cloud Connect March 16-18

Comprehensive thought leadership for executives, IT professionals and developers. Topics include: the ROI, cost and economics of on-demand computing; Migration strategies to move from on-premise to cloud-based IT; Vertical cloud specialization, tailoring features and architectures to specific applications, industries, and customer ecosystems

More Events »

Vendor Newsfeed

More Vendor Newsfeed »

Subscribe to Newsletter

  • Keep up with all of the latest news and analysis on the fast-moving IT industry with Network Computing newsletters.
Sign Up

 
NetNews
N E W S / A N A L Y S I S  


Database, Heal Thyself!

  September 2, 2002
  By Mike Lee


With IBM's release of DB2 version 8, the company has added features intended to reduce stress for database administrators. At first glance, it sounds too good to be true (see www.ibm.com/news/us/2002/07/221.html). For DBAs with control issues, it's probably also creating some fear and trepidation. A closer look verifies that everything isn't quite what IBM wants you to believe, despite the addition of some useful features.

The main additions to the administration package are Configuration Advisor, Design Advisor and Health Center. The Configuration and Design advisors come closest to doing those jobs automatically, but much of their functionality was available in earlier versions of DB2. Based on your basic database design, these advisors will suggest the most efficient and best performing configuration.

The Configuration Advisor, based on version 7's Configure Performance Wizard, will guide you through database-configuration parameters, such as heap size and buffer pool size. The Design Advisor, which started as the Index Wizard, will help with the actual data -- materialized query tables, indexes and partitioning. The Health Center, new to version 8, works like most network monitoring and management packages. It monitors thresholds for database server parameters. When the threshold is crossed, a trigger is tripped.

For the control freaks, DB2 doesn't do things automatically unless you tell it to, and it gives you better access to server parameters through the Health Center. For those who don't need to know the inner workings of the database -- just that it runs well enough -- the new team of advisors should get you there.


--Mike Lee, mlee@nwc.com


Best of the Web

Data deduplication: Declawing the clones

Data deduplication is emerging as a critically important new arrow in the storage administrator's quiver to answer hard questions about the increasing problem in storage growth costs.

Quick Read

Compression, Encryption, Deduplication, and Replication: Strange Bedfellows

One of the great ironies of storage technology is the inverse relationship between efficiency and security: Adding performance or reducing storage requirements almost always results in reducing the confidentiality, integrity, or availability of a system.

Quick Read

WAN Optimization Whitelists and Blacklists

Optimization is a fantastic way of saving money and creating really happy customers at the same time, but it doesn't work flawlessly for all applications.

Quick Read

WAN Optimization as a Managed Service: It's Not About the Cost

This insight examines how organizations outsourcing their WAN optimization initiatives to a third-party go about achieving their goals for application performance, reducing operational costs, and streamlining enterprise infrastructure.

Quick Read

  Sponsored Links

Premium Content

Next Generation Data Center, Delivered, November 17th
NWC


Salary

Video

View All Videos

Most Popular

Stories Blogs

More Stories »

Whitepapers

More »

BlogRoll