IBM Support

Upgrading to DB2 Version 10.1 roadmap

Preventive Service Planning


Abstract

Upgrading to DB2® Version 10.1 might require upgrading your environment components. These components are DB2 servers, DB2 clients, database applications, and routines. Upgrading these components requires you to understand the DB2 database product upgrade concepts and the DB2 V10.1 database products.

This roadmap will help you navigate through the available information and resources related to upgrading from DB2 Version 9.5 or DB2 Version 9.7 to DB2 Version 10.1.

Content

Your first point of reference to learn how to upgrade each component of your DB2 environment and how to create an upgrade plan is the Upgrading to DB2 Version 10.1 guide. The content of this guide is available in IBM Knowledge Center. The highest level topic of this guide is Upgrade to DB2 Version 10.1.

Table of Contents

Prerequisites

If you are upgrading from DB2 Version 9.1 or earlier, you need to first upgrade to DB2 Version 9.7 or Version 9.5.

Ensure that you meet the operating system and hardware requirements for DB2 Version 10.1 as described in the Installation requirements for DB2 database products topic.

Review changes in Version 10.1 to existing functionality from previous releases that can affect your DB2 environment upgrade: If you are upgrading from DB2 Version 9.5 to Version 10.1, changes to existing functionality between Version 9.7 and Version 9.5 releases can also affect your DB2 environment upgrade. Review the following topic to determine whether you need to manage the effect of these changes: If you are upgrading from DB2 Version 9.7, discontinue using functionality that is unsupported in Version 10.1. If you are upgrading from DB2 Version 9.5, discontinue using functionality that is unsupported in Version 9.7.

Query Patroller is discontinued in Version 10.1, you must remove this functionality before you can upgrade to DB2 Version 10.1. For more details, see the Query Patroller has been discontinued topic.

The Control Center tools and related wizards have been discontinued. IBM® Data Studio and IBM InfoSphere® Optim™ tools are recommended tools for performing tasks that are similar to the tasks that you previously performed using the Control Center tools. These recommended tools also provide enhanced features for tasks previously performed using the Control Center tools. For a mapping between these recommended tools and Control Center tools, see the Table of recommended tools versus Control Center tools. For more details about the discontinuation, see the Control Center tools have been discontinued topic.

There is no utility to fall back to a previous release after upgrading your DB2 servers. Refer to the Planning section for details.

Back to top

Planning

Planning your DB2 environment upgrade requires you to determine a strategy on how to approach your DB2 environment upgrade and create an upgrade plan that includes all of the upgrade process details.

Determine all of the upgrade process details for each component in your environment that you need to know about to write your upgrade plan. For each component, you must include in your upgrade plan:

  • Upgrade prerequisites

  • Pre-upgrade tasks

  • Upgrade tasks

  • Post-upgrade tasks

Review APARs and known issues related to upgrading to DB2 Version 10.1 in the Troubleshooting section. If these issues impact your DB2 environment upgrade, add the actions on how to resolve these issues to your upgrade plan.

To fall back to a previous release after upgrading your DB2 servers, add details about the tasks required to reverse a DB2 server upgrade to your upgrade plan . These details should include any steps required in the upgrade task that enable you to reverse an upgrade.

Plan on how to discontinue the use of deprecated functionality. Consider upgrading your DB2 servers, clients, database applications, and routines in a test environment to learn how to address any issues that might arise during the upgrade process and to evaluate the impact of changes introduced in DB2 Version 10.1. Also in a test environment, you can determine the length of time required to upgrade your database to DB2 Version 10.1 and the disk space requirements that are essential in developing an upgrade plan and performing a successful DB2 environment upgrade.

Adopting new DB2 Version 10.1 functionality​​

Review new features and capabilities in Version 10.1 that you can adopt to enhance your upgraded databases and improve performance. Here are some of the new features and capabilities available in Version 10.1:

Back to top

Upgrading

Follow the upgrade plan for your environment. The DB2 upgrade process for each component of your environment is described on the following topics:

The upgrade process for each component includes:

  • Upgrade prerequisites

  • Pre-upgrade tasks

  • Upgrade tasks

  • Post-upgrade tasks

Back to top

Education

DB2 product education

Webcasts

  • DB2 TechTalk

    You can attend these free webinar series from IBM to learn about the new features of Version 10.1.

Documentation, articles, and white papers

  • Search through DB2 database product documentation. You have access to the entire DB2 Version 10.1 documentation by visiting IBM Knowledge Center. Use the search in IBM Knowledge Center to find related information for upgrading DB2 database products.

  • Search developerWorks for all of the articles on DB2 Version 10.1.

Back to top

Certification

Upgrade your certification

  • IBM Certified Database Associate - DB2 10.1 Fundamentals

    If you are not certified as IBM Certified Database Associate - DB2 9 Fundamentals, take the Exam 610 - DB2 10.1 Fundamentals to obtain the IBM Certified Database Associate - DB2 10.1 Fundamentals certification.

  • IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows

    If you are currently certified as IBM Certified Database Associate - DB2 9 Fundamentals or IBM Certified Database Associate - DB2 10.1 Fundamentals, take the Exam 611 - DB2 10.1 DBA for Linux, UNIX, and Windows to obtain the IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows certification.

Web-based tutorials

Product documentation for DB2 certification exams

  • PDFPreparation Guide for DB2 10.1 Fundamentals Exam 610
  • PDFPreparation Guide for DB2 10.1 DBA for Linux, UNIX, and Windows Exam 611

Professional certification roadmap

Back to top

Troubleshooting

You can find information about errors from a DB2 upgrade in the following files:

  • log file name that you specified when you issue the db2ckupgrade command. For details, see Verifying that your databases are ready for upgrade.

  • db2diag.log when you run the commands to upgrade instances and databases. Diagnostic information is also captured if you have set the DIAGLEVEL database manager configuration parameter to 3 (default value) or higher.

You can find information about known issues or defects in the following references:

Back to top

Additional resources

Additional resources to help you with DB2 database product upgrades are available at: Additional resources to help you with upgrades for DB2 products and migration of software that use DB2 database products such as DB2 Content Manager and SAP systems are available at the DB2 upgrade portal.

Back to top

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Instance","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21573228

Page Feedback