SAP HANA 2.0 Administration (Hardcover)

... Preface ... 23

... So You Want to Be an SAP HANA Database Administrator? ... 24

... The SAP HANA Landscape Used for This Book ... 26

... Management Tools ... 27

... Who Is This Book For? ... 28

... How Is This Book Organized? ... 28

... Acknowledgements ... 31

1 ... SAP HANA Overview ... 33

1.1 ... The Column Store ... 33

1.2 ... Hardware Requirements ... 36

1.3 ... Editions ... 37

1.4 ... Use Cases ... 40

1.5 ... Data Provisioning ... 46

1.6 ... Advanced Analytics ... 50

1.7 ... Data Integration ... 54

1.8 ... Summary ... 55

2 ... Architecture of the SAP HANA System ... 57

2.1 ... The Basics ... 57

2.2 ... Services and Processes ... 63

2.3 ... SAP HANA XSA Runtime Platform ... 67

2.4 ... Data Persistency ... 70

2.5 ... Multihost or Distributed SAP HANA Systems ... 71

2.6 ... High Availability ... 76

2.7 ... Backup and Recovery ... 78

2.8 ... Summary ... 80

3 ... Administration Tools ... 81

3.1 ... SAP HANA Cockpit ... 81

3.2 ... SAP HANA Studio ... 103

3.3 ... Command-Line Tools ... 113

3.4 ... DBA Cockpit for SAP HANA ... 124

3.5 ... Additional Tools ... 127

3.6 ... Summary ... 128

4 ... Instance Administration ... 131

4.1 ... Structure of an SAP HANA Instance ... 132

4.2 ... Starting and Stopping the Instance ... 145

4.3 ... Maintaining Parameters ... 152

4.4 ... Managing Memory ... 165

4.5 ... Sessions and Transactions ... 176

4.6 ... Load Management and Distribution ... 184

4.7 ... Special Utilities ... 202

4.8 ... Managing Redo Logs ... 205

4.9 ... Summary ... 216

5 ... Database Administration ... 217

5.1 ... Managing Tenant Databases ... 218

5.2 ... Managing Data and Log Volumes ... 231

5.3 ... Database Corruptions ... 248

5.4 ... Backup and Recovery ... 256

5.5 ... Landscape Management ... 316

5.6 ... Network Configuration ... 334

5.7 ... Summary ... 339

6 ... System Replication ... 341

6.1 ... Architecture ... 343

6.2 ... Configuring and Monitoring System Replication ... 365

6.3 ... Takeover and Failback ... 381

6.4 ... Disable System Replication ... 386

6.5 ... Multitier System Replication ... 390

6.6 ... SAP HANA, Active/Active Read-Enabled Option ... 406

6.7 ... Secondary Time Travel ... 410

6.8 ... Zero-Downtime Maintenance with SAP Solutions ... 414

6.9 ... Hardware Exchange via System Replication ... 417

6.10 ... Summary ... 418