SAP MaxDB
Database Administration
SAP MaxDB Security Guide
Concepts of the Database System
Tools
Database Studio
Database Administration in CCMS: SAP MaxDB
Prerequisites
User Menu
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
Configuration of Database Connections
Adding a Database Connection
Changing a Database Connection
Testing a Database Connection
Deleting a Database Connection
Configuring Systems for Remote Monitoring Using the System Lands
Properties
Performance
Activities Overview
OMS Monitor
Class Containers
Schemas
Monitoring Statistics
Transactions
OMS Versions
OMS Locks
Database Analyzer
Bottlenecks
Expert Analysis
SQL Locks
Wait Situations
Overview of SQL Locks
Kernel Threads
Task Manager
Thread Overview
Thread Statistics
I/O Operations
I/O Operations Overview
Backup I/O
SQL Performance
Command Monitor
Resource Monitor
Performance: Performance Warehouse
Performance Warehouse: Reporting
Performance Warehouse: Configuration
Space
Caches
Heap Usage
Data Area
Log Area
Tables/Views/Synonyms
Indexes
Table Sizes
Class Container Sizes
Database Fill Level
Database Activities
DB Procedures
Volumes
Backup and Recovery
Backup Templates
Configuration
System Settings
SYSINFO Views
Error Codes
Critical Sections
Logs
DBA History
System Tables Upgrade
Kernel Administration
Operating Logs
Current Log
History
Jobs
Central Calendar
DBA Planning Calendar
Configuring the Back End of the DBA Planning Calendar
The DBA Log
Alerts
Diagnosis
Missing Tables and Indexes
Messages
Database Manager
Remote SQL Server
Kernel Messages
Current Messages
Old Messages
Error Messages
Message History
Administration
Parameters
Parameter History
Operating (liveCache)
Volumes (Administration)
Tools
Database Manager (CLI)
Database Console
Database Trace
SQLDBC Trace
DBA Planning Calendar
Setting Up and Using the DBA Planning Calendar
Configuring the Back End of 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
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
Using the Central Calendar
Database Monitor
Executing Performance Analysis in CCMS
Database Monitoring
Monitoring the Log Area
Monitoring the Data Area
Index Analysis
SQL Optimizer in CCMS
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
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
Configuration of Database Connections
Adding a Database Connection
Changing a Database Connection
Testing a Database Connection
Deleting a Database Connection
Configuring Systems for Remote Monitoring Using the System Lands
Properties
Performance
Activities Overview
OMS Monitor
Class Containers
Schemas
Monitoring Statistics
Transactions
OMS Versions
OMS Locks
Database Analyzer
Bottlenecks
Expert Analysis
SQL Locks
Wait Situations
Overview of SQL Locks
Kernel Threads
Task Manager
Thread Overview
Thread Statistics
I/O Operations
I/O Operations Overview
Backup I/O
SQL Performance
Command Monitor
Resource Monitor
Performance: Performance Warehouse
Performance Warehouse: Reporting
Performance Warehouse: Configuration
Space
Caches
Heap Usage
Data Area
Log Area
Tables/Views/Synonyms
Indexes
Table Sizes
Class Container Sizes
Database Fill Level
Database Activities
DB Procedures
Volumes
Backup and Recovery
Backup Templates
Configuration
System Settings
SYSINFO Views
Error Codes
Critical Sections
Logs
DBA History
System Tables Upgrade
Kernel Administration
Operating Logs
Current Log
History
Jobs
Central Calendar
DBA Planning Calendar
Configuring the Back End of the DBA Planning Calendar
The DBA Log
Alerts
Diagnosis
Missing Tables and Indexes
Messages
Database Manager
Remote SQL Server
Kernel Messages
Current Messages
Old Messages
Error Messages
Message History
Administration
Parameters
Parameter History
Operating (liveCache)
Volumes (Administration)
Tools
Database Manager (CLI)
Database Console
Database Trace
SQLDBC Trace
DBA Planning Calendar
Setting Up and Using the DBA Planning Calendar
Configuring the Back End of 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
MaxDB/liveCache System Overview
liveCache Assistant
Integration
Creating a Connection
Changing a Connection
Deleting a Connection
User Data
DBM Operator
Standard liveCache User
Centralized/Decentralized Authorization
Administration Reports
Automatic Monitoring
liveCache: Monitoring
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
Heap Usage
Data Area
Log Area
System Settings
Problem Analysis
Performance
Database Analyzer
Bottlenecks
Expert Analysis
Managing Performance Data
OMS Monitor
Class Containers
Class Name
Class ID
Container Number
File ID
Object Size
Container Size
Free Container Pages
Key Pages
Container Usage
Schema
Monitor
Transactions
OMS Versions
OMS Locks
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
Operating Logs
Current Log
History
DBA History
System Tables Upgrade
Kernel Administration
Tables/Views/Synonyms
Indexes
DB Procedures
Statistics
Table Sizes
Class Container Sizes
Administration
Configuration
Parameters
Parameter History
Configuring Volumes
Configuring the Data Area
Configuring the Log Area
Backup Templates
Operating
Start liveCache
Stop liveCache
Initializing liveCache
Registering LCApps
Tools
Database Manager (CLI)
Database Console
Database Trace
SQLDBC Trace
DBA Planning Calendar
Users
Error Codes
System Tables of the SYSINFO Schema
Console
liveCache: Alert Monitor
Standard Web Server
User-Specific Settings
Start Application for liveCache: Monitoring
Selecting a Web Server
CCMS Monitoring
liveCache Alert Monitor
Internal Subtree
Properties
State
Installation
Space Management
Data Area
Log Area
Memory
Performance
Caches
User Tasks
Monitor
Optimizer Statistics
Backup/Recovery
Last Backup
Last Recovery
Health
Bad Indexes
Database Structure Check
External Analysis Tools
Database Analyzer
Connectivity
liveCache Applications
Terms and Procedures
Automating DBA Actions
Backing Up liveCache: Background Processing
Using the Central Calendar
Function Module for Starting/Stopping/Initializing
OneDB
Performance Analysis in CCMS: SAP liveCache
Monitoring the Main Memory Areas
Monitoring OMS Versions
Monitoring the Log Area
Monitoring the Data Area
Database Manager CLI
Loader
SQLCLI
Web SQL
Installing Web SQL Studio
Calling Web SQL Studio
Logging on to the Database
Screen Areas in Web SQL Studio
Executing SQL statements
Opening WebDAV Repositories
Saving SQL Statements
Editing Saved SQL Statements
Displaying the Software Version of Web SQL Studio
Closing Web SQL Studio
Database Analyzer
X Server
XUSER
XCONS
Interfaces
ADO.NET Interface
Java Manual
ODBC Manual
Perl Manual
PHP Manual
Python Manual
SQLDBC Manual
WebDAV Servlet
Tutorials
Database Manager CLI Tutorial
SQL Tutorial
Loader Tutorial
Reference
SQL Reference Manual
Messages
Glossary