Background documentationDatabase Administration: Overview of Activities Locate this document in the navigation structure

 

The required and recommended database administration activities (DBA activities) are described in the SAP MaxDB documentation Database Administration.

Activities

The table below provides an overview of the DBA activities that are described in the Database Administration documentation, and, if appropriate, links the DBA activities to SAP CCMS functions that are available to perform these activities.

Note Note

The documentation for the SAP MaxDB database system also generally applies to SAP liveCache technology. If there are functional differences, these are explained.

End of the note.

Database Administration

Some Database Administration Options with CCMS Tools

Creating Databases

Use the SAP MaxDB tools available to you to create a database. You can use the CCMS transactions (Integrating a Database System) as an entry point to administer the desired database.

Periodic Administration Tasks

Use the DBA Planning Calendar to schedule important DBA activities:

Automating Administration Tasks

Automating Database Administration Activities

Changing Database Properties

Use the SAP MaxDB tools available to you. You can also change some database properties with CCMS tools:

Monitoring Databases

General information about Database Monitoring and more detailed information:

Backing Up Databases

Backing Up Databases:

Making Snapshots of the Data Area

Use the SAP MaxDB tools available to you to administer snapshots.

Exporting and Importing

Use the SAP MaxDB tools available to you to export and import data.

Managing Users

Use the SAP MaxDB tools available to you. You can also change some user properties with CCMS tools: User Data

Analyzing Database Performance

Executing Performance Analysis in CCMS

Troubleshooting

Troubleshooting

Restoring Databases

  • Check the existing backups, for example using the DBA History.

  • Use the SAP MaxDB tools available to you to restore a database.

  • You can use the CCMS Index Analysis to determine which indexes might be missing.

Replication and High Availability

Use the SAP MaxDB tools available to you to make settings for replication and high availability.

Developing Database Applications

Use the SAP MaxDB tools available to you. For SAP liveCache applications, you can Register LCApps, specify Administration Reports, and analyze the liveCache Applications alert display in the CCMS.