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 use DB2 tools or the DBA Cockpit (in the SAP system).

Recommendation Recommendation

We recommend that you perform the various tasks using the DBA Cockpit.

End of the recommendation.
Tasks on Demand

The tasks on demand can be divided into the following areas:

Task Area

Description

Recovering the database

In case of database failure with data loss, you have to recover your database 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

Managing space

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

Monitoring the system performance

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

Configuring the database for remote monitoring

Using the DBA Cockpit, you can configure your database system either using database information that is stored in the system landscape directory (SLD) for automatic generation and update of system entries or manually using database connections and system entries.

Upgrading to a new database version

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

Performing a system copy

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

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

Note Note

Whenever possible, use the DBA Planning Calendar for these monitoring tasks. You can choose from a range of predefined action patterns that include the tasks listed here.

End of the note.

  • Backup and recovery of your database

  • Checking the alert message log

  • Checking the database growth

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

More Information