DB2 10 for LUW Migration

One of the great impacts from attending the IDUG conference is getting the latest DB2 information available from consultants, users and IBM.  It is great to talk directly to users that are experiencing DB2 performance and application issues or ease of use of the tools..  Because I’ve been busy working with my clients and presenting at conferences, I have not had too much time to research and migrate my personal DB2 9.7 system to DB2 10 for LUW.  So during the conference I talked to everyone about their DB2 10 for LUW migration and any considerations or gotchas they may have experienced.

DB2 10 for LUW migration is really important because there are so many great features in the new DB2 10 for LUW release.  I have written about several of the new features before in this blog but since I have been focusing lately on big data systems on DB2 10 for zOS I wanted to experience the DB2 10 for LUW features first hand.

I used the Veterans Day holiday to do my DB2 9.7 to DB2 10 LUW migration.  I felt comfortable with the task since I have done several previous DB2 LUW migrations, talked to DB2 LUW expert Melanie Stopfer and attended her great session, “Best Practice: Upgrade to DB2 10 for LUW,” at the conference. I opened and read through the IBM DB2 10 for LUW manuals and started my DB2 10 for LUW migration.

The first thing I discovered was that I needed to refresh my DB2 10 for LUW manuals.  The manuals I had were from when the DB2 10 for LUW was first announced so I went to the IBM web site and downloaded the new manuals.  I also bookmarked the latest DB2 10 for LUW Information Center link for the very latest information.

Next, remembering my previous DB2 LUW migrations I started by doing all the housekeeping items.  I backed up my system, each of the DB2 instance databases, all the DBM CFG, DB CFG and external routines etc….  I also gathered each of my database’s details by executing the db2support and db2look commands to provide a great deal of detail DB2 LUW pre-migration information.

Remembering Melanie’s presentation and reading the manual I saw the pre-migration considerations which everyone needs to do for their systems.  A few that I ran into were verifying my application usage of XML data types, having enough disk storage for expanding the DB2 Logs, and changing all my Type 1 indexes to Type 2.  The simple query to check your databases for Type 1 indexes is SELECT TABSCHEMA, TABNAME FROM SYSIBMADM.ADMINTABINFO WHERE INDEX_TYPE = 1.  Make sure to execute it as soon as possible because getting time in production may be difficult.

It is time to say goodbye to DB2 Control Center because it is no longer available in DB2 10 for LUW and you have to do all your DB2 work through the new Data Studio or the DB2 command line.  Also there are always items unique to your DB2 LUW implementation so check the manual for the DB2 10 for LUW migration preparation check list to make sure your considerations are resolved before the migration.

Then I performed the DB2 10 for LUW migration for  each of my databases and everything worked out great.  Don’t forget to do one of the things that I did: migrate all of your databases’ Explain Tables. Be sure to  read through all the chapters in the install manuals as there are a lot of other things to the migration. You want to make sure you review  them all because there are too many considerations to cover in this short blog.

Now that everything is completed I am happy to say you should plan you DB2 10 for LUW migration as soon as possible to take advantage of the DB2 10 for LUW features such as Adaptive Compression, Table Partitioning Roll-in, adjustable Storage Groups, PLSQL enhancements, Row and Column Access Column, Time Clustered Tables, XML Enhancements and Time Travel Queries which I will talk about in the coming weeks.

With all these DB2 10 for LUW features now I understand why everyone was so positive on the performance, storage and application improvements they are getting after their DB2 10 for LUW migration.


On December 4th, 5th and 6th I will be presenting at the Minneapolis, Milwaukee and Chicago DB2 Users groups doing my two latest presentations detailed below.  Hopefully you can come out to the meetings and we can have a good questions and answers session about all the big data and Java applications your company is doing.

Agile Big Data Analytics: Implementing a 22 Billion Row Data
This presentation discusses the design, architecture, meta-data, performance and other experiences building a big data and analytics DW system. You will learn through this presentation the real life issues, agile development considerations, and solutions for building a data warehouse of 22+ billion rows in six months. This presentation will help you understand techniques to manage, design and leverage the big data issues for a more in-depth understanding of your business. Also the agile development processes will be detailed showing how to uncovered complex analytics requirements and other issues early in the development cycle. This presentation will help you understand all these experiences that took processes from 37 hours to seconds so you can create a successful big data design and scalable data warehouse analytic architecture.

Java DB2 Developer Performance Best Practices
Can your Java, J2EE DB2 application sustain a large number of client requests simultaneously? Or do they deadlock, become sluggish, or have painfully slow response times? There are many reasons for java performance bottlenecks and many ways to prevent them. However, sometimes it’s just a matter of following some simple best practices that can make all the difference. This presentation will discuss the java developer best practices, coding for optimum DB2 access and some simple changes you can make, some in the design and some in the coding phases that can help your developers build faster, more robust applications.

DB2 User Groups:
Minneapolis: For more information click here
Milwaukee: For more information click here
Chicago: For more information click here


Dave Beulke is an internationally recognized DB2 consultant, DB2 trainer and education instructor.  Dave helps his clients improve their strategic direction, dramatically improve DB2 performance and reduce their CPU demand saving millions in their systems, databases and application areas within their mainframe, UNIX and Windows environments.

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>