Show TOC

Background documentationDatabase Administration for SAP MaxDB Locate this document in the navigation structure

 

This section gives you an overview of the most important administration tasks that you need to perform for your SAP MaxDB database.

Note 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.

End of the note.
Technical System Landscape

More information: Concepts of the Database System, Technical System Landscape

Tools

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

Tasks on Demand

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

Operational State

Database failure with loss of data

Restoring the Database

Database Studio

Restoring Databases

Damaged index

Restoring the damaged index

Database Studio

Restoring Databases

Performance problems

Analyzing Slow-Running Transactions

Database Assistant

DBA Cockpit

Database Analyzer

Database Studio

Analyzing Database Performance

Database connection to another system required

Creating a Connection

Database Assistant

Database Studio

Database Connection

New database version available

Upgrading the database

SAPInst

Installation Manager

Installation

System copy required

Creating a database copy (prerequisite for a system copy)

SAPInst

Database Studio

Database Copy

Other errors

Analyzing the problem

Database Assistant

Database Studio

XCONS

Troubleshooting

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 Studio tool.

Occurrence

Task

Tools

More Information

Daily

Monitor the database 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 Studio

Monitoring Databases

Monitoring CPU usage

Operating system commands

Processes

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

Backing Up Data

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

Archiving Backup Files

Scheduling an Interactive Log Backup

Only necessary if automatic log backup is switched off

DBA Planning Calendar

Database Studio

Backing Up Log Entries

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

Checking Database Structures

Scheduling Updates of the SQL Optimizer Statistics

DBA Planning Calendar

Database Studio

SQL Optimizer Statistics

SAP Note 927882