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.
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:
|
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:
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.
For more information, see the following documents on SAP Service Marketplace:
Database Administration Guide: SAP on IBM DB2 for Linux, UNIX, and Windows at:
Database Administration Using the DBA Cockpit: IBM DB2 for Linux, UNIX, and Windows at:
IBM DB2 High Availability Solution: IBM Tivoli System Automation for Multiplatforms at:
Upgrade to Version <no> of IBM DB2 for Linux, UNIX, and Windows at:
System Copy for SAP Systems Based on SAP NetWeaver <Release> at:
Installation: Systems Based on SAP NetWeaver <Release> at: