Show TOC

Database Administration for IBM DB2 for Linux, UNIX, and WindowsLocate this document in the navigation structure

Use

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

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

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:

Note

Where possible, use the DBA Cockpit for these tasks.

  • 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 on SAP Service Marketplace:

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

    http://service.sap.com/instguidesnwInformation published on SAP site under Start of the navigation path <Your SAP NetWeaver Main Release> Next navigation step Operations Next navigation step Database-Specific Guides End of the navigation path

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

    http://service.sap.com/instguidesnwInformation published on SAP site under Start of the navigation path <Your SAP NetWeaver Main Release> Next navigation step Operations Next navigation step Database-Specific Guides End of the navigation path

  • IBM DB2 High Availability Solution: IBM Tivoli System Automation for Multiplatforms at:

    http://service.sap.com/instguidesnwInformation published on SAP site under Start of the navigation path <Your SAP NetWeaver Main Release> Next navigation step Installation Next navigation step Installation - SAP NetWeaver Systems End of the navigation path

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

    http://service.sap.com/instguidesInformation published on SAP site under Start of the navigation path Database Upgrades Next navigation step DB2 UDB End of the navigation path

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

    http://service.sap.com/instguidesnwInformation published on SAP site under Start of the navigation path <Your SAP NetWeaver Main Release> Next navigation step Installation Next navigation step Installation - SAP NetWeaver Systems End of the navigation path

  • Installation: Systems Based on SAP NetWeaver <Release> at:

    http://service.sap.com/instguidesnwInformation published on SAP site under Start of the navigation path <Your SAP NetWeaver Main Release> Next navigation step Installation Next navigation step Installation - SAP NetWeaver Systems End of the navigation path