Backup, Recovery, and Upgrade with DB2 for LUW

Backups

To avoid data loss, you must always have a recoverable backup of your IBM DB2 for Linux, UNIX, and Windows database.

IBM documentation Data Recovery and High Availability Guide and Reference in the IBM Info Center for DB2 for LUW

Database Administration Guide: SAP on IBM DB2 for Linux, UNIX, and Windows at http://service.sap.com/ instguidesnw under  <Your SAP NetWeaver Release>  Operations  Database-Specific Guides 

Database Administration Using the DBA Cockpit: IBM DB2 for Linux, UNIX, and Windows at http://service.sap.com/ instguidesnw under  <Your SAP NetWeaver Release>  Operations  Database-Specific Guides 

Recovery strategies

You must have a recovery strategy in place that ensures that you can recover your database in the event of a failure or data corruption.

IBM documentation Data Recovery and High Availability Guide and Reference in the IBM Info Center for DB2 for LUW

Database Administration Guide: SAP on IBM DB2 for Linux, UNIX, and Windows at http://service.sap.com/ instguidesnw under  <Your SAP NetWeaver Release>  Operations  Database-Specific Guides 

Database upgrades

You want to upgrade the database management system in the following cases:

• You want to take advantage of new features in an up-to-date DB2 for LUW release.

• A higher database version is required as part of an SAP system upgrade.

Database upgrade guide at http://service.sap.com/instguides under  Database Upgrades  DB2 UDB 

Fix pack installations

Maintenance for IBM DB2 for Linux, UNIX, and Windows is provided through fix packs that are released on a periodic basis. Fix packs contain fixes for known defects. Only the SAP-certified DB2 fix pack levels and DB2 editions are allowed.

We recommend that you keep your DB2 for LUW on an up-to-date fix pack level to avoid that you are exposed to defects that have already been solved.

SAP Note 101809