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
When 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 |
Additional Information |
Database OFFLINE |
Switch 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 |
Restore the damaged index |
Database Manager |
|
Performance problems |
Analyze |
Database Assistant Database Analyzer Database Manager |
|
Database connection to another system required |
Database Assistant Outside of SAP systems: Database Manager |
||
New database version available |
Upgrade the database instance |
SAPInst Outside of SAP systems: Database Manager |
service.sap.com/instguides ® Other Documentation ® Database Upgrades ® MaxDB |
System copy required |
Create a system copy |
SAPInst Outside of SAP systems: Database Manager |
service.sap.com/nw04installation ® SAP Web AS ® SAP Web AS 6.40 SR1 Installation and Related Documentation ® Homogeneous and Heterogeneous System Copy |
Other errors |
Database Assistant Database Manager XCONS |
Executing 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 the automatic log
backup. Log backups are the prerequisite for a complete backup
history.
Occurrence |
Task |
Recommended Tool |
Related Information |
Daily |
Monitor the database instance and check if there are any alerts
|
Alert Monitor DBA Planning Calendar Database Manager |
|
|
Monitor 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 |
Only necessary for log backups on backup media 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:
Documentation Database
Administration in CCMS: MaxDB
Overview of
available documentation for MaxDB