SAP Database Administration with IBM DB2

1. Auflage 2013
ISBN: 978-1-59229-449-7
Verlag: Rheinwerk Verlag

Buch, Englisch, 753 Seiten, Format (B × H): 152 mm x 229 mm

Reihe: SAP PRESS: englisch

When you’re working with IBM DB2 for Linux, Unix, and Windows, you’re responsible for maintaining the Rolls Royce of the SAP-certified database systems. This book helps you keep it shiny and up to speed: you’ll find all of the unique, powerful administrator’s tools, tasks, and strategies that IBM and SAP have developed. From setup and sizing to troubleshooting the database, you’ll find the information you need for a smooth ride.



1. SAP and IBM DB2 for LUW Architecture
Understand how different systems are structured, and learn how to use data models and SQL queries to design your database.



2. Getting the Most out of Your System
See the results of using common SAP tools and components in your IBM DB2 for LUW system, including configuration of SAP NetWeaver BW with DB2 for LUW.



3. Administrative Tools
Get the database commands, file and storage locations, log files, and tablespaces you need to effectively manage your system’s performance (SAP and non-SAP).



4. Administrative Strategies
Find in-depth discussion of planning for and managing different sized systems, working with different data loss prevention options and methods, and more.



5. Manage the Lifecycle
Learn the steps and tools you need for everything from planning installation, applying patches and updates, and performing backup and restore, to uninstalling the system.


Highlights include: - DB2 for LUW database

- DBA Cockpit

- SAP system landscapes and architecture

- Online data backup, restore, and recovery

- Operational monitoring

- Data and tablespace management

- SAP Solution Manager

- Event Monitor

- Database Partitioning Feature

- pureScale

- Change and Transport System

- Monitoring

- Recovery

- High Availability Disaster Recovery (HADR)

- Transport Management System

Autoren/Hrsg.

Faustmann, André

Greulich, Michael

Siegling, André

Wegener, Benjamin

Zimmermann, Ronny

Fachgebiete

• Mathematik | Informatik EDV | Informatik Technische Informatik Systemverwaltung & Management
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung IBM DB2
• Mathematik | Informatik EDV | Informatik Business Application Unternehmenssoftware SAP

Inhaltsverzeichnis

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

Über Autor(innen)

Faustmann, André
André 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.

Wegener, Benjamin
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.

Zimmermann, Ronny
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.

Siegling, André
Since 2003, André 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.