Real-Life DB2 Superheroes

IBM puts DB2 powers on display at the IDUG conference

I am happy to report that the IDUG 2010 North America conference was a huge success, and I want to send a big thankyou to the leaders and volunteers of the organization for all their time and hard work. The conference featured a large number of DB2 users who represent organizations in vital industries: banks, stock markets, credit cards, and airlines, just to name a few. These companies continue to trust and build new applications on DB2 because of its performance, reliability, and ease of development—not because of a marketing campaign featuring a fantasy comic book character.

At the conference, DB2 users and IBM showcased the latest DB2 10 for z/OS technology, which helps reduce CPU usage by as much as 20 percent according to early IBM testing. With new features such as hash access, index include columns, an increased number of connections, security roles, enhancements to XML within the DB2 engine, and temporal tables, DB2 10 stands to not only save the DB2 community tremendous amounts of CPU processing but also development and overall support time.

For companies that have too many systems and not enough weekends to migrate all of them, DB2 10 offers the opportunity to migrate directly from DB2 8 to DB2 10. This direct migration helps consolidate testing for all DB2 9 and DB2 10 features and can potentially shorten the overall migration time to DB2 10. The opportunity for skip version migration comes around only occasionally and can be a big help when you need to stay current with the latest DB2 capabilities.

DB2 9.7 for Linux, UNIX, and Windows (LUW) got some time in the spotlight, too, as users talked about the ease of migrating from Oracle to DB2, the data and index compression, and the high performance of the XML features. Companies are finding that they can easily migrate their systems from Oracle to DB2 in only days with the help of the IBM migration toolkit. Data and index compression are leading to elapsed-time savings within a company’s application runtime and to dramatically shortened backup processes. And storage savings from compression are significant; from what I’ve heard working with clients and talking to others, the compression features can take databases from terabytes to gigabytes and can improve overall I/O application efficiency by as much as 80 percent.

XML functionality within the DB2 engine—in both DB2 9.7 for LUW and coming soon in DB2 10 for z/OS— provides great support for all types of unstructured data. Many companies are leveraging XML to interface with a variety of legacy and new service-oriented architecture (SOA) systems, and are using their existing IMS skills to build high-performance XML architectures. The DB2 engine excels at XML performance, and the ability to store anything in DB2 provides tremendous flexibility for supporting new mobile, spatial, Web, and other exotic applications.

Even if you didn’t get to this year’s conference, the great wealth of DB2 knowledge shared at the event (and now available on the Web) can answer your questions and help you address your company’s challenges. Check out the IDUG Web site to purchase proceedings from the 2010 conference as well as other North American and European conference information from 2009. There are a lot of great presentations, and when you subscribe to the IDUG Web site you get access to all of them. See you at the next event—IDUG EMEA 2010 in Vienna, Austria, November 8–12 (more conference information is available at