Database Administration in CCMS: SAP DB OLTP
Prerequisites
DBA Planning Calendar
Scheduling Concept
Adding an Action
Action Pattern
Scheduling a Data Backup
Log Backups
Activating Automatic Log Backups
Scheduling an Interactive Log Backup
Scheduling the Updates of the SQL Optimizer Statistics
Scheduling a Database Structure Check
Changing or Deleting an Action
Result of an Action
Troubleshooting
Central DBA Planning Calendar
DBA Action Logs
Warnings about Critical States
Overview of All Database Instances (Transaction DB59)
Central Database Assistant (Transaction DB50N)
Database Assistant
Properties
Name of the Database Connection
DB Name
DB Server
DB Version
DBM Server Version
DB State
Directories
Files
Current Status
Activities Overview
Commands
I/O Activity
Lock Activity
Logging Activity
Scan and Sort Activity
Database Monitoring
Kernel Threads
Task Manager
Refreshing the Display
Terminating an SQL Command/SQL Session
Analyzing Tree Locks
Displaying Task Details
Activate/Deactivate DB Time Measurement
Thread Overview
Thread Statistics
I/O Operations
I/O Operations Overview
Backup I/O
Critical Regions
SQL Locks
Wait Situations (Exclusive)
SQL Locks Overview
Memory Areas
Data Area
Log Area
Caches
System Settings
Transactions
Problem Analysis
Database Bottlenecks
SQL Performance
Command Monitor
Resource Monitor
Messages
Kernel
Current Messages
Old Messages
Error Messages
Terminations
Database Manager
Remote SQL Server
Logs
DBA Action Logs
System Tables Upgrade
Kernel Administration
Tables/Views
Database Trace
Configuration
Parameter
Current Parameters
Change History
Volumes
DB Procedures
Backup Media
System Checks
Statistics
Database Fill Level
Database Activities
Table Size and Growth
Tools
Database Manager CLI
Database Console
Disk Accesses
Process Analysis
Process Overview
Active Tasks
Runnable Tasks
Sleeping Tasks
Task Activities
Suspend Causes
Memory Management
Memory Usage
Critical Regions
Runtime Environment
Wait Queues
Time Needed
User Data
Central/Decentral Authorization
Error Codes
DB Filling/Tables and Indices
CCMS Monitoring
Database Alert Monitor
Space Management
Data Area
Log Area
Performance
Optimizer Statistics
Caches
Bad Indices
Backup/Restore
R/3 Consistency
Health
Optimizer in the CCMS
Statistics for a Single Table
Maintaining the Control Table DBSTATC
Integrating Additional Systems (DB11)
Creating a Connection
Changing a Connection
Deleting a Connection
User Data (New)
DBM Operator
Standard Database User
Alert Monitoring
Terms and Procedures
Database Analyzer
Database Alert Monitor (New)
Database Structure Checks
Index Analysis
Slow-Running Transactions
Determining Table Size and Growth
Checking Available Data Memory Space
Checking Available Log Space