Articles & Content

Archives

How I Spent My Christmas Holiday Upgrading to DB2 V9.7 Fixpack 1 from V9 - Is It Worth It? (C09)

Topic: 2011 NA

Subtopic: DB2 for LUW



DATE: 2011-5-5 (08:30 AM - 09:30 AM)
SPEAKERS: Vijay Sitaram (McKesson Corp ), Melanie Stopfer (IBM Software Group)

My manager immediately approved upgrading from DB2 LUW V9.1 to 9.7 which is a well documented process and laid out the steps. After installing the code on our UAT box, results were desirable and everything ran as smooth as butter! During Christmas holidays, I implemented new features such as currently committed, LOB inlining, LOB compression, index compression, and more. Come learn which of these features gave me the most bang for the buck! I also experienced some problems and worked with IBM Support on several Optimizer and Index related issues. Come to this session and benefit from lessons I learned the hard way. Learn what steps you should take to make your production deployment successful.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Plan the installation and migration to DB2 9.7 Fix Pack 1 - Path to Upgrade: Discuss the steps taken to plan the upgrade project with senior management. Reference documents used and best practices taken into consideration prior to the upgrade.

After the Upgrade - Verification is Key! Test cases run after the upgrade immediately to measure query performance, ETL performance, database stability and Application Server stability. Did the upgrade pass or fail?

Realizing the Power of DB2 LUW V9.7 Fix Pack 1 Features - Describe the new functions and options for administration of DB2 databases provided by DB2 9.7 Fix Pack 1; Talk about LOB Compression and IN-LINING, Index compression, Temp Table compression, partitioned indexes and new concurrency model (current committed)

Query Performance Considerations: Discuss various steps taken to measure before and after upgrade changes to query performance. Issues addressed with IBM Optimizer team and the special builds, registry keys and workaround provided to restore query performance. Also address query response time improvements and success factors to call the upgrade a success!

Lessons Learned & DB2 LUW 9.7 Features Under Consideration: Capture lessons learned over weeks of work with IBM specialists, working with internal dev team, working with management team and ultimately how it all turned out to be successful



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.