SAP MaxDB FAQ Notes

SAP MaxDB FAQ Notes

This page contains the links to the available SAP MaxDB/liveCache FAQ Notes.
----

Note 1007129 FAQ DB Migration with MaxDB as the Target

Note 1007129 (SMP Login required) is aimed at SAP sales colleagues, consultants and customers who are considering a database migration to the SAP database system MaxDB. This note provides additional information to customers who have recently migrated to MaxDB. The information covers services provided,
training courses and so on.

back to top

Note 820824 FAQ MaxDB/liveCache Technology

Note 820824 (SMP Login required) contains questions about MaxDB and liveCache that are frequently asked by SAP employees and customers. It provides answers and refers you to other information
sources.

back to top

Note 826037 FAQ MaxDB/liveCache Support

Note 826037 (SMP Login required) contains questions about MaxDB and liveCache Support organisation.

back to top

Note 1173395 FAQ MaxDB/liveCache Configuration

Note 1173395 (SMP Login required) contains questions about MaxDB and liveCache configuration.

back to top

Note 767598 SAP MaxDB Documentation

Note 767598 explains where to find the SAP MaxDB documentation.

back to top

Note 1830959 SAP MaxDB/livecache Housekeeping

Note 1830959 contains SAP recommendations for SAP MaxDB/liveCache housekeeping jobs.

back to top

Note 1020175 FAQ MaxDB Installation and Upgrade

Note 1020175 (SMP Login required) provides answers to the most frequently asked questions about MaxDB Installation and Upgrade.

back to top

Note 912905 FAQ Storage systems used with MaxDB

Note 912905 (SMP Login required) provides answers to the most frequently asked questions about Storage systems used with MaxDB.

back to top

Note 846890 FAQ MaxDB Administration

Note 846890 (SMP Login required) provides answers to the most frequently asked questions about MaxDB Administration.
back to top

Note 1377148 FAQ MaxDB Backup/Recovery

Note 1377148 (SMP Login required) provides answers to the most frequently asked questions about MaxDB Backup and Recovery.
back to top

Note 1139904 FAQ MaxDB Kernel Parameter

Note 1139904 (SMP Login required) provides answers to the most frequently asked questions about MaxDB Kernel Parameter.
back to top

Note 927882 FAQ MaxDB Update Statistics

Note 927882 (SMP Login required) provides answers to the most frequently asked questions about MaxDB Optimizer Statistics.

back to top

Note 822240 FAQ MaxDB and External Backup Tools

Note 822240 (Smp Login Required] is a collection of the questions that are often asked by colleagues and customers regarding external backup tools. It provides answers and refers you to other information sources. The note is in no
way complete.

back to top

Note 990602 FAQ CCMS for SAP MaxDB/liveCache Technology

Note 990602 (SMP Login required) is a collection of the questions that are often asked by colleagues and customers regarding MaxDB/liveCache CCMS. It provides answers and refers you to other information sources.

back to top

Note 940420 FAQ Database Structure Check (VERIFY)

Note 940420 (SMP Login required) deals with questions and answers on the subject of the MaxDB/liveCache database structure check (VERIFY). The Database
Verify is also designated as CHECK data or CHECK TABLE. The note is both for the customer and support, to answer queries on the topic of a database structure check in a MaxDB/liveCache database.

back to top

Note 839333 FAQ MaxDB Error Diagnosis - Corrupt Data Pages

A serious error such as -9026 Bad Data Page, -9028 Bad File or the error Page_in_Wrong_tree occurred in a MaxDB database. An analysis must be performed using the x_diagnose. Note 839333 (SMP Login required) should be used by MaxDB support to analyze serious errors. This note can be used as of Version 7.3 to run analyses in the OLPT/BW and liveCache environment.

back to top

Note 869267 FAQ MaxDB Log Area

Note 869267 (SMP Login required) contains questions about the MaxDB log area that are frequently asked by SAP staff and customers.

back to top

Note 837385 FAQ MaxDB Database Trace (VTRACE)

Note 837385 (SMP Login required) consists of questions and answers about the MaxDB/liveCache database trace. The database trace is also referred to as the kernel trace or VTRACE. This note is intended to help customers and the Support
team with troubleshooting MaxDB/liveCache kernel errors.

back to top

Note 1464618 FAQ SAP MaxDB Database Studio

Note 1464618 (SMP Login required) refers to questions regarding MaxDB Database Studio to provide additional information about this new integrated administration and SQL query tool.

back to top

Note 1111426 Parameter Check for liveCache and SAP MaxDB Databases

Note 1111426 (SMP Login required) explains how to use the parameter check file provided for download in the SAP MaxDB download area. You can use this file to check automatically whether the configuration of your liveCache/MaxDB/OneDB (OLTP/BW) database corresponds to the current SAP recommendations.

back to top

Note 1014782 FAQ MaxDB System Copy

Note 1014782 (SMP Login required) consists of questions and answers about the methods of MaxDB/liveCache system copy.

back to top

Note 819641 FAQ MaxDB Performance

Note 819641 (SMP Login required) is a collection of questions and answer which should help to analye and solve performance problems.

back to top

