Database Administration for MaxDB 
You can use MaxDB databases
In SAP systems
Outside SAP systems
You need to perform a series of tasks to administer a MaxDB database instance.
Note
This section gives you an overview of the most important administration tasks. The links in this section point you to the detailed information found in the MaxDB documentation.
Getting Started
If you are using MaxDB for the first time, we recommend you consult the SQL Tutorial.
You can find information on the concepts of MaxDB in the documentation Concepts of the Database System; of particular interest is the section Administration. Use the Glossary to find a topic in the MaxDB documentation quickly.
Technical System Landscape
Tools
The following tools are available for administering and monitoring your MaxDB database instance:
DBA Planning Calendar (only available in SAP systems)
Database Assistant (only available in SAP systems)
Alert Monitor (only available in SAP systems)
Database Manager: Database Manager GUI (graphical user interface) and Database Manager CLI (command line tool)
Database console XCONS
Tasks on Demand
Perform the tasks in the table below when the corresponding events occur.
Event |
Task |
Tool |
More Information |
|---|---|---|---|
Database OFFLINE |
Switching the database instance to the ONLINE operational state (start) |
Database Assistant Database Manager |
|
Database instance failure with loss of data |
Restoring the Database Instance |
Database Manager |
|
Damaged index |
Restoring the damaged index |
Database Manager |
|
Performance problems |
Analyzing Slow-Running Transactions |
Database Assistant Database Analyzer Database Manager |
|
Database connection to another system required |
Database Assistant Outside SAP systems: Database Manager |
||
New database version available |
Upgrading the database instance |
SAPInst Outside SAP systems: Installation Manager |
http://service.sap.com/upgradeNW2004s
|
System copy required |
Creating a system copy |
SAPInst Outside SAP systems: Database Manager |
http://service.sap.com/installNW2004s |
Other errors |
Database Assistant Database Manager XCONS |
Upgrade 
Upgrade - SAP NetWeaver 7.0 
Periodic Tasks
Regularly perform the tasks listed in the table below. In SAP systems, use the DBA Planning Calendar for these tasks whenever possible. Outside of SAP systems, use the Database Manager tool.
Recommendation
We recommend that you activate automatic log backup. Log backups are the prerequisite for a complete backup history.
Occurrence |
Task |
Recommended Tool |
More Information |
|---|---|---|---|
daily |
Monitor the database instance and check if there are any alerts Caches (hit rate) Activities Overview (I/O, locking, logging) User Tasks (database sessions) |
Alert Monitor DBA Planning Calendar Database Manager |
|
Monitoring CPU usage |
Operating system resources |
||
Scheduling a complete data backup If you cannot or do not want to perform a complete data backup every day, then you should perform at least an incremental data backup on each productive day. The more current the last data backup is, the fewer log entries have to be imported again if you need to restore the database instance. |
DBA Planning Calendar Database Manager |
||
weekly |
(Archiving log backups) Only necessary for log backups on data carriers of the File type |
Operating system commands Database Manager |
|
Scheduling an Interactive Log Backup Only necessary if automatic log backup is switched off |
DBA Planning Calendar Database Manager |
||
Scheduling a Database Structure Check We recommend that you check the database structures at times when the database load is low, or using a system copy. |
DBA Planning Calendar Database Manager |
||
DBA Planning Calendar Database Manager |
See also:
Documentation: Database Administration in CCMS: MaxDB
Overview of available documentation for MaxDB