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

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).

Tasks on Demand

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

Recovering the database
Managing Space
Monitoring the system performance
Configuring your database for remote monitoring
Upgrading to a new database version
Performing a system copy

Recovering the Database

In case of database failure with data loss, you have to recover your database.

More information:

Data Recovery and High Availability Guide and Reference at http://www.ibm.com/software/data/db2/udb/support/manualsv9.html
Database Administration Guide: SAP on IBM DB2 for Linux, UNIX, and Windows at https://www.sdn.sap.com/irj/sdn/db6 SAP on DB2 for Linux, UNIX, and Windows Knowledge Center Key Topics Administration

Managing Space

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

More information:

Database Administration Using the DBA Cockpit: IBM DB2 for Linux, UNIX, and Windows at https://www.sdn.sap.com/irj/sdn/db6 SAP on DB2 for Linux, UNIX, and Windows Knowledge Center Key Topics Administration

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

More information:

Configuring your 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.

More information:

Migration to Version 9 of IBM DB2 for Linux, UNIX, and Windows or Migration to Version 9.5 of IBM DB2 for Linux, UNIX, and Windows in SAP Service Marketplace at http://service.sap.com Other Documentation Database Upgrades DB2 UDB .

Performing a System Copy

If required, you perform a system copy.

More information:

System Copy for SAP Systems Based on SAP NetWeaver 7.10 at http://service.sap.com/instguides SAP NetWeaver <Your SAP NetWeaver Release> Installation

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:

Database Administration Guide: SAP on IBM DB2 for Linux, UNIX, and Windows at https://www.sdn.sap.com/irj/sdn/db6 SAP on DB2 for Linux, UNIX, and Windows Knowledge Center Key Topics Administration