Show TOC

Process documentationUpgrade with DB2 for Linux, UNIX, and Windows Locate this document in the navigation structure

 

You normally upgrades the database management system in line with an SAP upgrade. An upgrade might involve one or more of the following activities:

  • Upgrade of the DB2 for Linux, UNIX, and Windows software

  • Changes to the SAP Data Dictionary

  • Changes to the SAP data stored in DB2 for Linux, UNIX, and Windows

Most upgrades include an upgrade of the DB2 for Linux, 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.

Note Note

You can find more information on upgrading the DB2 for Linux, UNIX, and Windows database at:

  http://service.sap.com/instguides   Database Upgrades   DB2 UDB  

End of the note.

Process

  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.

More Information

Upgrade Guides for DB2 for Linux, UNIX, and Windows at:

  http://service.sap.com/instguides   Database Upgrades   DB2 UDB