SAP MaxDB

The following documentation is a guide on how to administer SAP MaxDB. Some of the topics that I will be discussing have already been covered in my Oracle topic.

The site has been comprised of reading the following book and real world experience, if you are new to SAP MaxDB I highly recommend that you should purchase this book as it contains far more information than this web site contains and of course the Official SAP MaxDB web site contains all the documentation you will ever need.

Please feel free to email me any constructive criticism you have with the site as any additional knowledge or mistakes that I have made would be most welcomed.

MaxDB Introduction
  History
  Features
  Usage
  Downloads

MaxDB Overview
  OLTP and OLAP
  SAP LiveCache
  SAP MaxDB Tools
  MaxDB Users
  Database Architecture
  Tasks
  Load Balancing
  Main Caches
  File Directory
  Log Queues
  Catalog Cache, Shared SQL cache, Sequence cache
  Data Volumes
  Log Volumes
  Savepoints and Snapshots
  Locking
  Directory Structure
  Operational States
  Database Parameters

SAP MaxDB and SAP
  Introduction
  Communications
  MaxDB Interfaces

Administration Tasks
  Installation
  Creating and Initialising MaxDB Instance
  Configuring the Database
  Backups
  Recovery
  Snapshots
  Consistency checks

Performance Tuning
  Performance Tuning
  Indexes
  Database Optimizer
  Caches
  Analysis Tools - database analyzer, resource monitor, command monitor, EXPLAIN statement

TroubleShooting
  Diagnostic file locations
  x_cons
  xinstinfo

Links

  The official SAP MaxDB web site

Books

SAP MaxDB Books
SAP MAXDB Administration - Bögelsack, Gradl, Mayer, Krcmar Although this book is very light, for a beginner like me it was very useful. I think that this book should have been double the size and gone into more depth as there are so few MaxDB books available.