This section gives you an overview of the most important administration tasks that you need to perform for your SAP MaxDB database.
Note
The documentation for the SAP MaxDB database system also generally applies to SAP liveCache databases. Differences are indicated in the documentation where necessary. For more information about the administration of SAP liveCache databases, see Database Administration in CCMS: SAP liveCache Technology.
More information: Concepts of the Database System, Technical System Landscape
You can choose one of the following tools to manage and monitor your SAP MaxDB database:
General SAP administration tools, for example DBA Cockpit, CCMS, Database Assistant and Alert Monitor
More information: DBA Cockpit: SAP MaxDB, Database Administration in CCMS: SAP MaxDB
Standalone SAP MaxDB administration tools, for example Database Studio (graphical user interface), Database Manager CLI, Database Analyzer and XCONS (command line tools)
More information: Concepts of the Database System, Database Tools
Perform the tasks in the table below when the corresponding event occurs.
Event |
Task |
Tool |
More Information |
---|---|---|---|
Database OFFLINE |
Start the database (ONLINE operational state) |
DBA Cockpit Database Studio |
|
Database failure with loss of data |
Restoring the Database |
Database Studio |
|
Damaged index |
Restoring the damaged index |
Database Studio |
Restoring Databases |
Performance problems |
Analyzing Slow-Running Transactions |
Database Assistant DBA Cockpit Database Analyzer Database Studio |
|
Database connection to another system required |
Creating a Connection |
Database Assistant Database Studio |
|
New database version available |
Upgrading the database |
SAPInst Installation Manager |
|
System copy required |
Creating a database copy (prerequisite for a system copy) |
SAPInst Database Studio |
|
Other errors |
Analyzing the problem |
Database Assistant Database Studio 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 Studio tool.
Occurrence |
Task |
Tools |
More Information |
---|---|---|---|
Daily |
Monitor the database and check if there are any alerts:
|
Alert Monitor DBA Planning Calendar Database Studio |
|
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. |
DBA Planning Calendar Database Studio |
||
Weekly |
Archiving Backup Files (archiving log backups) Only necessary for log backups on data carriers of the File type |
Operating system commands Database Manager CLI |
|
Scheduling an Interactive Log Backup Only necessary if automatic log backup is switched off |
DBA Planning Calendar Database Studio |
||
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 Studio |
||
Scheduling Updates of the SQL Optimizer Statistics |
DBA Planning Calendar Database Studio |
SAP Note 927882 |