Sap Ase 16 / Sybase Ase Administration (Hardcover)

... 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