DB2 10 to DB2 11 migration initial status

We started migrations of the DB2 subsystems, that our organization supports, prior to the creation of this BLOG site but I will post a chronology of our migrations and the issues we have experienced up to now and continue with updates as we continue our migration efforts.  We are migrating from DB2 10 to DB2 11 and we currently support applications across 40 DB2 subsystems with 17 being test and 23 being production.  We have completed migration of all 17 test subsystems and 4 of the 23 production but currently awaiting PTF fixes for two APARs that were opened related to issues we identified.  Our next migrations are not planned now until February while we wait for the APARs to be finalized and PTFs to be created for our testing.  We did test APAR fixes for both issues and they did correct the SQL performance problems we experienced.

Author: Scott Goodell

DB2 z/OS DBA specializing in database performance with database design and SQL coding.