Note 1423935 FAQ SAP MaxDB Database Analyzer

Note 1423935 (SMP Login required) is a collection of questions and answer which should help to use the database Analyzer to find database bottlenecks and to solve general database performance problems.

back to top

Note 928037 FAQ MaxDB Indexes

The note 928037 (SMP Login required] This note consists of questions and answers about indexes in MaxDB/liveCache /content server/SAP DB databases.
General and frequent questions about indexes are answered.
back to top

Note 832544 FAQ MaxDB Hints

The MaxDB documentation does not contain any information about MaxDB hints. Note 832544 (SMP Login required) tries to answer questions about MaxDB hints.

back to top

Note 819324 FAQ MaxDB SQL Optimization

Note 819324 (SMP Login required) should help to analyze and solve SQL performance problems.

back to top

Note 1603165 FAQ SAP MaxDB Command Monitor

Note 1603165 (SMP Login required) should help to analyze and solve SQL performance problems with the Command Monitor tool.

back to top

Note 1691121 FAQ SAP MaxDB Resource Monitor

Note 1691121 (SMP Login required) should help to analyze SQL workload with the Resource Monitor tool.

Note 1243937 FAQ MaxDB SQL Locking

Note 1243937 (SMP Login required) gives information about MaxDB SQL locking, Isolation Level and more.

back to top

Note 1264776 FAQ MaxDB Clustered Tables (OLTP)

Note 1264776 (SMP Login required) shows how to use table clustering in OLTP scenarios and answers common questions.

back to top

Note 1368477 FAQ MaxDB Queryrewrite

Note 1368477 (SMP Login required) gives information about the MaxDB QUERYREWRITE functionality. This information can be important for performance analysis on SQL statement level.

Note 1497862 FAQ MaxDB Shared SQL

Note 1497862 (SMP Login required) provides explanation and information about the MaxDB Shared SQL functionality.

back to top

Note 1327874 FAQ SAP MaxDB Read Ahead/Prefetch

Note 1327874 (SMP Login required) provides you with the new 'Prefetch' or 'Read Ahead' function so that
you can accelerate read operations from the hard disk. This note
explains the advantages and areas of operation of the Read Ahead
mechanism.

back to top

Note 830468 FAQ Business Information Warehouse System with MaxDB

Note 830468 (SMP Login required) contains questions frequently asked by colleagues and customers about SAP Business Information Warehouse (BW) with MaxDB. It contains the relevant answers and also refers to other sources of
information. This note is mainly intended to provide help in analyzing the
performance of MaxDB BW systems.

back to top

Note 1040431 FAQ MaxDB BW-Feature Pack

With MaxDB version 7.6.01 the BW Feature Pack will be available for customers. FAQ Note 1040431 (SMP Login required) will answers questions about the BW Feature Pack.

back to top

Note 912905 FAQ Storage Systems Used with MaxDB

Note 912905 (SMP Login required) tries to answers questions about using storage systems with a MaxDB database. In particular, this note should clarify questions about what you need to consider when you use volumes on storage systems, if this is possible in terms of the database.

back to top

Note 822239 FAQ MaxDB Interfaces

Note 822239 (SMPLogin required) contains questions about MaxDB interfaces.

back to top

Note 936058 FAQ MaxDB Runtime Environment

Note 936058 (SMP Login required) is intended for MaxDB experts. It provides an overview of questions and answers on the topic 'MaxDB Runtime Environment', and refers to sources of information. The note refers in general to MaxDB, but can similarly be applied to liveCache instances.

back to top

Note 1128916 FAQ MaxDB/liveCache Heap Management

Note 1128916 (SMP Login required) is intended for MaxDB experts. It provides an overview of questions and answers on the topic 'MaxDB/liveCache Heap Management', and refers to sources of information. The note refers in general to MaxDB and liveCache, but can similarly be applied to MaxDB BI and Content Server instances.

back to top

Note 1247666 FAQ MaxDB/liveCache History Pages

Note 1247666 (SMP Login required) is intended for MaxDB/liveCache experts. It provides an overview of questions and answers on the topic 'MaxDB/liveCache History Pages'.

back to top

Note 1423732 FAQ MaxDB Snapshots

Note 1423732 (SMP Login required) provides answers to the most frequently asked questions about MaxDB Snapshots.

back to top

Note 952783 FAQ MaxDB High Availability

Note 952783 (SMP Login required) deals with questions and answers on the subject of the MaxDB/liveCache high availability. It describes options on database level. High availability concepts of the hardware and the operating
systems are not a subject of this note.

back to top

Note 822271 FAQ MaxDB Client Software

Note 822271 (SMP Login required) deals with questions and answers on the subject of the MaxDB Client software which has to be installed on SAP application servers.

back to top

Note 1038709 FAQ SAP liveCache OneDB

Note 1038709 (SMP Login required) deals with questions and answers on the subject of the SAP liveCache OneDB.

back to top

Note 1694323 FAQ MaxDB Remote SQL Server and DBMServer

Note 1694323 (SMP Login required) deals with questions and answers on the subject of the SAP MaxDB Remote SQL Server and DBMServer.

back to top