Datenbankverwaltung in CCMS

CCMS: Oracle

Getting Started in CCMS with Oracle DBA

DBA Cockpit

Central System Data

Pflegeaktionen im DBA Cockpit

Displaying the Audit Log

Konfiguration von Systemen für entferntes Monitoring

Systeme für entferntes Monitoring über entfernte Datenbankverbin

Konfiguration von Datenbankverbindungen

Adding a Database Connection

Datenbankverbindung ändern

Datenbankverbindung testen

Datenbankverbindung löschen

Systeme für entferntes Monitoring mithilfe des System Landscape

Performance (Oracle)

SAP/Oracle Database Monitor

Performance Overview

Viewing History Information

Wait Event Analysis

Session Monitor

Buffer Busy Waits

System Event

System Event History

Filesystem Requests

Enqueue Stat

Lock Monitor

Latch Monitor

Active Session History

Workload Reporting

SQL Statement Analysis

Shared Cursor Cache

Table Access

Column Usage

System Statistics for the CBO

Statistical Information

SGA Monitor

PGA Monitor

Undo Statistics

Performance Database

DB Overview Script

System Metrics

System Summary Metrics

File Metrics

Wait Class Metrics

Feature Monitoring

Automatic Segment Space Management

Online Redefinition

Resumable Space Allocation

Parallel Query

Additional Functions

SQL Command Editor

Display GV$-Views

Display DBA Tables

Database Parameters

Alert Log

Checkpoints

Oracle Net

User End to End Trace

User End to End Stats Trace

Program End to End Trace

Program End to End Stats Trace

RAC Statistics

Real Cache Get Hit Ratio

Global Cache Fusion Block Hit Ratio

Block Shipping for Current Blocks

Block Shipping for CR Blocks

Fusion to Physical Writes Ratio

Global Cache CR Blocks Received

Global Cache Current Blocks Receive

Global Cache CR Block Send

Global Cache GES Convert

Global Cache Get Hit Ratio

Global Cache GCS Gets

Global Cache Hit Ratio

Global Cache Flushes to Redo

Global Cache CR Block Hit Ratio

Global Cache Defer Ratio

Global Cache Current Block Hit Ratio

Global Cache Current Blocks Send

Global Cache GES Lock Gets

Overview System Statistics

Overview Library Cache

Current Block Server

Space (Oracle)

Space Overview

Space Statistics Collector

Database Overview

Users Overview

Users Detailed Analysis

Tablespaces Overview

Tablespaces Detailed Analysis

Segments Overview

Segments Detailed Analysis

Segments Detailed Analysis (Aggregated)

Collector Logs

BW Analysis

Jobs (Oracle)

Zentraler Kalender

Zentralen Kalender verwenden

DBA Planning Calendar (Oracle)

Setting Up the DBA Planning Calendar (Oracle)

Configuring the Back End of the DBA Planning Calender (Oracle)

Scheduling an Action (Oracle)

Changing an Action (Oracle)

Deleting an Action (Oracle)

Re-Executing an Action (Oracle)

Displaying the Status of a Day's Actions (Oracle)

Displaying Scheduled Actions (Oracle)

Troubleshooting (Oracle)

Displaying DBA Logs (Oracle)

Display of the Backup Logs (Oracle)

Displaying Logs for Database Backups (Oracle)

Displaying Logs for Redo Log Backups (Oracle)

Displaying the Recovery Report (Oracle)

Database System Check

Configuring Database System Check (Oracle)

Displaying Alert Messages from Database System Check

Update Statistics for the Cost-Based Optimizer in CCMS (Oracle)

Updating Statistics in the DBA Planning Calendar (Oracle)

Updating Statistics for a Single Table (Oracle)

Updating Statistics for Groups of Tables in CCMS (Oracle)

Configuring Update Statistics in CCMS (Oracle)

Maintaining Database Connection Information

Maintaining Database Parameters (Oracle)

Monitoring the Oracle Database

Space Management Alerts

Database Performance Alerts

Database Backup and Restore Alerts

Database Consistency Alerts

Database Health Alerts

Information on Oracle Database Alerts

CCMS: Informix

Erste Schritte im CCMS mit Informix-DBA

Zentraler Kalender

Zentralen Kalender verwenden

Purpose

Einplanungsmuster im DBA-Einplanungskalender wählen

Aktionen im DBA-Einplanungskalender einplanen

