Database Administration for IBM Db2 for Linux, UNIX, and Windows

Get an overview of the relevant tools for database administration of IBM Db2 for Linux, UNIX, and Windows and the relevant documentation.

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.

Tasks on Demand

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

Task

Description

Database recovery

In the case of a database failure with data loss, recover the database by Db2 means as described in Database Administration Guide: SAP on IBM Db2 for Linux, UNIX, and Windows.

Space management

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

System performance monitoring

Using the DBA Cockpit, check, for example, the following:

  • 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, upgrade your database to the latest version as described in the appropriate database upgrade guide.

System copy

If required, 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:

  • Schedule regular backups of the 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

For more information, see the following documents:

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

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

  • Installation Guide: IBM Db2 High Availability Solution: IBM Tivoli System Automation for Multiplatforms

  • Upgrade to Version <no> of IBM Db2 for Linux, UNIX, and Windows

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

  • Installation: Systems Based on SAP NetWeaver <Release>

To find the guide relevant for you, use the SAP NetWeaver guide finder.