The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

IDUG User View: Real-Life DB2 Superheroes

IBM puts DB2 powers on display at the IDUG conference

Dave Beulke (dave@davebeulke.com), President, Pragmatic Solutions, Inc.

David Beulke is president of Pragmatic Solutions, Inc. (PSI), a training and consulting company that specializes in designing and improving SQL, application, and system performance on DB2 for Linux, UNIX, and Windows, and z/OS. He has experience in the architecture, design, and performance tuning of large data warehouses and OLTP solutions. He is also a former president of IDUG.

Summary: Dave Beulke reports on the IDUG 2010 North America conference, including new features for DB2 10 for zOS, migration stories from users moving from Oracle to DB2, and improved XML functions in DB2 9.7 for Linux, UNIX, and Windows.

IBM Data Management magazine table of contents

View more content in this series

Tag this!

Date: 30 Jul 2010
Level: Introductory
Also available in: Chinese

Activity: 3620 views
Comments:

Read this article in our interactive digital edition format!

I am happy to report that the IDUG 2010 North America conference was a huge success, and I want to send a big thank-you 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).

About the author

Close [x]

Report abuse help

Report abuse

Thank you. This entry has been flagged for moderator attention.

Close [x]

Report abuse help

Report abuse

Report abuse submission failed. Please try again later.

Close [x]

developerWorks: Sign in

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

Close [x]

Choose your display name

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

Rate this article

Comments

Close [x]

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Close [x]

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help

static.content.url=http://www.ibm.com/developerworks/js/artrating/

SITE_ID=1

Zone=Information Management

ArticleID=503441

ArticleTitle=IDUG User View: Real-Life DB2 Superheroes

publish-date=07302010

author1-email=dave@davebeulke.com

author1-email-cc=