Database Administration for MaxDB
You can use MaxDB databases
● In SAP systems
● Outside of SAP systems
You need to perform a series of tasks to administer a MaxDB database instance.
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.
First Steps
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
See
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
|
Database Assistant Database Analyzer Database Manager |
|
Database connection to another system required |
Database Assistant Outside of SAP systems: Database Manager |
||
New database version available |
Upgrading the database instance |
SAPInst Outside of SAP systems: Database Manager |
service.sap.com/upgradeNW70 ® Upgrade ® Upgrade - SAP NetWeaver 7.0 ® MaxDB ® <os> |
System copy required |
Creating a system copy |
SAPInst Outside of SAP systems: Database Manager |
service.sap.com/installNW70 ® System Copy for SAP Systems Based on NW7.0 |
Other errors |
Database Assistant Database Manager XCONS |
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.
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
|
The Alert Monitor DBA Planning Calendar Database Manager |
|
|
Monitoring CPU usage |
Operating system resources |
|
|
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 |
|
|
Only necessary if automatic log backup is switched off |
DBA Planning Calendar Database Manager |
|
|
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:
Database
Administration in CCMS: MaxDB
Overview of
available documentation for
MaxDB