Database Studio

Database Studio is a database tool with which you can manage SAP MaxDB databases of version 7.5 and higher.

Note Note

From SAP MaxDB Version 7.7 onwards, Database Studio replaces the database tools Database Manager GUI and SQL Studio and also offers additional functions (such as a GUI for the Loader program).

End of the note.

You can use Database Studio on all operating systems supported by the database system. It is a component of the SAP MaxDB software. Database Studio runs on the Eclipse platform.

This Database Studio documentation is a reference manual for the functions of Database Studio. For a comprehensive description of administration tasks that a database administrator must carry out, use the Database Administration documentation. There are several ways of accessing functions in Database Studio. This description focusses how to access Database Studio's functions using the context menu.

Prerequisites

You have installed a Java runtime environment, version ≥ 5.
The global listener is running.
Database Studio automatically starts the global listener. You only need to manually start the global listener if it is has been stopped while you were working with Database Studio.

More information: Global Listener and X Servers, Starting the Global Listener and/or Installation-Specific X Servers
On Microsoft Windows, the operating system user who is working with Database Studio is a member of the special operating system user group SDB Operators.

Note
If you are the first operating system user to start Database Studio after the installation and you want to use local user management, on Microsoft Windows you also need to be a member of the Local Administrators group.

End of the note.

On Unix and Linux, the operating system user who is working with Database Studio is a member of the special operating system user group <sdba_group>.

More information: Database Administration, Special Operating System Users and Groups