Upgrade with DB2 UDB for UNIX and Windows

Purpose

Upgrades of the database management system are usually done in line with an SAP upgrade. An upgrade might involve one or more of the following activities:

·        Upgrade of the DB2 UDB for UNIX and Windows software

·        Changes to the SAP Data Dictionary

·        Changes to the SAP data which is stored in DB2 UDB for UNIX and Windows

Most upgrades include an upgrade of the DB2 UDB for UNIX and Windows software and changes to the SAP system Data Dictionary. The elapsed time for a database upgrade as part of an SAP upgrade is around one hour. When upgrading to a new SAP release, database upgrade is a minor part of the overall upgrade. You cannot use the database for normal operation during an upgrade.

You can find more information on upgrading the DB2 UDB for UNIX and Windows database on SAP Service Marketplace:

service.sap.com/instguides ® Other Documentation  ® Database Upgrades

Process Flow

...

       1.      You read the upgrade documentation.

This helps to avoid unexpected problems during the upgrade.

       2.      You plan the upgrade.

Rather than simply starting the upgrade and hoping for the best, plan the procedures involved in advance. Make sure that all the resources (that is, people and equipment) are available.

       3.      You rehearse the upgrade using a test system.

The best preparation of all is to rehearse the upgrade fully using a test system that is as similar to the production system as possible.

Result

You can now upgrade the database with the minimum possible downtime.

See also:

Migration to Version X of the IBM DB2 Universal Database for UNIX and  Windows

You can find the above documentation on SAP Service Marketplace at:

service.sap.com/instguides ® Other Documentation  ® Database Upgrades