---

Who says that a leopard can t change its spots? With the advent of SAP HANA, database administration is evolving and you can evolve along with it. Learn how traditional administration concepts are applied in SAP HANA, and find out about the new concepts relevant to an in-memory database. From the persistence layer to monitoring and root cause analysis, you ll get the background and practical examples you need to make your job easier. Whether you re an administration novice or a leopard trying to adapt to different surroundings, this book will help you sharpen your skills.
Highlights:

Architecture
Installation and updates
Administration tools
Persistence layer
Objects and tables
Sessions and transactions
Scaling out
Performance
Security
Monitoring and root cause analysis

---

Preface ... 17

1. Architecture of the SAP HANA Database ... 23

1.1 The Basics ... 23

1.2 The Physical View: SAP HANA Servers ... 26

1.3 The Operating System View: Database Processes ... 29

1.4 The Logical View: Internal Architecture of the Database ... 36

1.5 Distributed SAP HANA Systems ... 41

1.6 The Appliance Concept of SAP HANA ... 46

1.7 Release Cycles of SAP HANA Database Software ... 53

1.8 Summary ... 55

2. SAP HANA Scenarios: Administration Considerations ... 57

2.1 SAP HANA as a Database in Application Servers ... 58

2.2 SAP HANA as a Development Platform ... 64

2.3 Mixed Scenarios ... 68

2.4 Summary ... 73

3. Installation and Updates ... 75

3.1 Preparing for Installation and Updates ... 75

3.2 Tools for Installing and Updating SAP HANA Systems ... 85

3.3 Installing an SAP HANA Database ... 88

3.4 Updating an SAP HANA Database ... 101

3.5 Installing Multiple Instances of an SAP HANA Database on the Same Physical Server (Nonproduction) ... 110

3.6 Installation and Update in Batch Mode ... 111

3.7 Installing and Updating Scale-Out Systems ... 116

3.8 Troubleshooting ... 119

3.9 Summary ... 121

4. Administration Tools ... 123

4.1 Introduction to SAP HANA Studio ... 124

4.2 Database Administration with SAP HANA Studio ... 135

4.3 Monitoring the Database with SAP HANA Studio ... 144

4.4 DBA Cockpit for SAP HANA ... 153

4.5 Summary ... 156

5. The Persistence Layer ... 157

5.1 Log and Data Volumes: The Data Image on Disk ... 158

5.2 Log Backup ... 186

5.3 Snapshots ... 189

5.4 Data Backup and Recovery of the SAP HANA Database ... 199

5.5 Disaster Recovery Setups and System Replication ... 236

5.6 Summary ... 254

6. Scale-Out Systems and High Availability ... 255

6.1 Scaling Out SAP HANA Systems ... 256

6.2 High Availability with Host Autofailover ... 268

6.3 Client Connect in Distributed Systems ... 273

6.4 Summary ... 274

7. Objects ... 275

7.1 Common Properties of Database Objects ... 276

7.2 Tables ... 290

7.3 Triggers and Constraints ... 292

7.4 SQL Views ... 295

7.5 Column Views ... 302

7.6 Sequences ... 305

7.7 Procedures and Functions ... 312

7.8 Synonyms ... 313

7.9 Summary ... 315

8. Table Types ... 317

8.1 Common Properties of All Tables ... 318

8.2 Row Store Tables ... 319

8.3 Column Store Tables ... 324

8.4 Special Types of Tables ... 338

8.5 Summary ... 345

9. Working with Tables ... 347

9.1 Loading Tables to and from Memory ... 347

9.2 Running Delta Merges ... 356

9.3 Partitioning and Distributing Tables ... 365

9.4 Optimizing Table Distribution and Partitioning ... 381

9.5 Importing and Exporting Tables ... 395

9.6 Checking Tables for Consistency ... 409

9.7 Summary ... 411

10. Sessions and Transactions ... 413

10.1 Introduction to Sessions and Transactions ... 413

10.2 Processes and Threads ... 428

10.3 Monitoring Sessions and Transactions ... 445

10.4 Concurrency and Parallelism ... 451

10.5 Summary ... 465

11. Working with the Repository ... 467

11.1 Properties of the SAP HANA Repository ... 467

11.2 Creating and Editing Objects in SAP HANA Studio ... 477

11.3 Deleting Development Objects in SAP HANA Studio ... 486

11.4 Mechanisms for Exporting and Importing Objects ... 488

11.5 Change Recording and Transports ... 491

11.6 Summary ... 494

12. User Management and Security ... 497

12.1 Essential Security-Related Concepts ... 498

12.2 Database Users ... 498

12.3 Authentication Methods ... 516

12.4 Securing SAP HANA´s Network Interfaces ... 525

12.5 Auditing in the Database ... 534

12.6 Summary ... 541

13. Roles and Privileges ... 543

13.1 Database Roles ... 543

13.2 Privileges in the Database Catalog and Repository ... 553

13.3 Types of Privileges in SAP HANA ... 560

13.4 Critical Privileges and Privilege Combinations ... 570

13.5 Standar

---