SAP MaxDB HowTo

This is a loose collection of HowTo documents. They deal with various topics in using SAP MaxDB.

Setup / Configuration HowTo - Database Migration to SAP MaxDB This section gives information about how to proceed a database migration to the target database SAP MaxDB. HowTo - SAP ON UNIX AND SAP® MAXDB WITH NFS AND NETAPP STORAGE This document is intended to provide customers and partners with the best practices for deploying NetApp storage systems in support of SAP Business Suite solutions running in a UNIX or NFS environment using a MaxDB database. HowTo - Embed SAP MaxDB in MSCS This page provides information about how to embed SAP MaxDB into a Microsoft Cluster environment HowTo - MaxDB ODBC and unixODBC This section provides information about the unixODBC driver manager and the MaxDB ODBC driver. HowTo - Installation of a 32-bit Database Studio on a 64-bit server This section provides information about how to install a 32-bit Database Studio in a 64-bit environment. Backup / Recovery HowTo - SAP MaxDB backup with Database Manager CLI This section should help you to quickly create a data or log backup if no GUI tool (Database Manager GUI, Database Studio) is available. HowTo - SAP MaxDB recovery with Database Manager CLI This section should help you to quickly recover a database from an existing backup if no GUI tool (Database Manager GUI, Database Studio) is available. HowTo - Creating a clone of a SAP MaxDB database This section provides information about which options exist to create a clone of a SAP MaxDB database. HowTo - Standby DB log shipping This page provides information about how to setup a standby database with automatic log shipping for MaxDB, liveCache, OneDB, Content Server or any other database based on MaxDB HowTo - Backup and Restore a CE Database Using MaxDB Manager GUI This wiki describes the procedure for getting backups of our CAF database and using it to restore all the data and relationships when something goes wrong.

Performance Analysis HowTo - MaxDB Performance This section should help you to start a performance analysis of a SAP MaxDB OLTP-System. Here you will find all checks/information which have to be executed/collected to optimize the MaxDB instance. HowTo - MaxDB BW-Performance This section should help you to start a performance analysis of a BI-System with SAP MaxDB. Here you will find all checks which have to be executed to assure that the functionality of the BW Feature Pack has been activated correctly. Problem Anlaysis First Steps - SAP MaxDB Problem Analysis This page provides information about the first steps in a problem analysis related to SAP MaxDB. HowTo - New "knldiag" Message File Format in MaxDB 7.7 Get to know the new 'pseudo'-XML style knldiag format and the additional steps required in order to display it properly. HowTo - Check the File System Permissions for SAP MaxDB on UNIX & Linux This section explains how the permissions of SAP MaxDB files and directories should be set and how to correct them. HowTo - Analyze Connection Problems in DB50 and LC10 This page should help you to analyze connection problems from the SAP system to an SAP MaxDB database or SAP liveCache. Miscellaneous How To - Reverse Engineering MaxDB with Microsoft Visio This section provides information how to create a Database Model diagram of the existing MaxDB database in Microsoft Visio Professional 2007.