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

Information about how to install a 32-bit Database Studio in a 64-bit environment.


  1. Preface
  2. Installation on Windows x64
  3. Installation on Linux x86_64

Preface

The native 64-bit versions of Database Studio are not available yet. To use Database Studio on 64-bit servers all the same, it is possible to install a 32-bit version of it. This document describes how to proceed to install the corresponding software package. This package is available for Windows x64 and Linux x86_64.

Please consider this as a beta solution and install the package on a dedicated server apart from the database instances. In addition to the installation of the Database Studio software it is required to install the 32-bit Java runtime of version 1.5.

As of Database Studio version 7.8 there will be also native 64-bit versions of Database Studio. So when using one of these versions it's not required to follow the approach described below.

back to top

Installation on Windows x64

Please follow the steps in the given order.

1) Download of the software package

Please choose https://www.sdn.sap.com/irj/scn/maxdb-downloads and scroll down to section "Special Database Studio packages for installation on 64-bit computer". In the table below please choose the link called "64 bit" in table row "Database Studio 7.7.06.09 for Windows". Please download the package to an empty folder and decompress (unzip) it.

2) Installation of this software package

Start the Installation Manager by choosing program SDBSETUP from the downloaded files. The Installation Manager will guide you through the installation which should be self-explanatory. By default Database Studio will be installed in directory:

C:\sdb\programs\DatabaseStudio

You will also find icons to start Database Studio and the Installation Manager after the installation:
Start > All Programs > MaxDB

3) Installation of the 32-bit Java runtime

Please go to internet site http://java.sun.com/javase/downloads/index.jsp. On the homepage you will find a tab called  Downloads  and there a link which is named  Previous Releases . Please choose  J2SE 5.0 Downloads  here. On the following page please scroll down to  Java Runtime Environment (JRE) 5.0 Update xx  (info) and choose  Download . Select platform  Windows  and confirm the license agreement. Now you can download file jre-1_5_0_xx-windows-i586-p.exe  (info) . Afterwards please execute this file. It will install the 32-bit Java runtime in this directory :

C:\Program Files (x86)\Java\jre1.5.0_xx (info)

(info) xx is a placeholder for the current number within the version

4) How to start 32-bit Database Studio

The 32-bit Database Studio can only work with the 32-bit Java runtime. For this reason it is essential to start Database Studio only with this Java runtime. This can be ensured by starting Database Studio from command line. Please change the current directory to

C:\sdb\programs\DatabaseStudio

and type

dbstudio.exe -vm "C:\Program Files (x86)\Java\jre1.5.0_xx\bin\java.exe"  (info)

It is recommended to create a separate icon for this or to edit the target of the existing one:

Start > All Programs > MaxDB > Database Studio

Call the properties of the icon and choose tab   Shortcut  . Here the target can be changed from calling   dbstudio.exe   without options to the above mentioned call.

The name of the icon should be changed accordingly to keep in mind what the icon is used for.

At the first start of Database Studio you will see the start screen from Eclipse. Please choose   Workspace   here. After the user management database has been created Database Studio can be used.

If you start the 32-bit Database Studio with the wrong Java runtime (e.g. a 64-bit version) an error will appear starting with "JVM terminated. Exit code=-1".

(info) xx is a placeholder for the current number within the version
back to top

Installation on Linux x86_64

Please follow the steps in the given order.

1) Download of the software package

Please choose https://www.sdn.sap.com/irj/scn/maxdb-downloads and scroll down to section "Special Database Studio packages for installation on 64-bit computer". In the table below please choose the link called "64 bit" in table row "Database Studio 7.7.06.09 for Linux". Please download the package to an empty folder and decompress (tar -xvf ...) it.

2) Installation of this software package

Start the Installation Manager by calling executable   SDBSETUP   from the downloaded files. The Installation Manager will guide you through the installation which should be self-explanatory. By default Database Studio will be installed in directory:

/opt/sdb/programs/DatabaseStudio

3) Installation of the 32-bit Java runtime

Please go to internet site http://java.sun.com/javase/downloads/index.jsp. On the homepage you will find a tab called   Downloads   and there a link which is named   Previous Releases  . Please choose   J2SE 5.0 Downloads   here. On the following page please scroll down to   Java Runtime Environment (JRE) 5.0 Update xx   (info) and choose   Download  . Select platform   Linux   and confirm the license agreement. Now you can download file jre-1_5_0_xx-linux-i586.bin   (info) . You have to add execution permission before you can install it. The installation can be started even if you are not user "root" into a folder of your choice.

Please have a look at the installation instructions for more information: http://java.sun.com/j2se/1.5.0/jre/install-linux.html

Do not choose the rpm file as this by default would replace the existing Java runtime.

(info) xx is a placeholder for the current number within the version
4) How to start 32-bit Database Studio
The 32 bit-Database Studio can only work with the 32-bit Java runtime. For this reason it is essential to start Database Studio only with this Java runtime. This can be ensured by starting Database Studio from command line. Please change the current directory to :
<user>@<server>:/opt/sdb/programs/DatabaseStudio>

and type

./dbstudio -vm "/<path to 32bit Java installation>/bin/java"

e.g.:

./dbstudio -vm "/opt/java32/jre1.5.0_xx/bin/java"   (info)

It is recommended to create a separate icon or script which guarantees that the above mentioned call is used. The name of the icon resp. script should be chosen accordingly to keep in mind what it is used for.

At the first start of Database Studio you will see the start screen from Eclipse. Please choose   Workspace   here. After the user management database has been created Database Studio can be used.

If you start the 32-bit Database Studio with the wrong Java runtime (e.g. a 64-bit version) an error will appear starting with "JVM terminated. Exit code=-1".

(info) xx is a placeholder for the current number within the version.

Issues and Resolutions

  1. Cannot logon
    • Issue: When testing your logon the error "Neither SQL nor DBM sessions are possible" is displayed.
    • Problem: Your user name or password are incorrect
    • How To Recreate: When creating the user a password length greater than 8 characters was used.
    • Resolution: When entering the password in the login screen, manually truncate the password to 8 characters.

back to top

Relevant links

Wiki page MaxDB tools

Relevant SAP Notes

3 Comments

  1. Guest

    Is the download functionality for database studio currently down?  I can't get any of the downloads to work; i'm getting a 403 web server message back.

  2. Right now the download is working. I don't get any error messages. Please try again.

  3. Guest

    The problem was you had to not be from germany to download the program.