SAP MaxDB Installation on Windows and Linux

MaxDB

1.2. Linux
Requirements: glibc >= 2.3.3, gtk 2.x, X server (the root user must be able to access a display). Additionally, Linux i386 requires glibc with TLS (thread local storage) support.
1. Download the SAP MaxDB software package for your Linux platform.
2. Open a root shell.
3. Change to the directory that contains the SAP MaxDB package you have downloaded.
4. Unpack the SAP MaxDB package.
5. To start Installation Manager, enter ./SDBSETUP
6. Choose Start SAP MaxDB Installation.
7. Follow the instructions of Installation Manager.
8. After finishing the installation, exit the root shell.
9. Update the PATH environmental variable for the operating system user who is going to operate SAP MaxDB, for example using the following command:
export PATH=/opt/sdb/programs/bin:$PATH
10. If necessary, add it to the login profile of the operating system user as well (for example, .bash_profile in the user’s home directory).

 

2. Installing Database Studio

Database Studio is the SAP MaxDB GUI tool for managing databases. From SAP MaxDB version 7.7, Database Studio replaces the tools Database Manager GUI and SQL Studio, and also offers a GUI for the Loader tool. Database Studio can also be used for managing databases of versions 7.5 and 7.6.
Database Studio uses the Eclipse platform (Eclipse 3.2); the required Eclipse software is part of the Database Studio installation package. To use Database Studio, you also need Java version 1.5 or higher.

2.1. Microsoft Windows
1. Stop all databases. For example, use the Database Manager CLI command line tool to stop a database on the local computer:
dbmcli -d ‹database_name› -u ‹database_system_administrator›,‹password› db_offline
2. Stop the SAP MaxDB X server (communication server) by entering the following command on the command line:
x_server stop
3. Download the Database Studio software package for Microsoft Windows to a local directory.
4. Go to the directory that contains the software package you have downloaded.
5. Double-click it.
5. Follow the instructions of the Installation Manager.

2.2. Linux
1. Stop all databases. For example, use the Database Manager CLI command line tool to stop a database on the local computer:
/opt/sdb/programs/bin/dbmcli -d ‹database_name› -u ‹database_system_administrator›,‹password›
For the following steps, you need root privileges.
2. Stop the SAP MaxDB X server (communication server) by entering the following command on the command line:
/opt/sdb/programs/bin/x_server stop
3. Download the Database Studio software package for Linux to a local directory and extract it.
4. Go to the directory where you have extracted the software package.
5. Enter the following command:
‹directory_with_extracted_package›/SDBSETUP
6. Follow the instructions of the Installation Manager.

Note: Linux system environments vary greatly, meaning that you might have to install additional system software for Database Studio to run properly. If you are having trouble starting Database Studio, we recommend that you have a look at the posts in the SAP MaxDB forum (for example this one: Re: DatabaseStudio 7.8.01.10 on Linux doesn’t start).

Note: DatabaseStudio on Linux doesn’t start
It’s not actually SAP issue; relevant to Eclipse. Make sure that XULRUNNER package is installed.
Then append eclipse.ini as below :
-Dorg.eclipse.swt.browser.XULRunnerPath=/usr/lib/xulrunner/xulrunner
Please correct the path of “xulrunner” if different.

 

3. Uninstalling SAP MaxDB

To uninstall the SAP MaxDB software, including databases and tools, you also use SAP MaxDB Installation Manager.
1. Exit all SAP MaxDB programs.
2. On Linux only: open a root shell.
3. Change to the directory where you have extracted the SAP MaxDB Installer package.
4. To start Installation Manager, run SDBSETUP.
5. Choose Remove MaxDB components.
6. Follow the instructions.

maxdb-uninstall

Note: To uninstall the legacy tools Database Manager GUI and SQL Studio, use the standard Microsoft Windows Add and Remove Programs dialog window (Microsoft Windows only)

Author: