SAP MaxDB Administration
1st Edition
Published on 1. June 2009
Book
Hardback
326 pages
978-1-59229-299-8 (ISBN)
Description
This book provides you with a detailed overview of the current MaxDB release 7.7. When necessary, it will also apply to earlier releases. The book deals with the internal structures of the database, and is based on the interaction with the SAP NetWeaver Application Server. The book will help you to quickly resolve errors in typical situations, explain in detail the typical administration tasks, and help administrators find performance bottlenecks.
After reading this book, you will be prepared to own and administer MaxDB. The book is filled with step-by-step instruction, schematic diagrams, and helpful screenshots.
After reading this book, you will be prepared to own and administer MaxDB. The book is filled with step-by-step instruction, schematic diagrams, and helpful screenshots.
More details
Persons
Author
André Bögelsack studied information management at the Otto von Guericke University in Magdeburg, Germany. During his years of study, he already concentrated on a multitude of database management systems and participated in research and development projects. Since 2006, he has been working at the SAP University Competence Center (SAP UCC) at the Technische Universität München, Germany, and has been system and database administrator for almost 100 SAP installations. He is a certified SAP NetWeaver Technology Consultant for SAP Web AS 6.40 and SAP MaxDB 7.5 and, in addition to his system administration work, he is also increasingly engaged in ABAP programming. His research activities within the scope of his dissertation focus on the behavior of SAP systems in paravirtualized machines. Within this context, he concentrates in particular on the scaling and performance of SAP systems.
Stephan Gradl studied computer science with an economics minor and earned his doctorate from the Technische Universität München, Germany. In numerous projects during his studies, he already dealt with the migration and optimization of databases. He therefore chose "High-Performance Data for RFID Applications" as the topic of his thesis, which was supervised by Professor emeritus Rudolf Bayer. Since 2006, he has been an employee at the SAP University Competence Center (SAP UCC) at the Technische Universität München, Germany, and has been jointly responsible for the operation of approximately 100 SAP installations as a system and database administrator. Since completing his certification as an SAP NetWeaver Technology Consultant for SAP Web AS 6.40 and MaxDB 7.5 at the beginning of 2007, he has been focusing on the administration and setup of externally facing portals on the basis of SAP NetWeaver Portal. In his research, Stephan Gradl concentrates on the behavior and performance of applications in service-oriented architectures (SOAs).
Manuel Mayer grew up in South Tyrol and studied computer science (Bachelor) and information management (Master) at the Technische Universität München, Germany. During his studies, as a working student at Fraunhofer-Gesellschaft, he dealt with the migration of databases. In 2006, he engaged in business process management and data storage in distributed systems at the Stevens Institute of Technology in New York. Since 2007, he has been working as a research assistant for the chair of information management in the area of SAP NetWeaver and MaxDB administration at the SAP University Competence Center. In addition, he is in charge of the chair's technical infrastructure and his current research work focuses on workflow management systems in the healthcare segment.
Helmut Krcmar has held the chair for Information Systems at the Information Technology Department of the Technische Universität München (TUM) since October 1, 2002. He is a member of the Information Technology Department, a secondary member of the Economics Department, and a member of the Carl von Linde Academy. Since 2004, he has been a member of the board of the elite graduate program in finance and information management (FIM) in the elite network of Bavaria, Germany. Between October 2003 and May 2007, he was academic director of the ¡communicate! program, and has been scientific director of the Center for Digital Technology and Management (CDTM) of TUM since January 2004.
His research interests include information and knowledge management; engineering and management of IT-based services; piloting innovative information systems in healthcare, environmental management, and e-government; and computer support of cooperation in distributed and mobile work and learning processes. His book Informationsmanagement has seen four editions.
Content
1. Introduction to SAP MaxDB. 11
. 1.1. History. 11
. 1.2. SAP MaxDB Features. 12
. 1.3. Useful Internet Sources. 16
. 1.4. Structure of this Book. 18
2. Overview of SAP MaxDB. 21
. 2.1. SAP MaxDB -- Instance Types. 21
. 2.2. SAP MaxDB -- Software. 26
. 2.3. SAP MaxDB -- User Concept. 45
. 2.4. Database Concepts. 55
. 2.5. Summary. 87
3. SAP MaxDB and SAP. 89
. 3.1. SAP Architectures. 89
. 3.2. Communication with SAP MaxDB. 93
. 3.3. Important Transactions. 102
. 3.4. Summary. 114
4. Administration Tasks. 115
. 4.1. Server Software Installation and Upgrade. 115
. 4.2. Creating and Initializing the Database. 130
. 4.3. Configuring the Database. 146
. 4.4. Database Backup. 163
. 4.5. Database Recovery. 186
. 4.6. Consistency Checks. 196
. 4.7. Deleting the Database. 200
. 4.8. Summary. 206
5. Performance Tuning. 207
. 5.1. Performance Optimization. 208
. 5.2. Indexes. 208
. 5.3. The Database Optimizer. 218
. 5.4. Caches. 226
. 5.5. Analysis Tools. 237
. 5.6. Performance with SAP NetWeaver AS. 263
. 5.7. Summary. 280
6. Problem Situations. 281
. 6.1. Diagnostic Files. 281
. 6.2. Error Types and Analysis. 293
. 6.3. Summary. 304
7. Summary and Outlook. 305
A. Command Reference dbmcli. 309
B. The Authors. 319
. 1.1. History. 11
. 1.2. SAP MaxDB Features. 12
. 1.3. Useful Internet Sources. 16
. 1.4. Structure of this Book. 18
2. Overview of SAP MaxDB. 21
. 2.1. SAP MaxDB -- Instance Types. 21
. 2.2. SAP MaxDB -- Software. 26
. 2.3. SAP MaxDB -- User Concept. 45
. 2.4. Database Concepts. 55
. 2.5. Summary. 87
3. SAP MaxDB and SAP. 89
. 3.1. SAP Architectures. 89
. 3.2. Communication with SAP MaxDB. 93
. 3.3. Important Transactions. 102
. 3.4. Summary. 114
4. Administration Tasks. 115
. 4.1. Server Software Installation and Upgrade. 115
. 4.2. Creating and Initializing the Database. 130
. 4.3. Configuring the Database. 146
. 4.4. Database Backup. 163
. 4.5. Database Recovery. 186
. 4.6. Consistency Checks. 196
. 4.7. Deleting the Database. 200
. 4.8. Summary. 206
5. Performance Tuning. 207
. 5.1. Performance Optimization. 208
. 5.2. Indexes. 208
. 5.3. The Database Optimizer. 218
. 5.4. Caches. 226
. 5.5. Analysis Tools. 237
. 5.6. Performance with SAP NetWeaver AS. 263
. 5.7. Summary. 280
6. Problem Situations. 281
. 6.1. Diagnostic Files. 281
. 6.2. Error Types and Analysis. 293
. 6.3. Summary. 304
7. Summary and Outlook. 305
A. Command Reference dbmcli. 309
B. The Authors. 319