Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

SAP MaxDB Tools

This page gives an overview of the SAP MaxDB tools and detail information about the Database Console.

SAP MaxDB CCMS
Database Studio
DBMGETF
dbmrelocate
SQLCLI
Database console program (x_cons)
X_DIAGNOSE
Database Manager (only SAP MaxDB version < 7.8)
SQL Studio (only SAP MaxDB version < 7.8)


Database Studio

SAP Database Studio is SAP's tool for managing SAP MaxDB databases.

Database Studio is available in the SAP Service Marketplace. The installation is described in note 1097311.

With Database Studio, you can create and configure databases, define database objects (data model), monitor databases, backup and restore databases, import and export data, manage users, synchronise several databases, analyse the performance of a database, and manage database landscapes. You can use graphical user interface for the Loader tool and WebDAV repositories to store SQL statements and database object definitions. As of SAP MaxDB version 7.7, Database Studio replaces the Database Manager GUI, SQL Studio and Synchronization Manager tools.

Database Studio 7.9 News
Problems when Database Studio is launched
Use of the Java runtime environment for SAP MaxDB Database Studio

back to top

Executing SQL statements using DBMCLI

You can execute SQL statements using Database Manager CLI (DBMCLI). Therefore you need to authorize against the DBM server (option -u) and you have to create a SQL session (option -uSQL):
dbmcli -d <database_name> -u <dbm_operator>,<password> -uSQL <database_user>,<password>

Example:
dbmcli -d MYDB -u dbmuser,dbmpw -uSQL sapuser,pw

Afterwards you can use command sql_execute to execute the SQL statement:
sql_execute select * from messages

back to top

Executing DBM Server commands in the SAP system

Using DBA Cockpit (transaction DBACOCKPIT) or Database Assistent (transaction DB50) or liveCache Assistent (transaction  LC10) you can execute DBM commands very comfortable. You don't need to specify database name, user and password to authorize against the DBM server, since the central authorization is used. Choose menu Tools -> Database Manager (CLI) and enter any DBM command. To execute these commands, DBMRFC is used.

back to top

DBMGETF

Using DBMGETF you can view SAP MaxDB log files. This tool can e.g. be called from transaction SM49.
Using the following command gets you a list of all files which can be viewed:
dbmgetf -d <database_name> -u <dbm_operator>,<password> -l

Using this command you can view a specific file:
dbmgetf -d <database_name> -u <dbm_operator>,<password> -k <file_ID>

<file_ID> is the identifier which is listed with option -l.
If you won't run DBMGETF on the database server, you have to specify this server with option -n <database_computer>.

back to top

dbmrelocate

dbmrelocate allows you to move/reassign database instances to an existing database software installation path.

back to top

SQLCLI

You can also use the command line tool SQLCLI to execute SQL statements.
Possible options can be listed with
sqlcli -h

Possible commands can be listed in a SQLCLI session:
sqlcli -d <database_name> -u <database_user>,<password>
===>\h

Example for the execution of an SQL statement:
sqlcli -d MYDB -u <sap_user>,<password> select * from <database_system_administrator>.messages

back to top

X_DIAGNOSE

X_DIAGNOSE is a tool mostly used by developers to analyze e.g. the knldump or the database trace.

back to top

Database Manager

The Database Manager (only database version < 7.8) is the administration tool of SAP MaxDB. It is divided into a server (DBM Server) and several clients (DBMGUI, DBMCLI, DBMRFC). You connect to one of the clients which then establishes a connection to the DBM Server and to the database. DBMGUI is the graphical user interface, which can only be installed on Windows machines. However, you can administer databases remotely - these databases can also run on UNIX or LINUX machines. DBMGUI is available in the SAP Service Marketplace. The installation is described in note 386714. DBMCLI is the command line interface of the Database Manager. A web interface is also available. You can request to get this client as described in note 856940. Using the NI connection (SAP DB connection) the SAP MaxDB support team can logon to your database using DBMGUI. This connection is described in note 202344.

back to top

SQL Studio

SQL Studio is a SAP MaxDB query tool (only database version < 7.8). It is a graphical user interface, which can only be installed on Microsoft Windows machines. However, you can connect to remote databases - these databases can also run on Unix or Linux machines. SQL Studio is available in the SAP Service Marketplace. The installation is described in note 386714.

A web interface is also available for version 7.5. You can request to get this client as described in note 856940. Using the NI connection (SAP DB connection) the SAP MaxDB support team can connect to your database instance using SQL Studio. This connection is described in note 202344.

back to top

Relevant SAP Notes

1097311 Database Studio Installation
202344 Setting up SAP DB connection
856940 Ordering SAP MaxDB Web Tools
386714 SQL Studio + Database Manager GUI installation