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.
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.
See Technical System Landscape
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
Perform the tasks in the table below when the corresponding events occur.
Event |
Task |
Tool |
Related 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 Slow-Running Transactions |
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 |
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 |
Related 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 |
|
|
Monitor 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 backup media 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