Show TOC

Background documentationDatabase Administration for IBM DB2 for Linux, UNIX, and Windows Locate this document in the navigation structure

 

You need to perform various tasks to administer your database in an SAP environment. To do so, you can use either DB2 tools or SAP system tools such as the DBA Cockpit.

Recommendation Recommendation

Where possible, use the tools provided by SAP to perform these tasks.

End of the recommendation.
Tasks on Demand

The following table shows tasks that you need to perform when required:

Task Area

Description

Database recovery

If your database fails with data loss, you recover your database with DB2 means as described in one of the following documents:

  • Data Recovery and High Availability Guide and Reference

  • Database Administration Guide: SAP on IBM DB2 for Linux, UNIX, and Windows

Space management

You check the growth of tablespaces and, if required, maintain your storage settings according to your requirements using the DBA Cockpit.

System performance monitoring

Using the DBA Cockpit, you check, for example:

  • Lock waits and deadlocks

  • Performance snapshots of your database

  • Expensive SQL statements, database cache, and access plans of these SQL statements using the EXPLAIN function

  • Database configuration

Database upgrade

If required, you upgrade your database to the latest version as described in the appropriate database upgrade guide.

System copy

If required, you perform a system copy using the installer as described in the appropriate system copy guide for your SAP NetWeaver Release.
Periodic Tasks

The following list shows tasks that you need to perform periodically.

Note Note

Where possible, use the DBA Cockpit for these tasks:

End of the note.

  • Schedule regular backups of your database using the DBA Planning Calendar.

  • Check the alert message log.

  • Check the database growth.

  • Perform troubleshooting by checking the database logs, that is, the database diagnostic log and database notification log.

More Information

  • Data Recovery and High Availability Guide and Reference in the IBM product documentation

  • Database Administration Guide: SAP on IBM DB2 for Linux, UNIX, and Windows at:

      https://service.sap.com/instguidesnw   <Your SAP NetWeaver Release>   Operations   Database-Specific Guides  

  • Database Administration Using the DBA Cockpit: IBM DB2 for Linux, UNIX, and Windows at:

      https://service.sap.com/instguidesnw   <Your SAP NetWeaver Release>   Operations   Database-Specific Guides  

  • Upgrade to Version <no> of IBM DB2 for Linux, UNIX, and Windows at:

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

  • System Copy for SAP Systems Based on SAP NetWeaver <Release>

      http://service.sap.com/instguidesnw   <Your SAP NetWeaver Release>   Installation