Database Administration in CCMS
CCMS: Oracle
Getting Started in CCMS with Oracle DBA
Central DBA Planning Calendar
Using the Central DBA Planning Calendar
DBA Planning Calendar (Oracle)
Selecting Action Patterns (Oracle)
Action Patterns (Oracle)
Adding Actions to DBA Planning Calendar (Oracle)
Editing or Deleting Actions (Oracle)
Checking the Results of Actions in the DBA Planning Calendar
Troubleshooting in the DBA Planning Calendar (Oracle)
Checking the Results of Actions in CCMS (Oracle)
Display of Backup Logs and Status (Oracle)
Displaying Backup Logs (Oracle)
Displaying Redo Log Backups (Oracle)
Using the Recovery Report (Oracle)
Displaying DBA Logs (Oracle)
Using the DB Operations Monitor
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
CCMS: Informix
Getting Started in CCMS with Informix DBA
Central DBA Planning Calendar
Using the Central DBA Planning Calendar
DBA Planning Calendar (Informix)
Choosing an Action Pattern in the DBA Planning Calendar
Scheduling Actions in the DBA Planning Calendar
Checking the Results of Actions in the DBA Planning Calendar
Archiving or Backing Up the Database in the DBA Planning Calenda
Backing Up the Logical Log in the DBA Planning Calendar (Informi
Backing Up the Logical Log (Automatic) in the DBA Planning Calen
Checking Statistics in the DBA Planning Calendar (Informix)
Updating Statistics in the DBA Planning Calendar (Informix)
Checking Physical Consistency in the DBA Planning Calendar (Info
Checking the DB System in the DBA Planning Calendar (Informix)
Troubleshooting in the DBA Planning Calendar (Informix)
Update Statistics in CCMS (Informix)
Checking and Updating Statistics for a Single Table in CCMS (Inf
Configuring Update Statistics in CCMS (Informix)
DB System Checks in CCMS (Informix)
Configuring DB System Checks in CCMS (Informix)
Running DB System Checks in CCMS (Informix)
Viewing DB System Checks in CCMS (Informix)
Archive and Backup Monitor in CCMS (Informix)
Using the Archive and Backup Monitor in CCMS (Informix)
Using the DB Operations Monitor
Monitoring the Database with the Alert Monitor (Informix)
CCMS: SAP/DB2 UDB for UNIX and Windows
The DBA Cockpit (DB2 UDB for UNIX and Windows)
Maintenance Actions in the DBA Cockpit (DB2 UDB for UNIX and Win
Configuration of Systems for Remote Monitoring (DB2 UDB for UNIX
Configuring Systems for Remote Monitoring Using RFC (DB2 UDB for
Configuring Systems for Remote Monitoring Using Remote Database
Displaying the Audit Log (DB2 UDB for UNIX and Windows)
Performance (DB2 UDB for UNIX and Windows)
Performance: Partitions (DB2 UDB for UNIX and Windows)
Performance: Database Snapshot (DB2 UDB for UNIX and Windows)
Database: Buffer Pool (DB2 UDB for UNIX and Windows)
Database: Cache (DB2 UDB for UNIX and Windows)
Database: Asynchronous I/O (DB2 UDB for UNIX and Windows)
Database: Direct I/O (DB2 UDB for UNIX and Windows)
Database: Extended Storage (DB2 UDB for UNIX and Windows)
Database: Locks and Deadlocks (DB2 UDB for UNIX and Windows)
Database: Logging (DB2 UDB for UNIX and Windows)
Database: Calls (DB2 UDB for UNIX and Windows)
Database: Sorts (DB2 UDB for UNIX and Windows)
Performance: Schemas (DB2 UDB for UNIX and Windows)
Performance: Buffer Pool Snapshot (DB2 UDB for UNIX and Windows)
Buffer Pools (DB2 UDB for UNIX and Windows)
Buffer Pools: Asynchronous I/O (DB2 UDB for UNIX and Windows)
Buffer Pools: Direct I/O (DB2 UDB for UNIX and Windows)
Buffer Pools: Extended Storage (DB2 UDB for UNIX and Windows)
Performance: Tablespace Snapshot (DB2 UDB for UNIX and Windows)
Tablespaces: Buffer Pool (DB2 UDB for UNIX and Windows)
Tablespaces: Asynchronous I/O (DB2 UDB for UNIX and Windows)
Tablespaces: Direct I/O (DB2 UDB for UNIX and Windows)
Tablespaces: Extended Storage (DB2 UDB for UNIX and Windows)
Performance: Table Snapshot (DB2 UDB for UNIX and Windows)
Performance: Application Snapshot (DB2 UDB for UNIX and Windows)
Applications (DB2 UDB for UNIX and Windows)
Applications: Buffer Pool (DB2 UDB for UNIX and Windows)
Applications: Direct I/O (DB2 UDB for UNIX and Windows)
Applications: Extended Storage (DB2 UDB for UNIX and Windows)
Applications: Locks and Deadlocks (DB2 UDB for UNIX and Windows)
Applications: Calls (DB2 UDB for UNIX and Windows)
Applications: Sorts (DB2 UDB for UNIX and Windows)
Applications: Cache (DB2 UDB for UNIX and Windows)
Applications: Unit of Work (DB2 UDB for UNIX and Windows)
Applications: Agents (DB2 UDB for UNIX and Windows)
Applications: Statement (DB2 UDB for UNIX and Windows)
Applications: Statement Text (DB2 UDB for UNIX and Windows)
Performance: SQL Cache Snapshot (DB2 UDB for UNIX and Windows)
Performance: Lock Waits and Deadlocks (DB2 UDB for UNIX and Wind
Performance: Inplace Table Reorganization (DB2 UDB for UNIX and
Performance: History - Database (DB2 UDB for UNIX and Windows)
Space (DB2 UDB for UNIX and Windows)
Space: Tablespaces (DB2 UDB for UNIX and Windows)
Maintaining Tablespaces (DB2 UDB for UNIX and Windows)
Space: Containers (DB2 UDB for UNIX and Windows)
Space: Tables and Indexes (DB2 UDB for UNIX and Windows)
Space: Single Table Analysis (DB2 UDB for UNIX and Windows)
Space: History - Overview (DB2 UDB for UNIX and Windows)
Space: History - Database and Tablespaces (DB2 UDB for UNIX and
Space: History - Tables and Indexes (DB2 UDB for UNIX and Window
Backup and Recovery (DB2 UDB for UNIX and Windows)
Backup and Recovery: Backup Overview (DB2 UDB for UNIX and Windo
Backup and Recovery: Logging Parameters (DB2 UDB for UNIX and Wi
Configuration (DB2 UDB for UNIX and Windows)
Configuration: Database Manager (DB2 UDB for UNIX and Windows)
Configuration: Database (DB2 UDB for UNIX and Windows)
Maintaining the Database Configuration (DB2 UDB for UNIX and Win
Configuration: Parameter Changes (DB2 UDB)
Configuration: Database Partition Groups (DB2 UDB for UNIX and W
Maintaining Database Partition Groups (DB2 UDB for UNIX and Wind
Configuration: Buffer Pools (DB2 UDB for UNIX and Windows)
Maintaining Buffer Pools (DB2 UDB for UNIX and Windows)
Configuration: RUNSTATS Settings (DB2 UDB for UNIX and Windows)
Configuration: CLP Commands (DB2 UDB for UNIX and Windows)
Configuration: File Systems (DB2 UDB for UNIX and Windows)
Configuration: Data Classes (DB2 UDB for UNIX and Windows)
Maintaining Data Classes (DB2 UDB for UNIX and Windows)
Configuration: Monitoring Settings (DB2 UDB for UNIX and Windows
Jobs (DB2 UDB for UNIX and Windows)
The DBA Planning Calendar (DB2 UDB for UNIX and Windows)
Setup of the DBA Planning Calendar (DB2 UDB for UNIX and Windows
Scheduling an Action (DB2 UDB for UNIX and Windows)
Changing an Action (DB2 UDB for UNIX and Windows)
Deleting an Action (DB2 UDB for UNIX and Windows)
Executing an Action (DB2 UDB for UNIX and Windows)
Displaying the Status of a Day’s Actions (DB2 UDB for UNIX and W
Displaying Scheduled Actions (DB2 UDB for UNIX and Windows)
Troubleshooting (DB2 UDB for UNIX and Windows)
Update Statistics (DB2 UDB for UNIX and Windows)
Reorganization of Tables (DB2 UDB for UNIX and Windows)
Database Backup (DB2 UDB for UNIX and Windows)
The DBA Log (DB2 UDB for UNIX and Windows)
The CLP Script Maintenance (DB2 UDB for UNIX and Windows)
Alerts (DB2 UDB for UNIX and Windows)
Alerts: Database System Monitoring in CCMS (DB2 UDB for UNIX and
Alerts: Configuring Database System Monitoring (DB2 UDB for UNIX
Alerts: Alert Configuration (DB2 UDB for UNIX and Windows)
Alerts: Alert Message Log (DB2 UDB for UNIX and Windows)
Diagnostics (DB2 UDB for UNIX and Windows)
Diagnostics: Missing Tables and Indexes (DB2 UDB for UNIX and Wi
Diagnostics: Deadlock Monitor (DB2 UDB for UNIX and Windows)
Creating the Deadlock Monitor (DB2 UDB for UNIX and Windows)
Deadlock Monitor Analysis(DB2 UDB for UNIX and Windows)
Diagnostics: Control Panel (DB2 UDB for UNIX and Windows)
Diagnostics: Single System Check (DB2 UDB for UNIX and Windows)
The EXPLAIN Function (DB2 UDB for UNIX and Windows)
EXPLAIN Options (DB2 UDB for UNIX and Windows)
Diagnostics: Cumulative SQL Trace (DB2 UDB for UNIX and Windows)
Diagnostics: DBSL Trace Directory (DB2 UDB for UNIX and Windows)
Diagnostics: Trace Status (DB2 UDB for UNIX and Windows)
Diagnostics: Database Notification Log (DB2 UDB for UNIX and Win
Diagnostics: Database Diag Log (DB2 UDB for UNIX and Windows)
Diagnostics: Dump Directory (DB2 UDB for UNIX and Windows)
Wizards: Partition Integration (DB2 UDB for UNIX and Windows
SAP/DB2 UDB for iSeries DBA in CCMS
Monitoring the Database Using the Alert Monitor (iSeries)
CCMS: MaxDB
SAP Content Server - Monitoring and Administration
SAP/ MS SQL Server DBA in CCMS
Database Backup
Backup Strategy
Backup Types
Log Truncation
Recovery Models
What Needs to be Backed Up?
Backup Device Management
Disk Configuration
Executing Backups
Backing Up with the SAP System
Monitoring Backups
Database Restore
Distribution of Files to Disk
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
Viewing the Error Log
Monitoring the SAP Data Disk
Monitoring the SAP Log Disk
Database Server Management
Multiple Instances in SQL Server
Starting and Stopping the SQL Server
Setting SQL Server Startup Options
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
Database Performance Tuning
Increasing the Size of the Windows Page File
Optimizing the Virtual Memory Manager
Removing the Screen Saver
Database Management Tools
Enterprise Manager
Backing Up with the Enterprise Manager
Backing Up the Current Transaction Log with Enterprise Manager
Checking Backups with the Enterprise Manager
Viewing the Error Log with the Enterprise Manager
Increasing the Number of Error Log Files
Restoring the Database and Log Backups with Enterprise Manager
Restoring a Backup from Device with Enterprise Manager
Restoring the msdb Database from Device with Enterprise Manager
The DBA Planning Calendar (MS SQL Server)
Setup of 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 Jobs
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)
Checking Individual Backups with the SAP System
SAP Backup and Restore Information (MS SQL Server)
Checking all Backups with the SAP System
SAP Database Performance: Database Allocation
Checking Consistency of Individual Tables
Checking for Missing Indexes
SQL Server Alert Monitor
Alerts for SQL Server
Viewing and Customizing Threshold Values
SAP/SQL Server Database Monitor
Memory
Disk Space Usage
Dynamic Values in Current Activity Sub Screen
Detail Analysis Menu
Viewing the Error Log with the SAP System
Monitoring Remote SQL Server Databases
Remote Enabled Functions (RFC)
Database Multi-Connect
Combination of RFC and DB Multi-Connect
Connecting to Remote Databases
Setting Up the Remote Connection
Defining an RFC Connection
Preparing the Source SAP Web Application Server
Preparing the Target Database Server
Creating a DBCON Entry
Creating an Object Source Schema and the SAP T-SQL Objects
Useful Information for Setting Up the Remote Connection
Troubleshooting