SAP CCMS – Computing Center Management System Monitoring, control and configure guide

The Computing Center Management System (CCMS) allows you to monitor, control, and configure your SAP System. The CCMS tools support 24-hour unattended system management functions from within the SAP System. Using these tools, you can analyze and distribute client workloads and report on resource consumption for system components.

Contents of this SAP CCMS – Computing Center Management System Monitoring, control and configure guide

Computing Center Management System (BC-CCM)……………23
Computing Center Management System (CCMS)…………………. 24
Setting Up the CCMS …………………. 26
Starting and Stopping the SAP System…………… 29
Starting an R/3 System: Windows NT ……….. 30
Example: Script for Starting the R/3 System ………………. 32
SAP Service Manager ……. 34
Registry Entries …………….. 36
Stopping an R/3 System: Windows NT………. 39
Example: Script for Stopping the R/3 System …………….. 41
Start and Shutdown Processing under Windows NT ……………. 43
Windows NT Start Profile …………. 46
R/3 System on Windows NT: Problem Analysis . 48
Windows NT: R/3 Program Overview …………….. 49
Starting and Stopping the Database System: UNIX ……………… 50
Starting an R/3 System: UNIX ….. 52
Stopping an R/3 System: UNIX…. 54
Program SAPSTART ………….. 56
Starting the R/3 System: AS/400…. 59
Stopping the R/3 System: AS/400.. 60
Controlling System Startup………… 61
Starting the R/3 System Using Operation Modes …………………. 63
Platform-Specificity …………………. 65
Starting the R/3 System Using Start Profiles …… 67
Starting and Stopping Instances … 69
Errors During Startup ………………… 71
Background Processing…………….. 73
Background Processing: Concepts and Features………………… 74
Setting Up the Background Processing System. 77
Background Work Processes Explained …………. 78
Required Basis Background Jobs. 80
Standard Jobs ……. 82
Overview of Standard Jobs….. 84
Scheduling Standard Jobs…… 85
Defining New Standard Jobs .. 86
Authorizations for Background Processing…….. 87
Jobs and Job Steps Explained …… 90
External Commands and External Programs…… 93
Prerequisites for Running External Programs …………………. 95
Defining External Commands . 98
Starting External Commands and Programs …………………. 100
Events in Background Processing Explained… 102
Job Scheduling Explained………… 105
Scheduling Background Jobs …. 106
Activating Background Processing ………….. 107
Job Scheduling Wizard ……… 109
Specifying Job Start Conditions………………. 110
Job Start Management………. 111
Periodicity: Specifying Automatic Job Repetition …………… 114
Prioritizing Class A Jobs ……. 116
Prioritization Strategies for Class A Jobs …………………. 118
Releasing Jobs ………………… 120
Deleting Jobs . 121
Displaying a Job Log…………. 122
Job Storage Management…………. 124
Parallel Processing Jobs with Asynchronous RFC…………….. 125
Defining RFC Groups for Parallel-Processed Jobs …………….. 127
Possible Status of Background Jobs…………….. 128
Managing Jobs from the Job Overview…………. 129
Monitoring Background Processing Alerts ……. 131
Displaying Job Alerts……………… 133
Graphical Job Scheduling Monitor ……………….. 134
Using the Graphical Job Scheduling Monitor…………………. 135
Terminated Job Analysis……. 136
Problem Analysis in Background Processing .. 137
R/3 Analysis Tools: Overview…… 138
Analyzing the Work Processes and System Log of an Application Server….. 140
Analyzing ABAP Runtime Problems …………….. 141
Analyzing Job Status……………… 142
Analyzing Resources With the Graphical Job Monitor…………. 146
Analyzing Status, Configuration and Administration Data ……. 148
Analyzing Parts of the Runtime Environment … 151
Analyzing Problems With External Commands and Programs 154
Troubleshooting the Background Processing System……….. 156
Job was Not Started………………. 158
Job is Terminated 162
Job Log Cannot be Displayed…. 165
Job Status Remains ………………. 168
Analyzing Problems With Events  170
Control Object Types……………….. 171
Configuration……… 173
Logon Load Balancing……………… 174
Recommendations for Logon Load Balancing and Logon Groups…………….. 175
Questions and Answers: Logon Load Balancing ………………… 177
Checking the Logon Load ………. 179
PC Installation ….. 180
The SAP Logon… 182
Logging on to an SAP System………………… 183
Configuring the SAP Logon .. 184
Adding a New Logon User Group……………. 186
Configuring Logon Groups…. 187
Adding an Application Server …………………. 189
Adding and Editing Entries Manually ……….. 190
Setting Low Speed Connection ………………. 191
Operation Modes…. 192
Operation Mode Switches………. 194
Switching Operation Modes Automatically .. 198
Switching Operation Modes Manually ……… 200
Simulating Operation Mode Switching……… 202
Rules for Work Process Distribution ………… 204
Setting the Work Process Distribution …. 207
Operation Mode Errors…………… 209
Defining Operation Modes ……… 211
Defining Day and Night Operation ……………….. 214
Requirements for Maintaining Operation Modes ………………… 217
Defining Normal Operation……… 219
Defining Exception Operation …. 221
Monitoring Servers and Work Processes………. 223
Checking the Operation Mode with the Control Panel…………. 225
Consistency Check ……………….. 227
Instances……………. 229
Creating an Instance Definition for One Server  232
Creating an Instance Definition for All Servers . 234
Prerequisites for Starting Remote Instances …. 236
Maintaining Instance Definitions  238
Profiles ………………. 240
Substituting Variables in Profile Values ………… 242
Where Do Profiles Come From? 244
Reference Server of a Profile….. 246
Profile Parameters ………………… 247
Important Profile Parameters ….. 249
Profile Files ……… 253
Start Profiles .. 255
Start Profile: Changing Instance Services ………………… 259
Default Profiles…………………. 261
Default Profile: Changing Global Instance Parameters. 264
Instance Profiles ………………. 266
Instance Profile: Automatic Adjustment of SAP Shared Memory Pools…………………. 269
Instance Profile: Changing Instance Parameters ………. 271
Switching Operation Modes Using Start and Instance Profiles …………………. 273
What to do After Installing an SAP Instance….. 274
Importing Profiles ……………… 276
Profile Maintenance ………………. 278
Creating and Copying Individual Profiles….. 281
Changing and Switching Profile Parameters …………………. 283
Profile Checks 285
Saving, Checking and Activating Profiles …………………. 287
Profile Versions………………… 290
Finding Manual Changes to a Profile ….. 292
Checking Active Parameters ……………… 294
Deleting Profiles…………… 296
External Operating System Command: Contents……………….. 298
Executing External Commands.. 300
Maintaining External Commands …………………. 302
External Commands: Overview . 304
Authorizations for External Commands ………… 306
Which Information is Displayed? 309
Displaying Detailed Information ………………. 312
Additional Parameters……….. 314
R/3 Profile Parameters in External Commands  316
Security Checks ……………….. 318
Check Modules ……………. 320
Processing Illegal Changes to External Commands……………. 322
Syslog Trace and System Alert Monitor …… 325
CCMS Monitoring … 327
Database Monitor … 328
SAP/Oracle Database Monitor… 329
SAP/Oracle Database Monitor: Introduction 330
SAP/Oracle Database Monitor: Main Screen ………………… 331
Sorts (Oracle) ……………… 332
Time Statistics (Oracle) … 333
Table Scans/Table Fetch (Oracle)………. 334
Redo Log Buffer (Oracle). 335
Calls (Oracle)………………. 336
Data Buffer (Oracle)……… 337
Shared Pool (Oracle) ……. 338
Detailed Analysis (Oracle) …………………. 339
Detail Analysis Menu (Oracle) ……………. 341
File System Requests (Oracle)…………… 342
Buffer Busy Waits (Oracle) ………………… 343
Wait Events (Oracle)…….. 344
Dictionary Buffer (Oracle)  346
SAP Client (Oracle) ……… 347
Oracle Sessions…………… 348
SQL Request (Shared SQL Area) ………. 349
Exclusive Lockwaits (Oracle)……………… 351
Database Message Log (Oracle)………… 352
Display V$ Tables (Oracle)………………… 353
Performance Database (Oracle)…………. 354
State on Disk (Oracle) ….. 355
Parameter Changes (Oracle) …………….. 356
Table Scans: Problem Analysis (Oracle) ….. 357
Checking for Full Tablespaces (Oracle) …… 359
Storage Management Errors (Oracle) ……… 361
Checking for Freespace Problems (Oracle)  363
Checking Storage Parameters (Oracle)……. 364
Problems with Maximum Number of Extents (Oracle)…….. 366
Displaying the Oracle Table Statistics ……… 367
SAP/Oracle Database Monitor: Status of the Data…………. 368
Consistency Checks …………. 370
Database – ABAP Dictionary Consistency………………… 371
Database Tables without a Unique Index…………………. 374
Creating Objects in the Database……….. 375
Displaying Object Definitions……………… 376
Naming Conventions for Indexes ……….. 377
Extent Analysis (Oracle)…………. 379
Tablespace Analysis (Oracle) …. 380
Tables/Index Analysis (Oracle) .. 382
Missing Indexes .. 384
SAP/Oracle Performance Monitoring Strategies…………………. 385
Monitoring the Data Buffer (Oracle)…………. 386
Monitoring the Shared Pool (Oracle) ……….. 388
Monitoring the Redo Log Buffer (Oracle)….. 390
Monitoring Calls (Oracle) …… 391
Monitoring Table Access Methods (Oracle). 393
Monitoring Sorting (Oracle)… 395
Diagnosing SAP/Oracle Performance Problems ………………… 396
A Transaction is Running Very Slowly (Oracle)……………… 397
Monitoring the Shared SQL Area (Oracle)… 398
Monitoring Table and Index Fragmentation (Oracle)………. 400
All Transactions are Running Slowly (Oracle) ……………….. 401
Checkpoint Monitoring (Oracle) ………………. 402
Checking the Optimizer Mode (Oracle) ……. 403
Monitoring Oracle Resources …………………. 404
No Applications Can Run (‘Frozen’ System) 405
Important init.ora Parameters (Oracle) …………. 406
DB_BLOCK_BUFFERS (Oracle)…………….. 407
DB_BLOCK_SIZE (Oracle)… 408
DB_WRITERS (Oracle) …….. 409
LOG_ARCHIVE_START (Oracle) …………… 410
LOG_BUFFER (Oracle) …….. 411
LOG_CHECKPOINT_INTERVAL (Oracle) .. 412
ROW_CACHE_CURSORS (Oracle) ……….. 413
SHARED_POOL_SIZE (Oracle)……………… 414
SORT_AREA_SIZE (Oracle)  415
TIMED_STATISTICS (Oracle)………………… 416
Data for the Oracle Database Monitor ………….. 417
Database Collector in Background Processing ……………… 418
Data for the Main Screen of the Database Monitor ………… 420
Data for the Screen: Database Performance: Tables and Indexes……….. 422
Data for the Database Alert Monitor ………… 423
SAP/Informix Database Monitor. 424
Looking at the Informix Database Overview 425
Shared Memory (Informix)…………………. 426
Data Buffers (Informix)….. 427
Cleaners (Informix) ………. 428
Log Buffers (Informix) …… 429
Database Activity (Informix)……………….. 430
Checkpointing (Informix).. 431
Asynchronous I/O (Informix)………………. 432
Detailed Database Analysis for Informix…… 433
Checking Wait Situations (Informix) ……. 434
Checking Chunk I/O Activity (Informix)… 435
Checking Sessions (Informix)…………….. 437
Checking Table Activity (Informix) ………. 438
Checking SQL Statements (Informix) ….. 440
Checking Exclusive Lockwaits (Informix) …………………. 442
Checking the Database Message Log (Informix) ………. 443
Checking State on Disk (Informix) ………. 444
Checking Pseudotables (Informix)………. 445
Checking Parameter Changes (Informix) …………………. 446
Checking Onstat Commands……………… 447
SAP/Informix Performance Monitoring …….. 448
Monitoring Data Buffers (Informix)………. 449
Monitoring the I/O Subsystem (Informix)  450
Monitoring Checkpoints (Informix)………. 452
Monitoring LRUS (Informix) ……………….. 454
Monitoring CPU VPs (Informix) ………….. 455
Monitoring the Informix Network Interface………………… 456
Monitoring Virtual Memory Usage (Informix)…………….. 457
Monitoring Optimizer Statistics (Informix)…………………. 458
Monitoring SQL Statement (Informix) ….. 459
Diagnosis of SAP/Informix Performance Problems ………… 462
Identifying Problems with One Transaction Running Slow (Informix) .. 463
Identifying Problems with All Transactions Running Slow (Informix) … 464
Identifying Problems with a Frozen System (Informix) .. 465
Analyzing Sessions and Tables (Informix) ……………….. 466
Analyzing Lockwaits (Informix) …………… 467
Analyzing Lockwaits with onstat (Informix)……………….. 468
Checking Key Tuning Parameters (Informix)…………………. 470
ALARMPROGRAM (Informix) ……………. 472
BUFFERS (Informix)…….. 473
CKPTINTVL (Informix)….. 474
CLEANERS (Informix) ….. 475
DD_HASHSIZE and DD_HASHMAX (Informix) ………… 476
LBU_PRESERVE (Informix)………………. 477
LOGBUFF (Informix)…….. 478
LRU_MAX_DIRTY, LRU_MIN_DIRTY (Informix)………. 479
LRUS (Informix) …………… 480
LTAPEDEV (Informix)…… 481
MULTIPROCESSOR (Informix)………….. 482
MULTIPROCESSOR, NUMCPUVPS, and SINGLE_CPU_VP (Informix)………………. 483
NETTYPE (Informix) …….. 484
NOAGE (Informix)………… 485
NUMAIOVPS (Informix) … 486
NUMCPUVPS (Informix).. 487
PHYSBUFF (Informix) ….. 488
PHYSDBS (Informix) ……. 489
PHYSFILE (Informix) ……. 490
SHMADD (Informix) ……… 491
SHMTOTAL (Informix) ….. 492
SHMVIRTSIZE (Informix)  493
SINGLE_CPU_VP (Informix)……………… 494
USEOSTIME (Informix) … 495
SAP/DB2/400 Database Monitor …………………. 496
Data for the Database Monitor (DB2/400) … 497
Database Monitor: Entry Screen (DB2/400)  498
Detail Analysis Menu (DB2/400)……………… 499
Database Lock Monitor (DB2/400) ……… 500
Wait Situations (DB2/400) …………………. 501
File Activity (DB2/400) ….. 502
Database Monitor History (DB2/400)…… 503
SQL Statements (DB2/400)……………….. 504
Table Scans (DB2/400) … 505
Sorts (DB2/400) …………… 506
Temporary Files (DB2/400) ……………….. 507
Index Advised (DB2/400). 508
Index Usage (DB2/400) … 509
Index Creates (DB2/400). 510
State on Disk (DB2/400).. 511
Consistency Checks (DB2/400)………….. 512
System Catalog Tables (DB2/400) ……… 514
Performance Tables (DB2/400)………….. 515
SQL Packages (DB2/400) …………………. 516
DB2/400 Database Monitor: Debugging and Tuning Tips ……. 517
When Should You Opt for Table Scan Access? (DB2/400) …………………. 518
When Should You Opt for Sort Access? (DB2/400) ……….. 519
Temporary Indexes versus Permanent Indexes (DB2/400) …………………. 520
Configuring the Database Monitor (DB2/400)………………… 521
Finding Database Storage Problems (DB2/400) ……………. 522
Finding Database Damage (DB2/400)……… 523
Performing Deleted Records Analysis (DB2/400) ………….. 524
Analyzing Wait Situations (DB2/400)……….. 525
Checking the Status of the QXDAEDRSQL Job (DB2/400) …………………. 526
SAP/DB2 UDB Database Monitor………………… 527
Using the DB2 UDB Database Monitor…….. 528
DB2 UDB for UNIX & Windows: Database Snapshot Screen ………………. 529
Buffer Pool – Overview (DB2 UDB)……… 529
Buffer Pool – Information (DB2 UDB)  530
Buffer Pool – Direct Access (DB2 UDB) ………………. 532
I/O Servers and I/O Cleaners (DB2 UDB) … 533
Locks and Deadlocks (DB2 UDB)……………. 534
Calls (DB2 UDB) ………………. 535
Sorts (DB2 UDB)………………. 536
Cache (DB2 UDB)…………….. 537
Tables (DB2 UDB) ……………. 538
Tablespaces (DB2 UDB)……. 539
Tablespaces – Buffer Pool (DB2 UDB) … 540
Tablespaces – Direct Access (DB2 UDB) …………………. 542
Applications (DB2 UDB)…….. 543
Applications Snapshot – Applications (DB2 UDB) ……… 544
Applications – Buffer Pool (DB2 UDB) …. 546
Applications – Locks & Deadlocks (DB2 UDB) ………….. 547
Applications – Statements (DB2 UDB)…. 548
Applications – Cache (DB2 UDB)………… 549
Applications – Agents (DB2 UDB)……….. 550
SQL Cache Snapshot (DB2 UDB) …………… 551
Lockwaits (DB2 UDB) ……….. 554
DB2 UDB Diag Log (DB2 UDB)………………. 556
Deadlocks (DB2 UDB) ………. 557
CLP Structures (DB2 UDB)… 558
Parameter Changes (DB2 UDB)……………… 559
Performance History (DB2 UDB) …………….. 560
Performance History: Call Statistics (DB2 UDB) ……….. 561
Performance History: Lock Statistics (DB2 UDB)………. 562
Logging Parameters (DB2 UDB) …………….. 563
SAP/DB2 Universal Database Performance Monitoring Strategies……………. 564
Checking the Size of the Database Buffers (DB2 UDB)….. 565
Checking the Buffer Pool Hit Ratio (DB2 UDB)…………. 566
Monitoring Lock List Utilization (DB2 UDB)………………. 567
Monitoring the Sort Heap (DB2 UDB)….. 568
Monitoring Cache Quality (DB2 UDB) …. 569
Buffer Pool (DB2 UDB)…. 570
Sort Heap (DB2 UDB)…… 571
Checking Consistency (DB2 UDB) ………….. 572
State on Disk (DB2 UDB)…… 573
Space Statistics: Database (DB2 UDB).. 574
Space Statistics: Tablespaces (DB2 UDB)……………….. 575
Space Statistics: Tables and Indexes (DB2 UDB) …….. 576
State on Disk: Tablespaces (DB2 UDB). 577
State on Disk: Tables and Indexes (DB2 UDB)…………. 579
Run Statistics (DB2 UDB) …………….. 582
Finding Storage Management Problems (DB2 UDB) ……… 583
SAP DB – Monitoring and Analysis ………………. 584
Database Monitor (SAP DB). 585
Cache Activity (SAP DB) . 586
Commands (SAP DB)…… 587
I/O Activity (SAP DB)……. 588
Locking Activity (SAP DB) …………………. 589
Logging Activity (SAP DB)…………………. 590
Scan and Sort Activity (SAP DB)………… 591
Detail Analysis Menu (SAP DB)………………. 592
DB Processes (SAP DB) . 594
I/O Statistics (SAP DB)…. 595
Cache Statistics (SAP DB) ………………… 596
Region Statistics (SAP DB) ……………….. 597
DB Filling Statistics (SAP DB) ……………. 598
Runtime Environment (SAP DB) ………… 599
Parameter Changes (SAP DB)…………… 600
Logging Statistics (SAP DB)………………. 601
Storage Overview (SAP DB) ……………… 603
Exclusive Lockwaits (SAP DB) …………… 604
Tables/Indexes (SAP DB) 605
Control Log File (SAP DB)…………………. 606
Database Message Log (SAP DB)……… 607
Overview (SAP DB) ……… 608
Diagnostic Monitor (SAP DB) …………….. 609
Bottleneck Analysis (SAP DB)……………. 611
Bottleneck Analysis Messages………. 612
Low data cache hit rate ………………… 613
Low catalog cache hitrate……………… 614
Low converter cache hit rate …………. 615
Cache swaps ………….. 616
High read rate (physical) ………………. 617
High read activity (physical) ………….. 618
High write activity (physical) ………….. 619
High read rate (virtual) 620
High parse activity …… 621
Low hit rate for table scans …………… 622
Low hit rate for optimizer strategy ….. 623
Low hit rate on <deletes/updates> …. 624
‘Physical Temp Page Writes’ high ….. 625
High collision rate on SQL locks…….. 626
Long waiting time with SQL collisions …………………. 627
Queue on SQL collisions………………. 628
Lock escalations (<number of> table locks)…………. 629
Log queue overflows .. 630
‘Log I/O-Queue’ too small……………… 631
High log activity ………. 632
Long write transactions…………………. 633
High collision rate on <name> region 634
High TAS collision rate …………………. 635
Large number of time-consuming commands………. 636
Long command runtime in DB kernel  637
Large number of self suspends (dispatches) ……….. 638
Long vsuspend time (user tasks) …… 639
Large number of vsleeps (user tasks) …………………. 640
Performance Database (SAP DB) ………. 641
Database Assistant (SAP DB) ………………… 642
Current System Status (SAP DB)……….. 643
Processes (SAP DB) .. 644
Task Manager (SAP DB)………….. 645
DB Threads (SAP DB)……………… 647
I/O Operations (SAP DB)………………. 648
Overview (SAP DB)…………………. 649
Backup (SAP DB).. 650
Synchronization Objects (SAP DB)… 651
SQL Locks (SAP DB) . 652
Waits (SAP DB)….. 653
Total (SAP DB)…… 654
Space Areas (SAP DB) ………………… 655
System Settings (SAP DB)……………………………………………………………..657
Problemenanalyse (SAP DB) …………….. 658
Bottlenecks (SAP DB)  659
SQL Performance (SAP DB) …………. 660
Command Analysis (SAP DB)…… 661
Resource Use (SAP DB)………….. 662
Messages (SAP DB)… 663
Current Messages (SAP DB) ……. 664
Old Messages (SAP DB)………….. 665
Errors (SAP DB)…. 666
DBA Logs (SAP DB)… 667
Tables (SAP DB) …….. 668
Kernel Trace (SAP DB) ………………… 669
Configuration (SAP DB)… 670
Parameters (SAP DB)…… 671
Current (SAP DB)……. 672
Change History (SAP DB) …………….. 673
Devspaces (SAP DB) …… 674
System Checks (SAP DB) …. 675
Database Operations Monitor (SAP DB) 676
Database Alert Monitor (SAP DB) ………. 677
Statistics (SAP DB) …………… 679
Database Fill Level (SAP DB) ……………. 680
Database Activity (SAP DB) ………………. 681
Diagnosing Performance Problems (SAP DB).. 682
A Transaction is Running Very Slowly (SAP DB) …………… 683
Missing Indexes (SAP DB)…. 684
Checking Database Free Space (SAP DB) . 686
Checking Free Log Space (SAP DB)……….. 687
Consistency Checks (SAP DB)……………….. 688
SAP liveCache – Monitoring and Administration …………………. 690
liveCache: Connection………. 691
liveCache: Administration ….. 693
Starting the liveCache…… 694
Stopping the liveCache…. 695
Initializing the liveCache .. 696
System Messages ……….. 698
liveCache: Configuration……. 699
Extending the Data Area.. 700
liveCache: Console …………… 701
I/O Operations in the liveCache………….. 702
Process Analysis …………. 703
Process Overview……. 704
Active Tasks …………… 705
Runnable Tasks………. 706
Sleeping Tasks ……….. 707
Task Activities…………. 708
Causes of Suspends .. 709
Space Management……… 710
Space Use ……………… 711
PSE Statistics …………. 712
PSE Data……………….. 713
Synchronization Objects……………….. 714
Runtime Environment. 715
Time Use ……………….. 716
liveCache Monitor …………….. 717
OMS/liveCache Base Layer……………….. 718
Class Container …………… 720
Caches…… 722
SQL Statistics ……………… 723
liveCache: Performance…….. 724
System Messages ……….. 725
liveCache Attributes……… 726
Cache Hit Rates…………… 727
Disk Access ………………… 728
Status……. 729
Detail Analysis …………….. 730
Data Cache…………….. 731
Log Caches …………. 732
Devspace Statistics in the liveCache  733
liveCache Configuration ……………….. 735
Active Parameters …… 736
Displaying the OMS Versions………… 737
Transactions …………… 738
Database Procedures. 739
SAP/SQL Server Database Monitor……………… 740
Memory Usage…………………. 741
Space Usage . 743
Server Engine/Elapsed ……… 744
SQL Requests 746
Detail Analysis Menu ………… 747
Operating System Monitor ……….. 750
Calling the Operating System Monitor ………….. 752
Checking CPU Statistics ………… 754
Checking Memory Utilization…… 756
OS/400 Wait States……………….. 758
Activity Level (OS/400) ……… 761
Ineligible Queue (OS/400) …. 763
Job Priority (OS/400) ………… 765
Pool Data in the OS/400 Operating System  766
PTF Check in the OS/400 Operating System Monitor…….. 768
Operating System Collector……… 769
Special Features of Operating Systems ……….. 772
SAPOSCOL on a UNIX Host  775
Controlling SAPOSCOL from the Operating System………. 777
Collector Home Directory Path & Profile Parameters ………….. 782
Displaying the Collector Status……………….. 784
Displaying Collector Data…… 787
Setting Up RFC Communication to RFCOSCOL………………… 789
Installing SAPOSCOL/RFCOSCOL for a Dedicated DB Server……………. 792
Interpreting the Data ……………… 794
Starting SAPOSCOL……………… 798
Stopping SAPOSCOL ……………. 800
Troubleshooting: Operating System Collector .. 803
Controlling SAPOSCOL from the R/3 System .. 806
Reducing CPU Load ……………… 810
The Alert Monitor…. 812
The Monitoring Architecture: Concept ………….. 814
What is Predefined in the Alert Monitor? ….. 817
Working with the Alert Monitor Tree ………… 820
Tree Components …………….. 822
Working with Log Attributes……………….. 825
Tutorial …………… 827
Detailed Tutorial……………….. 829
Alerts ……………… 833
The Alert Browser: Working with Alerts ……. 835
Starting the Alert Monitor. 837
Starting the Alert Browser and Displaying Alerts……….. 839
Switching Views: System Status, Open Alerts ………….. 841
Switching Levels of Detail in Views …….. 842
Switching Between Monitors ……………… 844
Stopping and Restarting Alert Generation………………… 846
Monitoring Multiple R/3 Systems ………… 848
Turning Automatic Refresh On and Off .. 852
Setting the Time Zone ….. 854
Monitoring the Operating System Using the Alert Monitor (DB2/400).. 856
Monitoring Memory Management Using the Alert Monitor (DB2/400) . 857
Monitoring the Database Using the Alert Monitor (DB2/400) …………… 858
Alert Monitoring Tree: Illustration………… 860
Completing Alerts ………… 861
Displaying Completed Alerts ……………… 863
Reorganizing Completed Alerts………….. 865
Resetting MTEs and Alerts………………… 867
Displaying Detailed Data and Adjusting the Display ….. 869
Availability Monitoring ……………. 871
Setting Up Availability Monitoring ……………. 872
Customizing Availability Monitoring …………. 874
Rule MTEs: Rule Descriptions and Use………… 876
Monitor Sets… 880
Customizing the Alert Monitor…. 882
Creating Your Own Monitors  884
Changing an Existing Monitor…………………. 887
Changing Properties and Maintaining Methods……………… 889
Method Assignments……………… 891
Defining, Releasing and Transporting Methods……………… 893
Starting Methods………………. 896
Assigning Methods to MTE Classes and Monitoring Properties Variants . 898
Defining Automatic Alert Notification ……….. 900
Monitoring Properties Variants… 903
Creating and Changing Monitoring Properties Variants ….. 905
Copying Monitoring Properties Variants …… 908
SAP-DEFAULT ………………… 911
Creating a New SAP-DEFAULT Variant…… 913
Performance Database ………….. 915
Displaying Performance Data …………………. 917
Graphing Performance Data. 919
Creating and Scheduling a Reorganization Schema………. 921
Assigning a Reorganization Schema to an Attribute Group …………………. 924
Maintaining the Performance Database …… 926
Deleting Local Files…………… 928
Self-Monitoring in the Alert Monitor………………. 929
Increasing the Shared Memory Area ……….. 931
System Groups in the Alert Monitor ……………… 933
Maintaining Local System Groups …………… 935
Maintaining Centralized System Groups ….. 936
Transaction- and Client-Specific Monitoring ….. 938
Monitoring Release 3.x Systems …………………. 940
SQL Server Alert Monitor ……….. 941
Alerts for SQL Server………… 942
Viewing and Customizing Threshold Values …………………. 945
The CCMS System Repository….. 946
Filling or Updating the Repository………………… 947
Checking for Repository Processing Errors …… 948
Creating the CSMREG User …… 949
Updating the Central Repository 950
Updating the Local Repository… 951
Displaying Information from the Repository …… 952
Creating a Central Repository…. 953
The Control Panel… 956
Starting the Control Panel ………. 958
Developer (Internal) Traces ……. 960
Accessing Log Files ………………. 963
Workload Monitor… 965
User Modes…….. 967
Analysis Views and Profiles ……. 968
Workload Statistics………………… 969
Response Times: Rules of Thumb ………….. 972
Displaying Application Server Workload…… 974
Displaying Workload over Specific Time Periods …………… 976
Displaying Users per Instance ………………… 978
Displaying Transaction Workload ……………. 979
Displaying Spool Statistics…. 980
Comparing Workload Between Servers……. 981
Saving User-Specific Views.. 982
Displaying Top 40 Response Times………… 983
Displaying Application Statistics ……………… 984
Business Transaction Analysis ……………….. 985
Working with the Workload Collector ……………. 987
Working with the Performance Monitor Collector………………… 988
Reorganizing the Table MONI…. 989
Configuring the Data Collector… 991
Scheduling Data Collector Reports………………. 994
RSHOSTPH …….. 995
RSHOSTDB …….. 997
RSORASNP……. 999
RSDBPREV …… 1001
RSORATDB …… 1003
RSORAPAR….. 1005
RSORA811 ……. 1007
RSSTATPH…… 1009
RSSTAT60……. 1011
RSSTAT80……. 1013
RSSTAT88……. 1015
RSSTAT87……. 1016
RSSTAT83……. 1017
Parameters for RSSTAT80/83 and RSSTAT87/88/89……….. 1018
Data Archiving Monitor…………… 1020
Messages and Alerts……………. 1022
Additional Technical Information………………… 1024
R/3 Accounting Interface………… 1025
Database Resources……………. 1027
Operating System Resource…. 1029
R/3 System Resources ………… 1030
Installing and Setting up the R/3 Accounting Interface………. 1031
Creating an Account…………….. 1032
Creating the Table of Contents  1033
Reading Accounting Data …….. 1035
Example 1: Using the User Master Record….. 1037
Example 2: Not Using the User Master Record………………… 1040
Global Work Process Overview: Contents …… 1042
System-wide Work Process Overview ………… 1043
Selecting Work Processes.. 1044
Detailed Work Process Information …… 1046
SAP Buffers………. 1047
Buffer Components ……………… 1048
Buffer Synchronization…….. 1050
Buffer Types…… 1052
Repository Buffers (Nametab Buffers)……. 1053
Table Buffers 1055
Displaying Table Buffers 1056
Program Buffers……………… 1057
SAPgui Buffers……………….. 1058
Roll and Paging Buffers, Extended Memory………………… 1059
SAP Calendar Buffer……….. 1060
Import / Export Buffers …….. 1061
SAP Cursor Cache………….. 1062
SAP Cursor Cache for Oracle, Informix, Adabas and DB2 for AIX …. 1063
SAP Cursor Cache for MS SQL Server 1065
The Buffer Monitor ………………. 1066
Buffer Monitor and Tune Summary…………….. 1067
Tuning SAP Buffers……………… 1071
Special Aspects of Tuning .. 1073
Working with Call Statistics. 1075
Buffer Quality …. 1076
Reasons for Poor Buffer Quality ……………. 1077
High Buffer Quality………….. 1078
Typical Parameter Settings for SAP Buffers………………… 1080
Object Swapping…………….. 1083
Checking Memory Usage ………………… 1084
Changing Buffer Sizes………………… 1085
Adjusting Pool Sizes. 1086
How Much Operating System Paging is Acceptable? …… 1088
Directory Space and Data Space ………….. 1089
Microsoft Management Console: Windows NT…………………. 1090
Starting the MMC ………………… 1092
Layout of R/3 Manager Snap-In…………………. 1093
Context Menu of the R/3 Manager Snap-In …. 1095
Changing the Configuration of the MMC……… 1097
Configuring MMC for Active Directory Services………………… 1099
MMC Enhancements for Active Directory Services …………… 1102
Database Administration in CCMS………………. 1104
SAP/Oracle DBA in CCMS ………. 1105
Using the DBA Planning Calendar: Oracle ….. 1107
Prerequisites for Using the CCMS DBA Tools: Oracle….. 1110
Selecting Action Patterns: Oracle ………….. 1112
Adding Actions to DBA Planning Calendar: Oracle ………. 1115
Editing/Deleting Actions (Oracle)…………… 1117
Checking the Results of Actions: Oracle … 1119
Displaying Database Alerts for the DBA Planning Calendar: Oracle …… 1122
Troubleshooting: Oracle…… 1123
Displaying Backup Logs and Status: Oracle… 1125
Displaying Backup Logs: Oracle……………. 1126
Displaying Redo Log Backups: Oracle …… 1128
Using the Recovery Report: Oracle ……….. 1130
SAPDBA Logs: Oracle …………. 1131
CCMS Support for the Cost-Based Optimizer: Oracle……….. 1132
Updating Cost-Based Optimizer Statistics Automatically . 1134
Checking and Updating Statistics for a Single Table: Oracle……………… 1136
Maintaining the Control Table DBSTATC.. 1138
Standard Operations for CBO Statistics …. 1141
Database System Check………. 1142
Configuring Database System Check (Oracle)…………….. 1143
Parameters and Alerts for Database System Check… 1150
Displaying Alert Messages from Database System Check ………………… 1162
Using the DB Operations Monitor ………………. 1165
Maintaining Database Connection Information…………………. 1168
Maintaining Database Parameters: Oracle….. 1170
Monitoring the Oracle Database ………………… 1175
Space Management Alerts.. 1176
Database Performance Alerts……………….. 1179
Database Backup/Restore Alerts…………… 1181
Database R/3 Consistency Alerts ………….. 1182
Running Jobs Alerts………… 1184
Database Health Alerts ……. 1185
SAP/Informix DBA in CCMS ……. 1192
Getting Started in CCMS with Informix DBA… 1194
DBA Planning Calendar ……….. 1195
DBA Planning Calendar (Informix)…………. 1197
Choosing an Action Pattern in the DBA Planning Calendar…………… 1199
Scheduling Actions in the DBA Planning Calendar ….. 1201
Checking the Results of Actions in the DBA Planning Calendar…….. 1204
Archiving or Backing Up the Database in the DBA Planning Calendar (Informix) …. 1207
Backing Up the Logical Log in the DBA Planning Calendar (Informix) ………………… 1209
Backing Up the Logical Log (Automatic) in the DBA Planning Calendar (Informix).. 1211
Checking Statistics in the DBA Planning Calendar (Informix) ………… 1213
Updating Statistics in the DBA Planning Calendar (Informix)…………. 1214
Checking the DB System in the DBA Planning Calendar (Informix) .. 1217
Troubleshooting in the DBA Planning Calendar (Informix)…………….. 1219
Update Statistics in CCMS (Informix) …………. 1220
Checking and Updating Statistics for a Single Table in CCMS (Informix)…………………. 1221
Configuring Update Statistics in CCMS (Informix)……….. 1223
DB System Checks in CCMS (Informix) ……… 1226
Configuring DB System Checks in CCMS (Informix)…….. 1227
Running DB System Checks in CCMS (Informix)…………. 1229
Viewing DB System Checks in CCMS (Informix)………….. 1230
Archive and Backup Monitor in CCMS (Informix) ……………… 1232
Using the Archive and Backup Monitor in CCMS (Informix)……………….. 1233
Using the DB Operations Monitor ………………. 1235
Monitoring the Database with the Alert Monitor (Informix)….. 1238
SAP/DB2 Universal Database DBA in CCMS… 1240
Using the DBA Planning Calendar (DB2 UDB)…………………. 1242
DBA Planning Calendar (DB2 UDB)………. 1244
Prerequisites for Using the DBA Planning Calendar (DB2 UDB) ………… 1246
Choosing a Predefined Action Pattern (DB2 UDB) ………. 1247
Maintaining Actions in the DBA Planning Calendar (DB2 UDB)………….. 1249
Scheduling Actions in the DBA Planning Calendar (DB2 UDB) ………….. 1251
Displaying the Status of a Day’s Actions (DB2 UDB) ……. 1253
Checking the Results of Actions (DB2 UDB)……………….. 1254
Troubleshooting (DB2 UDB) …………………. 1256
Update Statistics (DB2 UDB) … 1257
Scheduling Update Statistics + Reorgcheck (DBSTATC) (DB2 UDB) …. 1258
Scheduling Upd. Statistics + Reorgcheck All Tables (DB2 UDB)………… 1259
Database System Monitoring in CCMS (DB2 UDB) ………….. 1261
Displaying the Results of Database System Monitoring (DB2 UDB)……. 1263
Configuring Database System Monitoring (DB2 UDB) ….. 1265
Initiating a Log Archive Backup Manually (DB2 UDB) ……….. 1267
SAP/DB2/400 DBA in CCMS ……. 1268
Monitoring the Database Using the Alert Monitor (DB2/400). 1269
SAP DB – DBA in CCMS………….. 1271
DBA Planning Calendar (SAP DB) …………….. 1273
Prerequisite (SAP DB) …….. 1275
Scheduling Concept (SAP DB) ……………… 1276
Predefined Action Patterns (SAP DB) ……. 1278
Automatic Log Backup (SAP DB) ………….. 1280
Adding an Action (SAP DB)  1282
Changing or Deleting an Action (SAP DB)  1284
Action Results (SAP DB) …. 1286
Troubleshooting (SAP DB).. 1287
DBA Action Logs (SAP DB) ….. 1289
Optimizer in CCMS (SAP DB).. 1292
Single Table Statistics (SAP DB)…………… 1295
Maintaining DBSTATC Control Table (SAP DB) ………….. 1296
SAP/ MS SQL Server DBA in CCMS (BC-DB-MSS-DBA) ……. 1298
Database Backup………………… 1299
Backup Strategy……………… 1302
Backup Types ……………. 1303
What Needs to be Backed Up? ………… 1305
Backup Device Management……………. 1308
Disk Configuration ……… 1311
Executing Backups …………. 1313
Backing Up with R/3 …… 1314
Backing Up with the Enterprise Manager ……………….. 1317
Monitoring Backups ………… 1319
Checking Individual Backups with R/3.. 1320
Checking all Backups with R/3 …………. 1321
Checking Backups with the Enterprise Manager……… 1322
Database Restore ……………….. 1324
Distribution of Files to Disk . 1327
Restoring the R/3 Database after Disk Crash………………. 1329
Backing Up the Current Transaction Log ……………….. 1331
Restoring the Database and Log Backups……………… 1332
Restoring a Backup from Device ………. 1334
Restoring After Executables Disk Crash…. 1336
Restoring the msdb Database from Device…………….. 1338
Database Server Checks ……… 1339
Viewing the Error Log with R/3 ……………… 1341
Viewing the Error Log with the Enterprise Manager ……… 1342
Monitoring the R/3 Data Disk………………… 1343
Monitoring the R/3 Log Disk 1344
Checking Consistency of the Database….. 1345
Checking Consistency of Individual Tables …………………. 1347
Checking for Missing Indexes……………….. 1348
Database Server Management  1349
Starting and Stopping the SQL Server …… 1350
Setting SQL Server Startup Options………. 1352
Changing Passwords………. 1353
Registering a Server ………..1355
Changing the Autogrow Settings …………… 1356
Configuring the SQL Server 1357
Configuring Databases ……. 1358
Setting Single-User Mode… 1359
Executing Queries…………… 1361
Moving R/3 Database Files to New Disks.. 1363
Displaying the SQL Server Version ……….. 1365
Database Performance Tuning  1366
Increasing the Size of the NT Page File …. 1367
Optimizing the Virtual Memory Manager … 1368
Removing the Screen Saver…………………. 1369
Database Management Tools.. 1370
Enterprise Manager ………… 1371
R/3 Planning Calendar…….. 1373
Working with the R/3 Planning Calendar… 1375
R/3 Backup Monitor (MS SQL Server)……. 1377
R/3 Static Database Monitor (MS SQL Server) ……………. 1379
SQL Server Alert Monitor…. 1380
Alerts for SQL Server……….1381
Viewing and Customizing Threshold Values ……………….. 1384
SAP/SQL Server Database Monitor ………. 1385
Data Archiving….. 1386
Displaying Archiving Objects and Tables ……. 1387
Determining Space Information (Oracle) ……… 1389
Determining Space Information (SAP DB)……. 1390
Determining Space Information (Informix) …… 1391

Read this SAP CCMS – Computing Center Management System Monitoring, control and configure guide

Leave a Reply