Database Tools

Use

The MaxDB software includes a number of database tools.

For information on where to obtain MaxDB software and how to install it, see the Download section and the Installation Manual. SAP Solution Life Cycle Management (CCMS) is only available in SAP systems. For more information, see the respective Installation Guides.

Features

The following table shows you which database tools are used for which tasks:

Database Tools

Name

Task

Typical Users

Downward-
compatible

Database Analyzer (CLI)

Analyzing the performance of database instances (replaced the program XWIZARD)

Support employees

Database administrator

Yes

Database Manager:

Database Manager GUI

Database Manager CLI

Creating and managing database instances, DBM operators and database users

Database administrator

Yes, ? 7.2

Event Dispatcher

Manages events for automating administration tasks

Database administrator

No

Loader (CLI)

Exporting and importing data

Database administrator

Application developers

Yes, ? 7.3

SQL Studio:

SQL Studio (GUI)

SQLCLI

Web SQL Studio

Accessing data and the database catalog, SQL queries, creating and managing database objects and database users

Database users

Application developers

SQL Studio:
yes, ? 7.4.00

SQLCLI:
yes, ? 7.2

Synchronization Manager

Synchronizing table contents of two or more database instances.

Database users

No

VMAKE (CLI)

Development environment

Creating MaxDB software after modifying the source code.

Open source users who modify the MaxDB source code

No

XCONS (CLI)

Database console.
Displaying detailed information about the operating system resources occupied by the database system

Support employees

Database administrator

Yes

XUSER (CLI)

Creating and managing XUSER entries for simplified logon to database tools and interfaces with user keys

Support employees

Database administrator

Application developers

Yes

For SAP systems only:

Solution Life Cycle Management:

CCMS MaxDB (GUI)

CCMS SAP liveCache Technology (GUI)

Managing MaxDB and liveCache database instances in SAP systems

SAP administrator

Yes

Some of the database tools are available in multiple variants:

·        GUI: Graphical user interface
has to be installed locally, can only be used with Microsoft Windows

·        CLI: Command line
All functions are available, can be used for background processing and embedded in scripting languages (such as Python, Perl), can be used on all supported operating systems

·        Web: Web interface
Only the most important functions are available, is installed centrally, operated using a Web browser, platform-independent

Further development of the following web tools has been discontinued: Web DBM, Web Server, Web Server Manager. These web tools are only included in the MaxDB software package up to and including version 7.5. SAP customers can find more information in SAP Note 856940 (ordering web tools).

See also:

Technical System Landscape

Architecture of the Database Tools

Interfaces

X Server documentation