Novice or expert, this is your one-stop shop for administering SAP HANA 2.0! You'll begin with a deep dive into database and engine architecture. Then explore your key tools: SAP HANA cockpit, SAP HANA Studio, the command-line interface, and more. From there, choose the topics you need. Backup and recovery? High availability? Data tiering? Security? Objects, tables, and transactions? All covered within these pages! From installation to performance tuning, this book has it all.Highlights include:1) Installation and updates 2) Architecture3) SAP HANA cockpit4) SAP HANA Studio5) Persistency6) High availability/disaster recovery7) Scale-out systems8) Data tiering9) Objects and tables10) Security11) Performance12) Monitoring

Configure backup, recovery, and high availability

... 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 ... 311 ... SAP HANA Overview ... 331.1 ... The Column Store ... 331.2 ... Hardware Requirements ... 361.3 ... Editions ... 371.4 ... Use Cases ... 401.5 ... Data Provisioning ... 461.6 ... Advanced Analytics ... 501.7 ... Data Integration ... 541.8 ... Summary ... 552 ... Architecture of the SAP HANA System ... 572.1 ... The Basics ... 572.2 ... Services and Processes ... 632.3 ... SAP HANA XSA Runtime Platform ... 672.4 ... Data Persistency ... 702.5 ... Multihost or Distributed SAP HANA Systems ... 712.6 ... High Availability ... 762.7 ... Backup and Recovery ... 782.8 ... Summary ... 803 ... Administration Tools ... 813.1 ... SAP HANA Cockpit ... 813.2 ... SAP HANA Studio ... 1033.3 ... Command-Line Tools ... 1133.4 ... DBA Cockpit for SAP HANA ... 1243.5 ... Additional Tools ... 1273.6 ... Summary ... 1284 ... Instance Administration ... 1314.1 ... Structure of an SAP HANA Instance ... 1324.2 ... Starting and Stopping the Instance ... 1454.3 ... Maintaining Parameters ... 1524.4 ... Managing Memory ... 1654.5 ... Sessions and Transactions ... 1764.6 ... Load Management and Distribution ... 1844.7 ... Special Utilities ... 2024.8 ... Managing Redo Logs ... 2054.9 ... Summary ... 2165 ... Database Administration ... 2175.1 ... Managing Tenant Databases ... 2185.2 ... Managing Data and Log Volumes ... 2315.3 ... Database Corruptions ... 2485.4 ... Backup and Recovery ... 2565.5 ... Landscape Management ... 3165.6 ... Network Configuration ... 3345.7 ... Summary ... 3396 ... System Replication ... 3416.1 ... Architecture ... 3436.2 ... Configuring and Monitoring System Replication ... 3656.3 ... Takeover and Failback ... 3816.4 ... Disable System Replication ... 3866.5 ... Multitier System Replication ... 3906.6 ... SAP HANA, Active/Active Read-Enabled Option ... 4066.7 ... Secondary Time Travel ... 4106.8 ... Zero-Downtime Maintenance with SAP Solutions ... 4146.9 ... Hardware Exchange via System Replication ... 4176.10 ... Summary ... 4187 ... Scale-Out Systems and High Availability ... 4197.1 ... Architecture ... 4197.2 ... Network Layout ... 4287.3 ... Host Autofailover ... 4337.4 ... Administration and Monitoring ... 4367.5 ... Configuration and Setup ... 4457.6 ... Takeover and Failback ... 4577.7 ... Summary ... 4648 ... Data Tiering ... 4658.1 ... Data Tiering Options ... 4668.2 ... Persistent Memory ... 4708.3 ... Native Storage Extensions ... 4768.4 ... SAP HANA Extension Node ... 4808.5 ... SAP HANA Dynamic Tiering ... 4848.6 ... Integration with SAP IQ ... 4898.7 ... Integration with Hadoop ... 4918.8 ... Summary ... 4939 ... Planning and Setting Up the SAP HANA Landscape ... 4959.1 ... Architecture ... 4959.2 ... Cloud Deployments ... 4969.3 ... On-Premise Deployments ... 4989.4 ... Capacity Planning ... 5199.5 ... Infrastructure Design ... 5369.6 ... Network Layout ... 5409.7 ... High-Availability Clusters ... 5479.8 ... Virtualization ... 5509.9 ... Operating System Platforms ... 5579.10 ... Reference Architecture ... 5579.11 ... Summary ... 56110 ... Installation and Updates ... 56310.1 ... Release Cycle of SAP HANA ... 56310.2 ... Preparing for Installation and Upgrades ... 56510.3 ... Using Lifecycle Management Tools ... 58810.4 ... Downloading the Software ... 59810.5 ... Installing an SAP HANA System ... 60010.6 ... Updating an SAP HANA System ... 62010.7 ... Uninstalling SAP HANA ... 63910.8 ... Installing and Updating the SAP HANA Client ... 64010.9 ... Installing and Updating the SAP HANA Cockpit ... 64410.10 ... Installing and Updating SAP HANA Studio ... 64810.11 ... Summary ... 65111 ... Database Objects ... 65311.1 ... Object Attributes ... 65411.2 ... Tables ... 65911.3 ... Indexes ... 66711.4 ... Triggers ... 66811.5 ... Constraints ... 66911.6 ... Views ... 67011.7 ... Sequences ... 67611.8 ... Stored Procedures ... 68011.9 ... Functions ... 68211.10 ... Synonyms ... 68611.11 ... Summary ... 68712 ... Working with Tables ... 68912.1 ... The Storage Models: Row and Column Stores ... 69112.2 ... Compression ... 69512.3 ... Delta Store and Delta Merge ... 70312.4 ... Partitioning ... 71112.5 ... Table Classification and Distribution ... 73412.6 ... Memory and Persistence Layer ... 74512.7 ... Special Table Types ... 74912.8 ... Indexes ... 76812.9 ... Multiversion Concurrency Control ... 77812.10 ... Export and Import ... 78112.11 ... Consistency Checks ... 79412.12 ... Metadata ... 79712.13 ... Summary ... 80513 ... Security ... 80713.1 ... Security Patches ... 80913.2 ... User Management ... 81013.3 ... Database Privileges ... 82613.4 ... Database Roles ... 84213.5 ... Troubleshooting Authorization Issues ... 84813.6 ... Authentication Methods ... 85413.7 ... Auditing the Database ... 86313.8 ... Encryption ... 87713.9 ... Increase the System Isolation Level ... 90213.10 ... Cross-Database Authorizations ... 90613.11 ... Summary ... 90914 ... Performance Analysis ... 91114.1 ... System Performance Monitoring ... 91214.2 ... SQL Statement Analysis ... 91714.3 ... Optimizer Statistics ... 94614.4 ... Summary ... 94815 ... Monitoring and Troubleshooting ... 94915.1 ... Monitoring Views ... 95015.2 ... Statistics Service Views ... 95315.3 ... Displaying System Views ... 95515.4 ... Diagnostic Files ... 95515.5 ... Alerts ... 96615.6 ... SAP's SQL Statement Collection ... 97815.7 ... Mini Checks ... 99115.8 ... SQL Trace ... 99415.9 ... Additional Traces ... 100215.10 ... Summary ... 1005A ... Setting Up Your Trial System ... 1009A.1 ... Install SAP HANA, Express Edition ... 1010A.2 ... Get SAP HANA with SAP Cloud Appliance Library ... 1013A.3 ... Summary ... 1021B ... References and Further Reading ... 1023B.1 ... Accessing the SAP Documentation ... 1023B.2 ... SAP Documentation and Manuals ... 1027B.3 ... SAP Product Support ... 1028B.4 ... Further Reading from SAP PRESS ... 1034C ... The Authors ... 1035... Index ... 1037