Planning your DB2 servers upgrade

Planning the upgrade of DB2® servers requires that you review all of the applicable upgrade prerequisites, pre-upgrade tasks, upgrade tasks and post-upgrade tasks.

To create an upgrade plan for your DB2 servers:

1. Write the upgrade plan for DB2 servers, using all of the details that apply to your environment:

   Table 1. Upgrade plan details for DB2 servers.

   Upgrade plan	Details
   Prerequisites	Ensure that you: meet the installation requirements for DB2 database products. resolve any support issues described in upgrade essentials for DB2 servers. meet all prerequisites for the upgrade task and subtasks, especially obtaining root or Local Administrator access and required DB2 authorization.
   Pre-upgrade tasks	Include the following tasks: Upgrade your DB2 server in a test environment to determine any upgrade issues Verify that databases are ready for DB2 upgrade Back up your databases Back up configuration information Increase table space and log file sizes If the diaglevel database manager configuration parameter is set to 2 or less, set this parameter to 3 or higher. Take the DB2 server offline for DB2 upgrade In addition, check the list of pre-upgrade tasks for optional tasks that you might want to perform for your environment such as upgrading your DB2 server in a test environment.
   Upgrade task	You must include these steps: Install DB2 Version 9.7 Upgrade instances Upgrade the DAS Upgrade databases Review the following upgrade tasks to determine the additional steps that are required to upgrade your environment: Upgrading a DB2 server (Windows) Upgrading a DB2 server (Linux and UNIX) Upgrading environments with specific characteristics Take note of the time required to upgrade your databases.
   Post-upgrade tasks	Include the following tasks: Reset the diaglevel database manager configuration parameter to the value set before the upgrade Adjust the log space size Activate your database after upgrade Manage changes in DB2 server behavior Rebind packages in upgraded databases Upgrade DB2 Explain tables Update the statistics on the system catalog tables. Verify that your DB2 server upgrade was successful Back up your databases after the upgrade is complete In addition, check the list of post-upgrade tasks for optional tasks that you might want to perform for your environment. Consider adding the following tasks to your upgrade plan: Tune your DB2 server after the upgrade is completed Remove the use of deprecated functionality in DB2 Version 9.7 Adopt new functionality in upgraded databases, where appropriate, to improve performance at the DB2 server level. Review manageability, performance, and scalability enhancements in What's New for DB2 Version 9.7 to determine what new functionality you might want to apply to your environment

2. If you must be able to reverse the upgrade, add details to the plan about the tasks required to reverse a DB2 server upgrade. These details should include any steps required in the upgrade task that enables you to reverse the upgrade.
3. Combine with the upgrade plan for other components such as clients, database applications, and routines to create an overall upgrade plan for your DB2 environment.