Highlights:§§Database logging and recovery§Security§Auditing§Named caches§Remote procedure calls§SAP ASE connectivity§Resource Governor§High availability and disaster recovery§Remote server management§Memory configuration ... Acknowledgments ... 23§§... Preface ... 25§§... Introduction to SAP ASE System Administration ... 27§§1 ... Introduction to SAP ASE 16 ... 37§§1.1 ... Placement within the SAP Landscape ... 38§§1.2 ... Architecture Overview ... 38§§1.3 ... SAP ASE 16: Key Features ... 41§§1.4 ... SAP ASE Key Capabilities ... 50§§1.5 ... Summary ... 55§§2 ... Installation and Connectivity ... 57§§2.1 ... Preparation ... 58§§2.2 ... File Transfer ... 62§§2.3 ... Running Installation ... 62§§2.4 ... Installation Files ... 73§§2.5 ... Frontend Installation ... 82§§2.6 ... Starting the Server ... 83§§2.7 ... Shutting the Server Down ... 88§§2.8 ... Summary ... 90§§3 ... Defining Physical and SAP ASE-Mirrored Devices to the Server ... 91§§3.1 ... Creating and Dropping Devices ... 92§§3.2 ... SAP ASE Mirroring ... 103§§3.3 ... Volume Management ... 111§§3.4 ... Summary ... 121§§4 ... Defining Databases and Logs ... 123§§4.1 ... Database Structures ... 123§§4.2 ... System Databases ... 125§§4.3 ... Working with the Database ... 128§§4.4 ... System Tables ... 143§§4.5 ... Summary ... 147§§5 ... Database Logging and Recovery ... 149§§5.1 ... Transactions ... 149§§5.2 ... The Transaction Log ... 156§§5.3 ... Summary ... 169§§6 ... Security, User Administration, and Roles ... 171§§6.1 ... SAP ASE Security Levels ... 172§§6.2 ... Standard Roles ... 181§§6.3 ... Server Roles ... 188§§6.4 ... User-Defined Roles ... 191§§6.5 ... Login Activities ... 199§§6.6 ... Commands ... 202§§6.7 ... Object Permissions ... 207§§6.8 ... Access Rules ... 213§§6.9 ... Column Encryption ... 219§§6.10 ... Summary ... 227§§7 ... Auditing ... 229§§7.1 ... Installation Overview ... 230§§7.2 ... The sybsecurity Database and Tables ... 232§§7.3 ... Audit Storage ... 241§§7.4 ... Querying the Audit Trail ... 246§§7.5 ... External Applications and Third-Party Software ... 249§§7.6 ... Additional Tips on How to Effectively Audit ... 250§§7.7 ... Summary ... 250§§8 ... Backing Up and Restoring ... 251§§8.1 ... Roles and Responsibilities ... 252§§8.2 ... Backup Types ... 254§§8.3 ... Backup Server ... 256§§8.4 ... Dumping the Database ... 259§§8.5 ... Loading the Database ... 266§§8.6 ... Monitoring the Transaction Log ... 271§§8.7 ... Dumping Transactions ... 274§§8.8 ... Loading Transactions ... 277§§8.9 ... Restoring the Master Database ... 279§§8.10 ... Cumulative Dumps ... 282§§8.11 ... Dumping and Loading Across Platforms ... 283§§8.12 ... Quiesce Database ... 283§§8.13 ... Database Recovery Scenarios: Q&A ... 286§§8.14 ... Miscellaneous Topics ... 289§§8.15 ... Summary ... 290§§9 ... Resource Governor ... 291§§9.1 ... Enabling Resource Limits ... 292§§9.2 ... Time Ranges ... 293§§9.3 ... Creating a Limit ... 296§§9.4 ... Limit Hierarchies ... 300§§9.5 ... System Tables ... 302§§9.6 ... Summary ... 303§§10 ... Logical Process Manager ... 305§§10.1 ... Purpose of the Logical Process Manager ... 305§§10.2 ... Logical Process Manager Execution Classes ... 307§§10.3 ... Logical Process Manager Procedures ... 308§§10.4 ... Thread Pools and Engine Groups ... 313§§10.5 ... Logical Process Manager Conflicts and Precedence ... 317§§10.6 ... Summary ... 318§§11 ... Memory Configuration and Tuning ... 321§§11.1 ... SAP ASE Releases ... 321§§11.2 ... SAP ASE Configuration Basics ... 322§§11.3 ... Summary Table of Memory-Related Variables ... 359§§11.4 ... Recommended Configuration Settings ... 360§§11.5 ... Summary ... 364§§12 ... Data Cache ... 365§§12.1 ... Named Caches ... 365§§12.2 ... Buffer Pools ... 371§§12.3 ... Binding ... 376§§12.4 ... How to Tune Caches ... 379§§12.5 ... Summary ... 389§§13 ... Semantic Data Partitioning ... 391§§13.1 ... Why Use Data Partitioning? ... 392§§13.2 ... Types of Partitioning ... 396§§13.3 ... How and When to Use Data Partitioning ... 397§§13.4 ... Local ve