Database Administration: Overview of Activities

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: Scheduling a Data Backup Activating Automatic Log Backup Scheduling Interactive Log Backups Archiving Backup Files Scheduling Updates of the SQL Optimizer Statistics Scheduling a Database Structure Check
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: User Data Data Area Log Area Database Parameters Scheduling Updates of the SQL Optimizer Statistics Activating Automatic Log Backup
Monitoring Databases	General information about Database Monitoring and more detailed information: Monitoring the Data Area Monitoring the Log Area Monitoring accesses to Caches Monitoring backups, for example with the DBA History Monitoring database activities using the Activities Overview Monitoring the number of database sessions, for example with the User Tasks alert display
Backing Up Databases	Backing Up Databases: Designing a Planning Concept Creating Backup Templates Scheduling Data Backups and Log Backups. Checking the backup actions, for example with the DBA History and the DBA Planning Calendar (Displaying Actions, Scheduling an Action)
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.

Database Administration: Overview of Activities

Activities

More Information