Database
Administration for MaxDB
You need to perform several administration tasks for your 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 reference documentation.
Getting Started
You
can find information about the concepts of MaxDB in the documentation
Concepts of the
Database System. Use the
Glossary to find a
topic in the MaxDB documentation quickly.
If you
are using MaxDB for the first time, we recommend that you consult the
SQL
Tutorial.
Technical System Landscape
See
Concepts of the Database System,
Technical System
Landscape
Tools
You can choose one of the following tools to manage and monitor your MaxDB database:
● General SAP administration tools, for example CCMS, DBA Cockpit, Database Assistant and Alert Monitor
● Standalone MaxDB administration tools, for example Database Manager GUI (graphical user interface, on Microsoft Windows only), Database Manager CLI (command line tool), Database Analyzer and XCONS (database console)
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 |
Restoring the Database Instance |
Performance problems |
Analyzing Slow-Running Transactions |
Database Assistant Database Analyzer Database Manager |
|
Database connection to another system required |
Creating a Connection |
Database Assistant Database Manager |
|
New database version available |
Upgrading the database instance |
Installation Manager |
|
System copy required |
Creating a database copy (prerequisite for a system copy) |
SAPInst Database Manager |
|
Other errors |
Analyzing the problem |
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: ● Monitoring the Data Area ● Monitoring the Log Area ● Caches (hit rate) ● Activities Overview (I/O, locking, logging) ● User Tasks (database sessions) ● Performance ● Backup/Recovery |
Alert Monitor DBA Planning Calendar Database Manager |
|
|
Monitoring CPU usage |
Operating system commands |
|
|
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 Backup Files (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
|
|
|
Scheduling Updates of the SQL Optimizer Statistics |
DBA Planning Calendar Database Manager
|
More Information
Database Configuration for MaxDB
Overview of available documentation for
MaxDB