Show TOC

SAP MaxDBLocate this document in the navigation structure

Use

SAP → MaxDB™ is SAP's own database. It is 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 the basis for its reliability

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

  • SAP Business Suite

  • SAP Business ByDesign

  • SAP NetWeaver

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

Table 1: Installation and Upgrade Documentation (SAP MaxDB in SAP Systems)

Title of the Documentation

Description

Installation Guide:

SAP Systems Based on SAP NetWeaver <shipment> Application Server <application> on <operating_system>: SAP MaxDB

Only for SAP customers

You can find this guide on the SAP Service Marketplace at http://service.sap.com/instguidesInformation published on SAP site.Choose SAP NetWeaver and the relevant SAP NetWeaver release (for example SAP NetWeaver 7.3). Choose Installation. In the IT scenario Installation - SAP NetWeaver Systems open the SAP NetWeaver Installation Guides. The guides are sorted by databases, applications and operating systems.

Upgrade Guide:

SAP NetWeaver <shipment> For <application> <operating system> SAP MaxDB

Only for SAP customers

You can find this guide on the SAP Service Marketplace at http://service.sap.com/instguidesInformation published on SAP site. Choose SAP NetWeaver and the relevant SAP NetWeaver release (for example SAP NetWeaver 7.3). Choose Upgrade. In the IT scenario Upgrade - SAP NetWeaver Systems open the Upgrade Documentation - SAP NetWeaver. The guides are sorted by applications, operating systems and databases.

Table 2: 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, managing users, analyzing database performance, using SQL optimizer, searching for errors, developing database applications and further activities

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

Table 3: Tools Documentation

Title of the Documentation

Contents

Database Studio

Tool for managing and administrating SAP MaxDB databases

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.

Database Administration in CCMS: SAP MaxDB

For SAP systems only: Tools integrated in the Computing Centre Management System (CCMS) for analyzing a SAP MaxDB database, scheduling actions and monitoring the database functions and alerts

Database Manager CLI

Command line tool for database administration

Connecting Third-Party Backup Tools

Together with SAP MaxDB database tools, you can use third-party backup tools to backup, restore, export, and import data

Loader

Tool for exporting and importing data and table definitions

SQLCLI

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

Database Analyzer

Performance analysis tool for databases

Global Listener and X Servers

Communication servers of the SAP MaxDB database system

XUSER

Command line tool for storing user log-in data, which provides simplified logon to SAP MaxDB 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.

Table 4: Interface Documentation

Title of the Documentation

Content

Java Manual

Description of the SAP MaxDB JDBC driver and programming interfaces for Database Manager and Loader

Can be used 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. Can be used for developing database applications with Perl

Python Manual

Description of the programming interfaces for SQL. Can be used for developing database applications with Python

ADO.NET Interface

Description of the SAP MaxDB ADO.NET interface

Can be used 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

Table 5: Tutorials

Title of the Documentation

Contents

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

Table 6: 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.

Table 7: Alphabetical Index

Title of the Documentation

Contents

Glossary

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

More Information