Datenbank im DBA-Einplanungskalender archivieren oder sichern (I

Logisches Protokoll im DBA-Einplanungskalender sichern (Informix

Logisches Protokoll im DBA-Einplanungskalender automatisch siche

Statistiken im DBA-Einplanungskalender prüfen (Informix)

Statistiken im DBA-Einplanungskalender aktualisieren (Informix)

Physische Konsistenz im DBA-Einplanungskalender pr

DB-System im DBA-Einplanungskalender prüfen (Informix)

Fehleranalyse im DBA-Einplanungskalender (Informix)

Update Statistics im CCMS (Informix)

Statistiken einer einzelnen Tabelle im CCMS prüfen und aktualisi

Update Statistics im CCMS konfigurieren (Informix)

DB-Systemprüfungen im CCMS (Informix)

DB-Systemprüfungen im CCMS konfigurieren (Informix)

DB-Systemprüfungen im CCMS durchführen (Informix)

DB-Systemprüfungen im CCMS anzeigen (Informix)

Archive and Backup Monitor in CCMS (Informix)

Archivierungs- und Sicherungsmonitor im CCMS verwenden (Informix

Using the DB Operations Monitor

Datenbank mit dem Alertmonitor überwachen (Informix)

SAP/IBM DB2 for Linux, UNIX, and Windows: DBA im CCMS

Datenbankverwaltung mit SAP/DB2 UDB for iSeries im CCMS

Datenbank mit dem Alert-Monitor überwachen (iSeries)

CCMS: MaxDB

SAP Content Server - Überwachung und Administration

SAP/ MS SQL Server DBA in CCMS

Database Backup

Backup Strategy

Backup Types

Log Truncation

Recovery Models

Backup Device Management

Disk Configuration

Executing Backups

Backing Up with the SAP System

Monitoring Backups

Checking Individual Backups with the SAP System

Checking all Backups with the SAP System

Database Restore

Restoring the SAP Database after Disk Crash

Restoring the Database and Log Backups

Restoring After Executables Disk Crash

Database Server Checks

Checking Consistency of the Database

Checking Consistency of Individual Tables

Viewing the Error Log

Monitoring the SAP Data Disk

Monitoring the SAP Log Disk

Database Server Configuration

Increasing the Size of the Windows Page File

Optimizing the Virtual Memory Manager

Removing the Screen Saver

Database Management Tools

SQL Server Configuration Manager

Starting and Stopping the SQL Server

Setting SQL Server Startup Options

SQL Server Management Studio

Setting Authentication

Changing Passwords for SQL Server Logins

Changing Passwords of Windows Accounts

Registering a Server

Changing the Size of the Database Files

Configuring SQL Server

Configuring Databases

Setting Single-User Mode

Executing Queries

Moving SAP Database Files to New Disks

Displaying the SQL Server Version

Backing Up the SQL Server Database

Backing Up the Current Transaction Log

Checking Backups

Viewing the Error Log with SQL Server Management Studio

Increasing the Number of Error Log Files

Restoring the Database and Log Backups with the SQL Server Manag

Restoring the <SAPSID> Backup from a Device

Restoring the msdb Database from a Device

The DBA Cockpit

Central System Data

Monitoring of Remote Databases

Remote Monitoring Scenarios for Microsoft SQL Server

Database Multiconnect

Remote Enabled Functions (RFC)

Combination of RFC and DB Multiconnect

Required Steps to Set Up Remote Monitoring of an SQL Server Data

Creating SQL Server Logins on the Target Database Instance

Preparing the Database API on the Monitoring Application Server

SAP Role and User Management

Creating System Entries in the DBA Cockpit

Creating or Selecting DBCON Entries for All Remote Monitoring De

Creating and Populating an Object Source Schema

Additional Functions

Systeme für entferntes Monitoring mithilfe des System Landscape

Changing a System Entry

Deleting a System Entry

Datenbankverbindung ändern

Datenbankverbindung testen

Datenbankverbindung löschen

Troubleshooting

Performance

Performance: Overview

Memory

Disk Space Usage

Dynamic Values in Current Activity Sub Screen

Database Processes

SQL Statements

I/O Performance

Locks

Wait Events

SAP/SQL Data Providers

History

Database Collector Data

Performance History

Blocking Lock History

Performance: Performance Warehouse

Performance Warehouse: Reporting

Performance Warehouse: Konfiguration

Indexes

Index Usage

Index Operational Statistics

Index Analysis

Performance: Additional Functions

Server Detail

SAP SQL Statistics

Database Utilities

Space

Space: Overview

Single Table Analysis

Largest Tables

Fastest Growing Tables

History

Additional Functions

Backup and Recovery

Backup Overview

Scheduled SQLAgent Jobs

Backup Devices

SQL Agent Properties

Tapes Needed for Restore

Restore History

Backup History

SQL Agent Job History

Configuration

Configuration: Overview

Configuration Options

Database Options

SAP Configuration

SQL Server Setup Check

SQL Script Maintenance

SQL Script Execution

Jobs

Zentraler Kalender

Using the Central Calendar

The DBA Planning Calendar (MS SQL Server)

Setting Up the DBA Planning Calendar (MS SQL Server)

Working with the DBA Planning Calendar

Scheduling an Action

Changing an Action

Executing an Action

Deleting an Action

Displaying the Status of a Day’s Actions

Displaying Scheduled Actions

Troubleshooting Scheduled Actions

Displaying the Volume (Tape Names) of Scheduled Backups

Storing a Backup on Multiple Tapes

Scheduling Database and Transaction Log Backups (Windows)

Scheduling Database Consistency Checks (Windows)

Third Party Backup Tools

The DBA Log

Diagnostics

Missing Tables and Indexes

Viewing the Error Log with the SAP System

SQL Command Editor

SQL Profiler

Deadlock Monitor

Disp+Work DLLs

SQL Server Alert Monitor

Alerts for SQL Server

Viewing and Customizing Threshold Values