Database Administration in CCMS: SAP MaxDB
Database Administration: Overview of Activities
Integrating a Database System
Automating Database Administration Activities
Executing Performance Analysis in CCMS
Database Monitoring
Monitoring the Log Area
Monitoring the Data Area
Index Analysis
SQL Optimizer in CCMS
Troubleshooting
Prerequisites
DBA Cockpit: SAP MaxDB
The DBA Cockpit
Central System Data
Maintenance Actions in the DBA Cockpit
Configuration of Systems for Remote Monitoring
Configuring Systems for Remote Monitoring Using Remote Database Connections
Configuring Systems for Remote Monitoring Using the System Landscape Directory (SLD)
Current Status
Properties
Name of the Database Connection
Operational State
Standard Database User
Database Server and Versions
Database Name
Operating (liveCache)
Bridge System (Teradata)
System Information
Performance
Activities Overview
Activities History
Monitoring Statistics
Transactions
OMS Versions
OMS Monitor
Performance: Performance Warehouse
Performance Warehouse: Reporting
Performance Warehouse: Configuration
Database Analyzer
Bottlenecks
Expert Analysis
Managing Performance Data
SQL Performance
(Command Monitor)
Resource Monitor
Locks
SQL Locks: Overview
SQL Locks: Wait Situations
OMS Locks
Kernel Threads
Task Manager
Thread Overview
Thread Statistics
I/O Operations
I/O Operations Overview
Backup I/O
Space
Caches
Data Area
Log Area
Database Fill Level
Snapshots
OMS Heap Usage
Jobs
Central Calendar
DBA Planning Calendar
The DBA Log
Setting Up the DBA Planning Calendar
Alerts
Diagnosis
Missing Tables and Indexes
SELECT Editor
Database Files
Critical Sections
Database Console
Database Trace
SQLDBC Trace
SYSINFO Views
Error Codes
Messages
Kernel Messages
Current Messages
Old Messages
Error Messages
Kernel Messages: History
Database Manager
DBA History
Remote SQL Server
System Tables Upgrade
liveCache Operating
Current Log
History
Database Objects
Tables/Views/Synonyms
Indexes
DB Procedures
Table Sizes
OMS Class Containers
OMS Class Container Sizes
OMS Schemas
OMS Object Browser
Administration
Parameters
Parameter History
Backup Templates
Tools
Database Manager (CLI)
User Menu
DBA Planning Calendar
Setting Up and Using the DBA Planning Calendar
Setting Up the DBA Planning Calendar
Planning Concept
Scheduling an Action
Action Patterns
Scheduling a Data Backup
Scheduling Log Backups
Activating Automatic Log Backup
Scheduling an Interactive Log Backup
Archiving Backup Files
Scheduling Updates of the SQL Optimizer Statistics
Scheduling a Database Structure Check
Changing or Deleting an Action
Starting an Action Immediately
Displaying Actions
DBA Action Logs
MaxDB/liveCache System Overview
Database Assistant
Properties
Name of the Database Connection
Database Name
Database Server and Versions
Operational State
Directories
Files
Alert Monitor
Current Status
Activities Overview
Configuration (Volumes)
Volumes
Kernel Threads
Task Manager
Thread Overview
Thread Statistics
I/O Operations
I/O Operations Overview
Backup I/O
Critical Sections
Memory Areas
Caches
Data Area
Log Area
System Settings
Problem Analysis
Performance
Database Analyzer
Bottlenecks
Expert Analysis
Managing Performance Data
Transactions
SQL Locks
Wait Situations (Exclusive)
Overview of SQL Locks
SQL Performance
Command Monitor
Resource Monitor
Messages
Kernel
Current Messages
Old Messages
Error Messages
Message History
Database Manager
Remote SQL Server
Logs
DBA History
System Tables Upgrade
Tables/Views/Synonyms
Indexes
DB Procedures
Statistics
Database Fill Level
Database Activities
Table Sizes
Administration
Configuration
Parameters
Parameter History
Backup Templates
Tools
Database Manager (CLI)
Database Console
Database Trace
SQLDBC Trace
DBA Planning Calendar
Displaying/Changing Integration Data
Creating a Connection
Changing a Connection
Deleting a Connection
User Data
DBM Operator
Standard Database User
Centralized/Decentralized Authorization
Automatic Monitoring
Error Codes
System Tables of the SYSINFO Schema
CCMS Monitoring
Database Alert Monitor
Internal Subtree
Properties
State
Hot Standby
Installation
Space Management
Data Area
Log Area
Performance
Caches
User Tasks
Monitor
Optimizer Statistics
Backup/Recovery
Last Backup
Last Recovery
SAP Consistency
Health
Bad Indexes
Database Structure Check
External Analysis Tools
Database Analyzer
Connectivity
DB Filling/Tables and Indexes
Terms and Procedures
SAP Notes
Using the Central Calendar
Database Monitor
Database Administration in CCMS: SAP liveCache Technology
Authorization Concept
SAP_BC_LVC_USER
SAP_BC_LVC_OPERATOR
SAP_BC_LVC_ADMINISTRATOR
SAP_BC_LVC_SUPERUSER
liveCache Assistant
Integration
Creating a Connection
Changing a Connection
Deleting a Connection
User Data
Standard liveCache User
Administration Reports
Automatic Monitoring
liveCache: Monitoring
Heap Usage
OMS Locks
OMS Monitor
Class Container
Class Name
Class ID
Container Number
File ID
Object Size
Container Size
Free Container Pages
Key Pages
Container Usage
Monitor
scheme
OMS Versions
Operating Logs
Current Log
History
Kernel Administration
Configuring Volumes
Configuring the Data Area
Configuring the Log Area
Operating
Starting liveCache
Stopping liveCache
Initializing liveCache
Registering LCApps
Statistics
Class Container Sizes
Users
Console
liveCache: Alert Monitor
Start Application for liveCache: Monitoring
liveCache Alert Monitor
Memory
liveCache Applications
Performance Analysis in CCMS: SAP liveCache
Monitoring the Main Memory Areas
Monitoring OMS Versions
Function Module for Starting/Stopping/Initializing
OneDB