Starting Database Studio

Prerequisites

You have installed the Java runtime environment, version ≥ 5.
The installation-specific X server for your Database Studio installation is running. In normal operation, Database Studio automatically starts the corresponding X server. If the X server is not running, you can manually start it (see Starting the Global Listener and/or Installation-Specific X Servers).

Procedure

Depending on your system environment, you can start Database Studio either from your operating system menu or from the command line.

Caution

For the first start of Database Studio after you have installed the software, the following applies:

You are logged on as an operating system user of the Administrators group (Microsoft Windows) or as an operating system user with root privileges (Unix/Linux).
Navigate to the directory that contains the dbstudio[.exe] executable and start Database Studio from there from the command line.

Starting Database Studio from the Start Menu (Microsoft Windows)

Choose Start of the navigation path Start Next navigation step All Programs SAP MaxDB Database Studio End of the navigation path .

Starting Database Studio from the SAP Developer Studio

Start the SAP Developer Studio.
Choose Windows Open Perspective Other ...
Choose Database Studio.

Starting Database Studio from the Command Line

When starting Database Studio from the command line, you can specify call options.

Go to the directory that contains the dbstudio[.exe] file.
On the command line, enter the following command:

<database_studio_path>\dbstudio[.exe] [[[-l <landscape>] -n <database_computer>] -d <database> -u <DBS_login>,<user_password> [-a <action>]] [-ldf <landscape_definition_file>] [-vm <path_to_Java_VM>/javaw.exe] [-vmargs <VM_arguments>]

Call Option	Description
-l <landscape>	Landscape that is to be selected in the explorer tree after starting Database Studio
-n <database_computer>	Name or IP address of the database computer that is to be selected in the explorer tree after starting Database Studio
-d <database>	Database that is to be selected in the explorer tree after starting Database Studio
-u <DBS_login>,<user_password>	User login and password of the corresponding user that is to be selected in the explorer tree after starting Database Studio
-a <action> <action> ::= DBM\|SQL	DBM: Administration Editor is opened after starting Database Studio SQL: SQL Editor is opened after starting Database Studio For more information, see Database Studio Screen Areas.
-ldf <landscape_definition_file>	You import a database landscape from Database Manager GUI. In Database Studio's explorer, the imported landscape is displayed under the Imported Landscape node. Database Manager GUI stores its database landscape in the following file (landscape definition file): <user_home>\Application Data\sdb\DBM\Default.dbm
-OnlyRemote	Choose this option to prevent that the X server is automatically started when Database Studio is started.
-vm <path_to_Java_VM>/javaw.exe	The Java Virtual Machine that is located in the <path_to_Java_VM> is used instead of the default Java Virtual Machine.
-vmargs <VM_arguments>	Arguments that the Java Virtual Machine is to execute when starting Database Studio

Note

If you are using a central user management, and the central user management database is not available when starting Database Studio, a local user management database is used. To prevent this from happening, you have the following options:

Start Database Studio using the following command:

<database_studio_path>\dbstudio[.exe] -UMDBNode <UM_database_computer> -UMDBName <UM_database_name> -UMDBUserName <UM_user> -UMDBUserPassword <UM_user_password> -UMDBIdentity <UM_identity>
Specify the following parameter when starting Database Studio:

-NoAutoUMDB

Result

When you start Database Studio for the first time, the system sets up a local user and landscape management system on your computer and registers all SAP MaxDB databases that already exist on your computer.