Computing Center Management System (BC-CCM) |
Setting Up the CCMS |
Starting and Stopping the SAP System |
Starting an SAP System: Windows |
Registry Entries |
Stopping an SAP System: Windows |
Starting the SAP System: iSeries |
Stopping the SAP System: iSeries |
Start and Shutdown Processing: Windows |
Windows Start Profile |
SAP System on Windows: Problem Analysis |
Windows: SAP System Program Overview |
Starting and Stopping the Database System: UNIX |
Starting an R/3 System: UNIX |
Stopping an R/3 System: UNIX |
Program SAPSTART |
Controlling System Startup |
Starting the R/3 System Using Operation Modes |
Platform-Specificity |
Starting the R/3 System Using Start Profiles |
Starting and Stopping Instances |
Errors During Startup |
Background Processing |
Background Processing: Concepts and Features |
Setting Up the Background Processing System |
Background Work Processes Explained |
Required Basis Background Jobs |
Standard Jobs |
Overview of Standard Jobs |
Scheduling Standard Jobs |
Defining New Standard Jobs |
Authorizations for Background Processing |
Jobs and Job Steps Explained |
External Commands and External Programs |
Prerequisites for Running External Programs |
Defining External Commands |
Starting External Commands and Programs |
Events in Background Processing Explained |
Job Scheduling Explained |
Scheduling Background Jobs |
Activating Background Processing |
Job Scheduling Wizard |
Specifying Job Start Conditions |
Job Start Management |
Periodicity: Specifying Automatic Job Repetition |
Prioritizing Class A Jobs |
Prioritization Strategies for Class A Jobs |
Releasing Jobs |
Deleting Jobs |
Displaying a Job Log |
Job Storage Management |
Parallel Processing Jobs with Asynchronous RFC |
Defining RFC Groups for Parallel-Processed Jobs |
Possible Status of Background Jobs |
Managing Jobs from the Job Overview |
Selecting, or Specifying, Jobs |
Monitor Alerts for Background Processing |
Displaying Job Alerts |
Graphical Job Scheduling Monitor |
Using the Graphical Job Scheduling Monitor |
Terminated Job Analysis |
Problem Analysis in Background Processing |
R/3 Analysis Tools: Overview |
Analyzing the Work Processes and System Log of an Application Se |
Analyzing ABAP Runtime Problems |
Analyzing Job Status |
Analyzing Resources with the Graphical Job Monitor |
Analyzing Status, Configuration, and Administration Data |
Analyzing Parts of the Runtime Environment |
Analyzing Problems with External Commands and Programs |
Troubleshooting the Background Processing System |
Job was Not Started |
Job is Terminated |
Job Log Cannot be Displayed |
Job Status Remains “Active” |
Analyzing Problems With Events |
Control Object Types |
Programming with the Background Processing System (BC-CCM-BTC) |
Programming Techniques |
Scheduling and Managing a Job: Easy Method |
Easy Job Scheduling Using BP_JOBVARIANT_SCHEDULE |
Managing “Easy-Method” Jobs with BP_JOBVARIANT_OVE |
Scheduling a Job: Full-Control Method |
Task Overview: Full-Control Job Scheduling |
Where to Specify Job Attributes |
Getting Job-Start Specifications from Users |
Calculating Start Dates for Periodic Jobs |
Obtaining Printing and Archiving Specifications |
Sample Program: Declarations, Set Up, and Print S |
Sample Program: Creating a Job with JOB_OPEN |
Sample Program: Adding an ABAP Job Step |
Sample Program: Adding a Job Step for an External |
Sample Program: Adding a Job Step with ABAP SUBMI |
Sample Program: Immediate Start with JOB_CLOSE |
Sample Program: Immediate Start with Spool Reques |
Sample Program: Start-Time Window with JOB_CLOSE |
Sample Program: Job Start on Workday (JOB_CLOSE) |
Sample Program: Job Start on Event (JOB_CLOSE) |
Sample Program: Wait for Predecessor Job with JOB |
Sample Program: Start at Switch to Operating Mode |
Job Outcomes: Displaying Job Logs |
Displaying a Job Log |
Copying a Job Log into an Internal Table |
Managing Jobs: Generating Job Lists |
Sample Program: Generating a Job List |
Displaying Job Status: SHOW_JOBSTATE |
Selecting and Deleting a Job |
Using Events to Trigger Job Starts |
Event Concepts |
Using Events: Task Overview |
Defining Events |
Triggering Events from ABAP Programs |
Triggering Events from External Programs |
Finding Out Which Event and Argument Were Triggere |
Running External Programs |
Implementing Parallel Processing |
Special Techniques: Starting External Programs |
Advanced Scheduling 1: Building Chains of Jobs |
Advanced Scheduling 2: Scheduling and Synchronizi |
Advanced Scheduling 3: Deciding Which Job to Sche |
Reference: Background Processing Function Modules |
JOB_OPEN: Create a Background Processing Job |
JOB_SUBMIT, ABAP SUBMIT: Add a Job Step to a Job |
JOB_CLOSE: Pass a Job to the Background Processin |
BP_JOBVARIANT_SCHEDULE and BP_JOBVARIANT_OVERVIEW: |
BP_CALCULATE_NEXT_JOB_STARTS: Determine Start Dat |
BP_CHECK_EVENTID: Check that an Event Exists |
BP_EVENT_RAISE: Trigger an Event from an ABAP Pro |
BP_JOB_COPY: Copy a Background Job |
BP_JOB_DELETE: Delete a Background Processing Job |
BP_JOB_GET_PREDECESSORS: List Predecessor-Jobs of |
BP_JOB_GET_SUCESSORS: List the Successor-Jobs of |
BP_JOB_MAINTENANCE: Job Management Functions |
BP_JOB_SELECT: Read Jobs from Database |
BP_FIND_JOBS_WITH_PROGRAM: Read Jobs that Run a S |
BP_JOBLIST_PROCESSOR: Allow User to Work with Lis |
SHOW_JOBSTATE: Check Status of a Job |
BP_JOBLOG_READ: Read a Job Log for Processing |
BP_JOBLOG_SHOW: Display a Job Processing Log |
BP_START_DATE_EDITOR: Display/Request Start Speci |
BP_JOB_READ: Retrieve Job Specifications |
SHOW_JOBSTATE: Display Job Status |
Parallel-Processing Function Modules |
Data Transfer |
Data Transfer Methods |
Data Transfer: Overview of Batch Input |
The Transaction Recorder |
Recording Transactions |
Recording |
Using the Recording Editor |
Generating Batch Input Sessions From the Recording |
Generating Data Transfer Programs |
Generating Function Modules |
Using Function Modules |
Creating Test Files |
Executing the Data Transfer |
Writing Data Conversion Programs |
Generating an SAP Data Structure for the Conversio |
Data Conversion |
Filling SAP Data Structures |
Selecting a Data Transfer Method |
Executing Data Transfer Programs |
Batch Input Authorizations |
Additional Information |
Using CALL TRANSACTION USING for Data Transfer |
Creating Batch Input Sessions |
Creating a Session with BDC_OPEN_GROUP |
Adding Data to a Session: BDC_INSERT |
Closing a Session: BDC_CLOSE_GROUP |
Processing Batch Input Sessions |
Using CALL DIALOG with Batch Input |
Using the Data Transfer Data Structure |
Determining System Data |
Frequent Data Transfer Errors |
Direct Input |
Programming with External Commands |
Programming Techniques |
SXPG_CALL_SYSTEM: Run an External Command (Expres |
SXPG_COMMAND_EXECUTE: Check Authorization for and |
SXPG_COMMAND_CHECK: Check Authorization to Execut |
SXPG_COMMAND_LIST_GET: Read a List of External Co |
SXPG_COMMAND_DEFINITION_GET: Read Single External |
SXPG_DUMMY_COMMAND_CHECK: Interface for Extra-Che |
Common Application Interfaces |
Configuration |
Dynamic Logon Load Distribution |
Recommendations for Logon Load Balancing and Logon Groups |
Questions and Answers: Logon Load Balancing |
Checking the Logon Load |
Configure Dynamic Logon Load Distribution for RFC Calls |
PC Installation |
The SAP Logon |
Logging on to an SAP System |
Configuring the SAP Logon |
Adding a New Logon User Group |
Configuring Logon Groups |
Adding an Application Server |
Adding and Editing Entries Manually |
Setting Low Speed Connection |
Operation Modes |
Operation Mode Switches |
Switching Operation Modes Automatically |
Switching Operation Modes Manually |
Simulating Operation Mode Switching |
Rules for Work Process Distribution |
Setting the Work Process Distribution |
Operation Mode Errors |
Defining Operation Modes |
Defining Day and Night Operation |
Requirements for Maintaining Operation Modes |
Defining Normal Operation |
Defining Exception Operation |
Monitoring Servers and Work Processes |
Checking the Operation Mode with the Control Panel |
Consistency Check |
Instances |
Creating an Instance Definition for One Server |
Creating an Instance Definition for All Servers |
Prerequisites for Starting Remote Instances |
Maintaining Instance Definitions |
Profiles |
Substituting Variables in Profile Values |
Where Do Profiles Come From? |
Reference Server of a Profile |
Profile Parameters |
Important Profile Parameters |
Profile Files |
Start Profiles |
Start Profile: Changing Instance Services |
Default Profiles |
Default Profile: Changing Global Instance Paramete |
Instance Profiles |
Instance Profile: Automatic Adjustment of SAP Shar |
Instance Profile: Changing Instance Parameters |
Switching Operation Modes Using Start and Instance Profiles |
What to do After Installing an SAP Instance |
Importing Profiles |
Profile Maintenance |
Creating and Copying Individual Profiles |
Changing and Switching Profile Parameters |
Profile Checks |
Saving, Checking and Activating Profiles |
Profile Versions |
Finding Manual Changes to a Profile |
Checking Active Parameters |
Deleting Profiles |
External Operating System Command: Contents |
Executing External Commands |
Maintaining External Commands |
External Commands: Overview |
Authorizations for External Commands |
Which Information is Displayed? |
Displaying Detailed Information |
Additional Parameters |
R/3 Profile Parameters in External Commands |
Security Checks |
Check Modules |
Processing Illegal Changes to External Commands |
Syslog Trace and System Alert Monitor |
Monitoring in the CCMS |
 The Alert Monitor |
 CCMS Agents |
 Operating System Monitor |
 Workload Monitor |
 Global Workload Monitor |
Database Monitor |
SAP/Oracle Database Monitor |
SAP/Oracle Database Monitor: Introduction |
SAP/Oracle Database Monitor: Main Screen |
Sorts (Oracle) |
Time Statistics (Oracle) |
Table Scans/Table Fetch (Oracle) |
Redo Log Buffer (Oracle) |
Calls (Oracle) |
Data Buffer (Oracle) |
Shared Pool (Oracle) |
Detailed Analysis (Oracle) |
Detail Analysis Menu (Oracle) |
File System Requests (Oracle) |
Buffer Busy Waits (Oracle) |
Wait Events (Oracle) |
Dictionary Buffer (Oracle) |
SAP Client (Oracle) |
Oracle Sessions |
SQL Request (Shared SQL Area) |
Exclusive Lockwaits (Oracle) |
Database Message Log (Oracle) |
Display V$ Tables (Oracle) |
Historical Database Performance Statistics (Oracle) |
State on Disk (Oracle) |
Parameter Changes (Oracle) |
Table Scans: Problem Analysis (Oracle) |
Checking for Full Tablespaces (Oracle) |
Storage Management Errors (Oracle) |
Checking for Freespace Problems (Oracle) |
Checking Storage Parameters (Oracle) |
Problems with Maximum Number of Extents (Oracle) |
Displaying the Oracle Table Statistics |
SAP/Oracle Database Monitor: Status of the Data |
Consistency Checks |
Database - ABAP Dictionary Consistency |
Database Tables without a Unique Index |
Creating Objects in the Database |
Displaying Object Definitions |
Naming Conventions for Indexes |
Extent Analysis (Oracle) |
Tablespace Analysis (Oracle) |
Tables/Index Analysis (Oracle) |
Missing Indexes |
SAP/Oracle Performance Monitoring Strategies |
Monitoring the Data Buffer (Oracle) |
Monitoring the Shared Pool (Oracle) |
Monitoring the Redo Log Buffer (Oracle) |
Monitoring Calls (Oracle) |
Monitoring Table Access Methods (Oracle) |
Monitoring Sorting (Oracle) |
Diagnosing SAP/Oracle Performance Problems |
A Transaction is Running Very Slowly (Oracle) |
Monitoring the Shared SQL Area (Oracle) |
Monitoring Table and Index Fragmentation (Oracle) |
All Transactions are Running Slowly (Oracle) |
Checkpoint Monitoring (Oracle) |
Checking the Optimizer Mode (Oracle) |
Monitoring Oracle Resources |
No Applications Can Run (‘Frozen’ System) |
Important init.ora Parameters (Oracle) |
DB_BLOCK_BUFFERS (Oracle) |
DB_BLOCK_SIZE (Oracle) |
DB_WRITERS (Oracle) |
LOG_ARCHIVE_START (Oracle) |
LOG_BUFFER (Oracle) |
LOG_CHECKPOINT_INTERVAL (Oracle) |
ROW_CACHE_CURSORS (Oracle) |
SHARED_POOL_SIZE (Oracle) |
SORT_AREA_SIZE (Oracle) |
TIMED_STATISTICS (Oracle) |
Data for the Oracle Database Monitor |
Database Collector in Background Processing |
Data for the Main Screen of the Database Monitor |
Data for the Screen: Database Performance: Tables |
Data for the Database Alert Monitor |
SAP/Informix Database Monitor |
Looking at the Informix Database Overview |
Shared Memory (Informix) |
Data Buffers (Informix) |
Cleaners (Informix) |
Log Buffers (Informix) |
Database Activity (Informix) |
Checkpointing (Informix) |
Asynchronous I/O (Informix) |
Detailed Database Analysis for Informix |
Checking Wait Situations (Informix) |
Checking Chunk I/O Activity (Informix) |
Checking Sessions (Informix) |
Checking Table Activity (Informix) |
Checking SQL Statements (Informix) |
Checking Exclusive Lockwaits (Informix) |
Checking the Database Message Log (Informix) |
Checking State on Disk (Informix) |
Checking Pseudotables (Informix) |
Checking Parameter Changes (Informix) |
Checking the Database with onstat Commands |
SAP/Informix Performance Monitoring |
Monitoring Data Buffers (Informix) |
Monitoring the I/O Subsystem (Informix) |
Monitoring Checkpoints (Informix) |
Monitoring LRUS (Informix) |
Monitoring CPU VPs (Informix) |
Monitoring the Informix Network Interface |
Monitoring Virtual Memory Usage (Informix) |
Monitoring Optimizer Statistics (Informix) |
Monitoring SQL Statement (Informix) |
Diagnosis of SAP/Informix Performance Problems |
Identifying Problems with One Transaction Running Slow (Informix |
Identifying Problems with All Transactions Running Slow (Informi |
Identifying Problems with a Frozen System (Informix) |
Analyzing Sessions and Tables (Informix) |
Analyzing Lockwaits (Informix) |
Analyzing Lockwaits with onstat (Informix) |
Checking Key Tuning Parameters (Informix) |
BUFFERS (Informix) |
CKPTINTVL (Informix) |
CLEANERS (Informix) |
DD_HASHSIZE and DD_HASHMAX (Informix) |
LOCKS (Informix) |
LOGBUFF (Informix) |
LRU_MAX_DIRTY, LRU_MIN_DIRTY (Informix) |
LRUS (Informix) |
MULTIPROCESSOR (Informix) |
MULTIPROCESSOR, NUMCPUVPS, and SINGLE_CPU_VP (Informix) |
NETTYPE (Informix) |
NOAGE (Informix) |
NUMAIOVPS (Informix) |
NUMCPUVPS (Informix) |
PHYSBUFF (Informix) |
PHYSFILE (Informix) |
RA_PAGES and RA_THRESHOLD (Informix) |
SHMADD (Informix) |
SHMTOTAL (Informix) |
SHMVIRTSIZE (Informix) |
SINGLE_CPU_VP (Informix) |
STACKSIZE (Informix) |
USEOSTIME (Informix) |
SAP DB - Database Monitor |
SAP DB - Database Monitor: Main Screen |
Cache Activity (SAP DB) |
Commands (SAP DB) |
I/O Activity (SAP DB) |
Locking Activity (SAP DB) |
Logging Activity (SAP DB) |
Scan and Sort Activity (SAP DB) |
Detail Analysis Menu (SAP DB) |
DB Processes (SAP DB) |
I/O Statistics (SAP DB) |
Cache Statistics (SAP DB) |
Region Statistics (SAP DB) |
DB Filling Statistics (SAP DB) |
Runtime Environment (SAP DB) |
Parameter Changes (SAP DB) |
Logging Statistics (SAP DB) |
Storage Overview (SAP DB) |
Exclusive Lock Waits (SAP DB) |
Tables/Indexes (SAP DB) |
Control Log File (SAP DB) |
Database Message Log (SAP DB) |
Overview (SAP DB) |
Diagnostic Monitor (SAP DB) |
Bottleneck Analysis (SAP DB) |
Database Performance History Statistics (SAP DB) |
SAP/SQL Server Database Monitor |
Memory Usage |
Space Usage |
Server Engine |
Detail Analysis Menu |
The CCMS System Component Repository |
Displaying Information from the Repository |
Filling and Updating the Repository |
Checking the Repository for Processing Errors |
Creating a Central Repository |
Role of a System Component Repository |
Updating the Central Repository |
Updating a Local Repository |
Requesting an Update of a Repository |
Creating the CSMREG User |
The Control Panel |
Starting the Control Panel |
Displaying Developer Traces and Log Files in the Control Panel |
Data Archiving Monitor |
Messages and Alerts for Data Archiving Monitor |
Technical Information for Data Archiving Monitor |
R/3 Accounting Interface |
Database Resources |
Operating System Resource |
R/3 System Resources |
Installing and Setting up the R/3 Accounting Interface |
Creating an Account |
Creating the Table of Contents |
Reading Accounting Data |
Example 1: Using the User Master Record |
Example 2: Not Using the User Master Record |
Global Work Process Overview |
Selecting Work Processes |
Displaying Detailed Work Process Information |
SAP Buffers |
Buffer Components |
Buffer Synchronization |
Buffer Types |
Repository Buffers (Nametab Buffers) |
Table Buffers |
Displaying Table Buffers |
Program Buffers |
SAPgui Buffers |
Roll and Paging Buffers, Extended Memory |
SAP Calendar Buffer |
Import / Export Buffers |
SAP Cursor Cache |
SAP Cursor Cache for Oracle, Informix, Adabas and DB2 for AIX |
SAP Cursor Cache for MS SQL Server |
The Buffer Monitor |
Buffer Monitor and Tune Summary |
Tuning SAP Buffers |
Special Aspects of Tuning |
Working with Call Statistics |
Buffer Quality |
Reasons for Poor Buffer Quality |
High Buffer Quality |
Typical Parameter Settings for SAP Buffers |
Object Swapping |
Checking Memory Usage |
Changing Buffer Sizes |
Adjusting Pool Sizes |
How Much Operating System Paging is Acceptable? |
Directory Space and Data Space |
Microsoft Management Console: Windows |
Starting the MMC |
Layout of R/3 Manager Snap-In |
Context Menu of the R/3 Manager Snap-In |
Changing the Configuration of the MMC |
Configuring MMC for Active Directory Services |
MMC Enhancements for Active Directory Services |
Database Administration in CCMS |
SAP/Oracle DBA in CCMS |
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 |
Displaying Database Alerts for the DBA Planning Calendar (Oracle |
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 R/3 Consistency Alerts |
Database Health Alerts |
SAP/Informix DBA in CCMS |
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) |
SAP/DB2 UDB for iSeries DBA in CCMS |
Monitoring the Database Using the Alert Monitor (iSeries) |
SAP DB - DBA in the CCMS |
SAP Content Server – Monitoring and Administration |
SAP/ MS SQL Server 2000 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 |
Backing Up with the Enterprise Manager |
Monitoring Backups |
Checking Individual Backups with the SAP System |
Checking all Backups with the SAP System |
Checking Backups with the Enterprise Manager |
Database Restore |
Distribution of Files to Disk |
Restoring the SAP Database after Disk Crash |
Backing Up the Current Transaction Log |
Restoring the Database and Log Backups |
Restoring a Backup from Device |
Restoring After Executables Disk Crash |
Restoring the msdb Database from Device |
Database Server Checks |
Viewing the Error Log with the SAP System |
Viewing the Error Log with the Enterprise Manager |
Monitoring the SAP Data Disk |
Monitoring the SAP Log Disk |
Checking Consistency of the Database |
Checking Consistency of Individual Tables |
Checking for Missing Indexes |
Database Server Management |
Multiple Instances In SQL Server 2000 |
Starting and Stopping the SQL Server |
Setting SQL Server Startup Options |
Changing Authentication |
Changing Passwords for SQL Server Logins |
Changing Passwords of Windows Accounts |
Registering a Server |
Changing the Autogrow Settings |
Configuring the 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 |
Planning Calendar |
Working with the Planning Calendar |
Central DBA Planning Calendar (MS SQL Server) |
Working with the Central DBA Planning Calendar (MS SQL Server) |
SAP Backup and Restore Information (MS SQL Server) |
SAP Database Performance: Database Allocation |
SQL Server Alert Monitor |
Alerts for SQL Server |
Viewing and Customizing Threshold Values |
SAP/SQL Server Database Monitor |
Memory Usage |
Space Usage |
Server Engine |
Detail Analysis Menu |
CCMS: SAP/DB2 UDB for UNIX and Windows |
The DBA Cockpit (DB2 UDB for UNIX and Windows) |
Configuring the System for Remote Monitoring (DB2 UDB for UNIX a |
Checking the User-Defined Function (UDF) Libraries (DB2 UDB for |
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: Statements (DB2 UDB for UNIX and Windows) |
Performance: SQL Cache Snapshot (DB2 UDB for UNIX and Windows) |
Performance: Lock Waits (DB2 UDB for UNIX and Windows) |
Performance: Deadlocks (DB2 UDB for UNIX and Windows) |
Performance: History Database (DB2 UDB for UNIX and Windows) |
Space (DB2 UDB for UNIX and Windows) |
Space: Tablespaces (DB2 UDB for UNIX and Windows) |
Tablespace Maintenance (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: 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 (DB2 UDB for UNIX and Windows) |
Configuration: Database Manager (DB2 UDB for UNIX and Windows) |
Configuration: Parameter Changes (DB2 UDB) |
Configuration: Volatile Tables (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) |
Jobs (DB2 UDB for UNIX and Windows) |
The DBA Planning Calendar (DB2 UDB for UNIX and Windows) |
Set Up of the DBA Planning Calendar (DB2 UDB for UNIX and Window |
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) |
Initiating a Log Archive Backup Manually (DB2 UDB for UNIX and W |
Update Statistics (DB2 UDB for UNIX and Windows) |
Reorganization of Tables (DB2 UDB for UNIX and Windows) |
The DBA Log (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: 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 Alert Log (DB2 UDB for UNIX and Windows) |
Diagnostics: Database Diag Log (DB2 UDB for UNIX and Windows) |
Diagnostics: Dump Directory (DB2 UDB for UNIX and Windows) |
Diagnostics: Kernel Executables (DB2 UDB for UNIX and Windows) |
Diagnostics: Missing Tables and Indexes (DB2 UDB for UNIX and Wi |
CCMS: SAP/DB2 Universal Database for iSeries |
Cockpit for iSeries |
Performance (iSeries) |
Database Monitor (iSeries) |
Overview (iSeries) |
SQL Statements (iSeries) |
Table Scans (iSeries) |
Table Scan Access (iSeries) |
Sorts (iSeries) |
Sort Access (iSeries) |
Used Indexes (iSeries) |
Created Indexes (iSeries) |
Temporary Indexes and Permanent Indexes (iSeries) |
Advised Indexes (iSeries) |
Temporary Files (iSeries) |
Database Monitor Activity (iSeries) |
Database Monitor Configuration (iSeries) |
SQL Packages (iSeries) |
Lock Monitor (iSeries) |
File Statistics (iSeries) |
Additional Information |
System Catalog Views (iSeries) |
Performance Tables (iSeries) |
Database Monitor History (iSeries) |
Wait Situations (iSeries) |
Space (iSeries) |
State on Disk (iSeries) |
Consistency Checks (iSeries) |
Finding Database Damage (iSeries) |
Finding Database Storage Problems (iSeries) |
Performing Deleted Records Analysis (iSeries) |
Backup and Recovery (iSeries) |
Backup Overview (iSeries) |
Diagnostics (iSeries) |
PTF Check (iSeries) |
Data Archiving |
Displaying Archiving Objects and Tables |
Determining Space Information (Oracle) |
Determining Space Information (SAP DB) |
Determining Space Information (Informix) |