Show TOC

Background documentationSAP MaxDB Locate this document in the navigation structure

 

SAP® MaxDB™ is SAP’s own database specifically designed to provide lower total cost of ownership (TCO) for SAP applications. SAP solutions use SAP MaxDB to store both application logic and business data. The database is a central component of any SAP solution installation and provides basis for its reliability

SAP MaxDB is a robust and reliable technology, optimized to run all major SAP solutions:

  • SAP Business Suite

  • SAP Business All-in-One

  • SAP Business ByDesign

  • SAP NetWeaver

SAP MaxDB is based on database industry standards and can be used seamlessly for non-SAP applications as well.

Installation and Upgrade Documentation (SAP MaxDB in SAP Systems)

Title of the Documentation

Description

SAP NetWeaver 7.1 <shipment> on <operating_system>: SAP MaxDB

Only for SAP customers

Only in English

You can find this guide on the SAP Service Marketplace at http://service.sap.com/instguides.

For more information, see SAP Note 767598.

Upgrade to SAP MaxDB Database 7.7: <operating_system>

Only for SAP customers

Only in English

You can find this guide on the SAP Service Marketplace at http://service.sap.com/instguides.

For more information, see SAP Note 767598.

General SAP MaxDB Documentation

Title of the Documentation

Content

Database Administration

Tasks of a database administrator

Information about creating and configuring a database, monitoring, backing up and recovering data, exporting and importing data, user administration, synchronizing several databases, carrying out performance analyses, searching for errors, and developing database applications

SAP MaxDB Security Guide

Recommended security measures for the database system

Concepts of the Database System

Background information about the database system and the technical system landscape

Tools Documentation

Title of the Documentation

Contents

Database Studio

Tool for managing SAP MaxDB databases

Note Note

From database version 7.7, Database Studio replaces the database tools Database Manager GUI and SQL Studio, and it contains a GUI for the Loader database tool.

End of the note.

Database Administration in CCMS: SAP MaxDB

Using the SAP system to analyze and monitor a SAP MaxDB database, scheduling actions, alert monitoring

Database Manager CLI

Command line tool for database administration

Loader

Tool for exporting and importing data and table definitions

Web SQL Studio

Web based tool for displaying and changing data in a database using SQL statements

SQLCLI

Command line tool for displaying and changing data in a database using SQL statements

Database Analyzer

Performance analysis tool for databases

X Server

Communication server for the SAP MaxDB database system

XUSER

Command line tool for storing user log-in data, which provides simplified logon to databases

XCONS

Command line tool (database console) for viewing information about a SAP MaxDB database, such as operating system resources being used by the database system, distribution and status of the database sessions, etc.

Interface Documentation

Title of the Documentation

Content

Java Manual

Description of the SAP MaxDB JDBC Driver and programming interfaces for Database Manager and Loader for developing database applications with Java

ODBC Manual

Basics and special features of the SAP MaxDB ODBC driver

PHP Manual

Description of the SAP MaxDB PHP extension for developing database applications with PHP

Perl Manual

Description of the programming interfaces for SQL, Database Manager and Loader for developing database applications with Perl

Python Manual

Description of the programming interfaces for SQL, Database Manager and Loader for developing database applications with Python

ADO.NET Interface

Description of the SAP MaxDB ADO.NET interface for developing database applications with ADO.NET

WebDAV Servlet

Description of how to access a document store in a SAP MaxDB database using the SAP MaxDB WebDAV servlet

SQLDBC Manual

SQL database connectivity for developing applications and interfaces for SAP MaxDB

Tutorials

Title of the Documentation

Contents

Database Manager CLI Tutorial

Description of selected tasks for managing databases using the Database Manager CLI tool

SQL Tutorial

Examples for the Structured Query Language (SQL) used by the SAP MaxDB database system.

Loader Tutorial

Examples for commands of the Loader tool for exporting and importing data.

Reference Documentation

Title of the Documentation

Contents

SQL Reference Manual

SQL statements and their syntax, descriptions of system tables, special features of the SQL mode ORACLE

Messages

List of all messages in the database system: responses and error messages from the database kernel and the database tools. Includes short explanations of possible causes of errors, and tips for the user on how to react.

Alphabetical Index

Title of the Documentation

Contents

Glossary

Alphabetical list of terms used in the database system with links to further documentation

Important SAP Notes About SAP MaxDB

SAP Note Number

Title

767598

Available Documentation

826037

FAQ: MaxDB Support

820824

FAQ: MaxDB

1006496

Feature list liveCache / MaxDB 7.7

1007129

FAQ: DB Migration with MaxDB as the Target

846890

FAQ: MaxDB Administration

990602

FAQ: CCMS for MaxDB and liveCache

819641

FAQ: MaxDB Performance

928037

FAQ: MaxDB Indexes

832544

FAQ: MaxDB Hints

819324

FAQ: MaxDB SQL Optimization

927882

FAQ: MaxDB Update Statistics

822239

FAQ: MaxDB Interfaces

936058

FAQ: MaxDB Runtime Environment

129352

Homogenous System Copy with MaxDB (SAP DB)

952783

MaxDB High Availability

912905

Storage systems used with MaxDB

830468

Business Information Warehouse system with MaxDB

1040431

FAQ: BW Feature Pack

You can find further SAP Notes about SAP MaxDB in the component BC-DB-SDB.

More Information

SAP MaxDB web site at https://www.sdn.sap.com/irj/sdn/maxdb