SAP MaxDB ToolsThis page gives an overview of the SAP MaxDB tools and detail information about the Database Console.
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.
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>
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
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.
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>.
dbmrelocate allows you to move/reassign database instances to an existing database software installation path.
You can also use the command line tool SQLCLI to execute SQL statements.
Possible options can be listed with
Possible commands can be listed in a SQLCLI session:
sqlcli -d <database_name> -u <database_user>,<password>
Example for the execution of an SQL statement:
sqlcli -d MYDB -u <sap_user>,<password> select * from <database_system_administrator>.messages
X_DIAGNOSE is a tool mostly used by developers to analyze e.g. the knldump or the database trace.
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.
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.