SAP Database Administration IBM DB2

Andre Faustmann studied business informatics at the Otto von Guericke University of Magdeburg, Germany. Since 2000, he's worked at the SAP University Competence Center (SAP UCC) in Magdeburg, where he is responsible for hosting a wide range of SAP solutions for universities, universities of applied sciences, and vocational schools throughout Germany, Europe, the Middle East, and Africa. His many years of experience with SAP systems range from release 4.6C to current SAP NetWeaver 7.40. He is also a certified technology consultant for SAP NetWeaver AS, as well as SAP NetWeaver Portal and Knowledge Management. Michael Greulich studied business informatics at the Otto von Guericke University of Magdeburg. He started his career as a researcher in the SAP University Competence Center Magdeburg in 2009. There, he worked as a certified SAP NetWeaver consultant in the field of basic administration with a focus on SAP Solution Manager and SAP BusinessObjects. As head of an SAP implementation project UCC service desk for more than 400 national and international institutions with more than 60,000 users, he is familiar with many facets of project management. Since 2003, Andre Siegling has worked at the SAP University Competence Center at the Otto von Guericke University of Magdeburg. As member of the SAP Basis team, he is one of eight certified SAP Basis specialists. He is responsible for SAP CRM, SAP NetWeaver Process Integration, SAP BusinessObjects, and other solutions that are running on IBM DB2 for LUW databases within SAP UCC's cloud service provisioning to serve the needs of more than 400 partners in Europe, the Middle East, and Africa to enable them to integrate SAP solutions in teaching, education, and other scientific projects. Benjamin Wegener studied business informatics and has worked at the SAP University Competence Center at the Otto von Guericke University Magdeburg since 2010. There, he is a part of the SAP Basis team with a focus on SAP solutions running on IBM DB2 for LUW such as SAP CRM and SAP Solution Manager, as well as other solutions including SAP HANA. As the head of the SAP implementation project UCC ""System Monitoring with SAP Solution Manager,"" he is responsible for the setup and operation of a monitoring system covering more the 160 SAP systems and over 60,000 users. Ronny Zimmermann has worked at the SAP University Competence Center at Otto von Guericke University in Magdeburg since 2002, and has been a certified consultant for SAP NetWeaver and SAP NetWeaver Portal for over 10 years. He is responsible for the infrastructure and architecture of the UCC data center. He has been a speaker of the Virtualization and Cloud Computing group of the German SAP user group (DSAG) since 2009. When he is not busy pursuing his passion for soccer and passing this on to his sons, Aron and Remo, he spends his time motorcycling with his wife, Urte, and watching his daughter, Laura, dancing.

Foreword. 15

Acknowledgments. 17

1. Introduction. 19

1.1. Who This Book Is For. 21

1.2. Focus of This Book. 22

1.3. Contents of This Book. 22

2. SAP System Landscapes. 25

2.1. SAP System Architecture. 26

2.2. Installation Options for SAP Systems. 30

2.3. Database Layer for IBM DB2 for LUW Environments. 34

2.4. Three-System Landscape in Brief. 38

2.5. SAP System Landscapes with More Than One Solution. 40

2.6. Software Logistics and System Landscape in Detail. 44

2.7. SAP Instance in Detail. 63

2.8. Summary. 68

3. Basics and Architecture of the IBM DB2 for LUW Database. 71

3.1. Concepts and Basics of Relational Databases. 71

3.2. Process Architecture of the IBM DB2 for LUW Database. 89

3.3. Memory Management and Buffers. 103

3.4. Tablespaces. 119

3.5. Transaction Logs and Trace Files. 154

3.6. Parameters and Configuration of the DB2 for LUW Database. 170

3.7. DB2 for LUW Security Concept. 180

3.8. Database Partitioning. 195

3.9. High Availability Disaster Recovery. 208

3.10. DB2 pureScale Technology. 217

3.11. Summary. 231

4. Lifecycle. 233

4.1. Installation Planning. 234

4.2. Installation of SAP Systems. 243

4.3. Updating the SAP System. 279

4.4. Upgrade for SAP Systems. 294

4.5. System Copy. 311

4.6. Uninstalling SAP Systems. 317

4.7. Summary. 325

5. Administration Tools Inside and Outside the SAP System. 327

5.1. Operating System Tools. 327

5.2. DBA Cockpit. 335

5.3. Administrative Tools for Troubleshooting. 458

5.4. Summary. 462

6. Backup, Restore, and Recovery. 463

6.1. Infrastructure Planning. 464

6.2. Objects That Need Data Backup. 466

6.3. Data Backup Methods. 470

6.4. Recovery Methods. 476

6.5. Recovery Scenarios. 483

6.6. Backup Strategies. 490

6.7. DB2 for LUW Backup and Restore Tools. 501

6.8. Integration with DB2 for LUW in HP Data Protector. 554

6.9. Summary. 573

7. Monitoring DB2 SAP Systems with SAP Solution Manager. 575

7.1. Event Monitoring. 576

7.2. Monitoring with SAP Solution Manager 7.1. 592

7.3. Configuration of IBM DB2 10.1 LUW Monitoring with SAP Solution Manager 7.1. 616

7.4. Technical Monitoring Operations with SAP Solution Manager 7.1. 641

7.5. Summary. 645

8. SAP NetWeaver Business Warehouse and IBM DB2 for LUW. 647

8.1. SAP NetWeaver BW: An Overview. 647

8.2. DB2 for LUW as Database for SAP NetWeaver BW. 664

8.3. Summary. 695

9. Common Problems and Their Solutions for DB2 Administrators. 697

9.1. Sources for Help to Solve Problems. 698

9.2. Approach to Troubleshooting. 708

9.3. SAP Instance Cannot Connect to the Database. 711

9.4. Poor Database Performance. 716

9.5. SAP System Does Not Start Due to a Missing License. 720

9.6. Database Is in Backup Pending Mode. 722

9.7. Log Archive Destination Is Not Available. 725

9.8. The Transaction Log for the Database Is Full. 728

9.9. DB2 Backup Runtime Unacceptably High. 731

9.10. Summary. 735

The Authors. 737

Index. 739