sap in-memory database - server installation and update guide

SAP In-Memory Database - Server Installation and Update Guide■ SAP In-Memory Appliance (SAP HANA) 1.0

2011-06-17

© 2011 SAP AG. All rights reserved.SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAPBusinessObjects Explorer, StreamWork, and other SAP products and services mentioned herein as

Copyright

well as their respective logos are trademarks or registered trademarks of SAP AG in Germany andother countries.Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports,Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and servicesmentioned herein as well as their respective logos are trademarks or registered trademarks of BusinessObjects Software Ltd. Business Objects is an SAP company.Sybase and Adaptive Server, iAnywhere,Sybase 365, SQL Anywhere, and other Sybase products and services mentioned herein as well astheir respective logos are trademarks or registered trademarks of Sybase, Inc. Sybase is an SAPcompany. All other product and service names mentioned are the trademarks of their respectivecompanies. Data contained in this document serves informational purposes only. National productspecifications may vary.These materials are subject to change without notice. These materials areprovided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only,without representation or warranty of any kind, and SAP Group shall not be liable for errors oromissions with respect to the materials. The only warranties for SAP Group products and servicesare those that are set forth in the express warranty statements accompanying such products andservices, if any. Nothing herein should be construed as constituting an additional warranty.

2011-06-17

Contents

About this Document..............................................................................................................5Chapter 1

SAP HANA Guides..................................................................................................................7Chapter 2

System Requirements.............................................................................................................9Chapter 3

Supported Platforms.............................................................................................................11Chapter 4

Concepts...............................................................................................................................13Chapter 5

System..................................................................................................................................135.1Distributed System................................................................................................................135.2Instance.................................................................................................................................155.3Instance Number....................................................................................................................155.4Host.......................................................................................................................................155.5System Administrator: <sid>adm User...................................................................................155.6System Manager....................................................................................................................165.7

General Installation Information............................................................................................17Chapter 6

Programs...............................................................................................................................176.1Installation Planning................................................................................................................176.2Default Values.......................................................................................................................186.2.1Logging..................................................................................................................................196.3Displaying Information about Installed Software.....................................................................206.4

Installing or Updating the SAP In-Memory Database...........................................................21Chapter 7

Pre-Installation Steps.............................................................................................................217.1Installing or Updating Using the Installation Manager..............................................................227.2Installing or Updating Using the Command Line.....................................................................227.3Installation Methods Using the Command Line.......................................................................237.3.1Update Methods Using the Command Line............................................................................277.3.2

2011-06-173

Adding a Host to the System.................................................................................................31Chapter 8

Adding a Host in Interactive Mode..........................................................................................318.1Adding a Host in Batch Mode.................................................................................................328.2Call Options for the hdbaddhost Program..............................................................................328.3

Renaming an IMDB System..................................................................................................35Chapter 9

Call Options for the hdbrename Program...............................................................................359.1

Uninstalling the Software......................................................................................................39Chapter 10

Uninstalling the Software in Interactive Mode.........................................................................3910.1Uninstalling the Software in Batch Mode................................................................................4010.2Removing a Host....................................................................................................................4010.3Call Options for the hdbuninst Program..................................................................................4110.4

More Information...................................................................................................................43Appendix A

2011-06-174

Contents

About this Document

This document describes all available procedures to install, update, and uninstall a single-host systemusing a graphical user interface or in the command line in interactive or in batch mode. It also describeshow to create a distributed system and remove hosts from a distributed system.

To install a SAP In-Memory Database for SAP In-Memory Appliance (SAP HANA) 1.0, we recommendthat you use the Installation Manager (hdbsetup program). It provides a graphical user interface thatyou can use to easily and quickly install a running SAP In-Memory Database.

For more information about SAP HANA, see the SAP HANA Master Guide.

2011-06-175

About this Document

https://service.sap.com/~sapidb/011000358700000604552011D

2011-06-176

About this Document

SAP HANA Guides

For more information about SAP HANA landscape, security, installation, and administration, see theresources listed in the table below.

Table 2-1:

Quick LinkLocationTopic

https://service.sap.com/hana :

• SAP HANA 1.0 Master Guide• SAP HANA 1.0 Installation Guide

SAP HANA KnowledgeCenter on SAP ServiceMarketplace

SAP HANA landscape,deployment, and instal-lation

http://help.sap.com/hana :

• SAP HANA 1.0 Technical OperationsManual

• SAP HANA 1.0 Security Guide

SAP HANA KnowledgeCenter on SAP Help Portal

SAP HANA administra-tion and security

2011-06-177

SAP HANA Guides

https://service.sap.com/hana

https://service.sap.com/~sapidb/011000358700000604552011

https://service.sap.com/~sapidb/011000358700000604562011

http://help.sap.com/hana

2011-06-178

SAP HANA Guides

System Requirements

SAP In-Memory Appliance (SAP HANA) 1.0 is based on Linux SUSE SLES 11 SP1/ x86-64.

2011-06-179

System Requirements

2011-06-1710

System Requirements

Supported Platforms

For SAP In-Memory Appliance (SAP HANA) 1.0, the server software for the SAP In-Memory Databaseis only available on SUSE Linux Enterprise Server x86-64.

2011-06-1711

Supported Platforms

2011-06-1712

Supported Platforms

Concepts

5.1 System

System is the name for one or more instances of a SAP In-Memory Database on one or more hoststhat use the same server software installation:• If there is only one instance, it is called a single-host system.

• If there are multiple connected instances, it is called a distributed system.

Every system has a unique system ID, <SID>.

Note:Choose your SAP system ID carefully because you cannot change it after the installation.

Make sure that your SAP system ID:• Is unique throughout your organization. Do not use an existing <SID> when installing a new SAP

system.• Consists of exactly three alphanumeric characters• Contains only uppercase letters• Has a letter for the first character• Does not include any of the following, which are reserved IDs:

ADD ALL AMD AND ANY ARE ASC AUX AVG BIT CDC COM CON DBA END EPS FOR GET GIDIBM INT KEY LOG LPT MAP MAX MIN MON NIX NOT NUL OFF OLD OMS OUT PAD PRN RAWREF ROW SAP SET SGA SHG SID SQL SUM SYS TMP TOP UID USE USR VAR

5.2 Distributed System

The server software is based on a flexible architecture that enables a distributed installation. This meansthat load can be balanced between different hosts. If you want to create a distributed system, makesure that you set it up in a safe environment.

The server software has to be installed in a file system where all hosts that are part of the system canbe mounted. You use the hdbsetup or hdbinst program for the installation. You can then use thehdbaddhost program to add more hosts to the master instance.

2011-06-1713

Concepts

The following graphic shows the file system for a distributed installation:

The following table shows a typical configuration for a distributed system:

Index Server

Actual Role

Index Server

Configured Role

Name Server

Actual Role

Name Server

Configured Role

MasterWorkerMasterMaster 1

SlaveWorkerSlaveMaster 2

SlaveWorkerSlaveMaster 3

SlaveWorkerSlaveSlave




2011-06-1714

Concepts

Index Server

Actual Role

Index Server

Configured Role

Name Server

Actual Role

Name Server

Configured Role

StandbyStandbySlaveSlave

5.3 Instance

An instance is an administrative unit that comprises the server software components. It is started andstopped as a unit.

5.4 Instance Number

An instance is defined by an instance number. This is a two-digit identifier that is unique on a host.Therefore, an instance number can only be assigned once on a host.

Since all instances of a system have the same instance number, only instances of different systemscan be configured on the same host.

5.5 Host

Host is the server or blade on which you create an individual instance of a system.

For more information about the restrictions that apply to host names in SAP systems, see SAP Note611361 Hostnames of SAP servers.

5.6 System Administrator: <sid>adm User

The system administrator, <sid>adm, is the operating system user that is needed for administrativetasks such as starting and stopping the system.

2011-06-1715

Concepts

http://service.sap.com/sap/support/notes/611361

The user ID and password of the <sid>adm user are defined when installing the software and creatingthe system. The user ID and group ID of this operating system user must be unique and identical oneach host of a distributed system.

5.7 System Manager

The SYSTEM user is an engine user, which is created during the installation. The installation programprompts you to specify a password for this user.

Initially, the SYSTEM user has all system permissions. Additional permissions can be granted to thisuser or revoked. However, only those permissions can be revoked that were granted additionally to theinitial permissions.

2011-06-1716

Concepts

General Installation Information

6.1 Programs

For server installation purposes, use the following programs:

Runnable in Batch ModeDescriptionProgram Name

NoInstallation tool with graphicalinterface for installing or updat-ing the software

hdbsetup

YesCommand-line tool for installingthe softwarehdbinst

YesCommand-line tool for adding ahost to a systemhdbaddhost

YesCommand-line tool for updatingthe softwarehdbupd

YesCommand-line tool for unin-stalling the software and remov-ing a host

hdbuninst

YesCommand-line tool for renaminga systemhdbrename

6.2 Installation Planning

2011-06-1717


Plan your installation before starting the installation program.

If you plan to create a distributed system, make sure that you meet the following prerequisites:1. The user ID to be assigned to <sid>adm can be used on all hosts that you plan to use for the

distributed system.2. The group ID of <sid>adm can be used on all hosts that you plan to use for the distributed system.3. The instance number to be assigned to the distributed system is free on all hosts that you plan to

use for the distributed system.4. The same mount point definition scan be used on all hosts that you plan to use for the distributed

system.

For more information, see Pre-Installation Steps.

6.2.1 Default Values

The installation program uses the following default values unless you change them during installation.

Note:The default values used by the installation program are based on the predefined values on the currenthost. The system can only check these values on the master host.

If you plan to install a distributed system, check these values manually on all hosts that will becomepart of the distributed system before you start the installation, and change the system default valuesduring the installation if required.

For more information, see section "Installing or Updating the SAP In-Memory Database".

Changeable Default Values

System Default ValueParameter

Lowest free instance number available on thehostInstance number

/usr/sap

Note:

You can only accept this default value during theinstallation if you install a single-host system.

You must change this default path if you plan tocreate a distributed system.

Installation path

2011-06-1718



/usr/sap/<SID>/homeHome directory

Number with value x+1where x is the highest ex-isting user ID on the current hostID of the user

79Group ID

/bin/shHome of the login shell

Current host nameHost

<inst_path>/<sid>/global/hdb/dataPath for storing the data volumes - see recommen-dation below

<inst_path>/<sid>/global/hdb/logPath for storing the log volumes - see recommen-dation below

Note:For data security reasons, we recommend that you store the data and log volumes on disks that areseparate from each other and from the system. For more information, see Call Options for the hdbinstProgram.

After the installation has finished, edit the sapprofile.ini configuration file and change the entriesHDB/basepath/datavolumes and HDB/basepath/logvolumes accordingly.

Non-Changeable Default Value


<sid>admName of the user with operating system userpermissions

6.3 Logging

2011-06-1719


The installation process is logged by the system. The log files are stored in the following path:

/var/tmp/hdb_<SID>_<action>_<time_stamp>

where <action> :: = install | update | addhost | uninstall

There are two log files written during installation:• *.log: can be read using a text editor• *.msg: XML format for the display in the installation tool with the graphical user interface

6.4 Displaying Information about Installed Software

You can use the following command to display a list of the installed systems on the host:

./hdbinst --list_systems

2011-06-1720


Installing or Updating the SAP In-Memory Database

7.1 Pre-Installation Steps

Before you start installing the SAP In-Memory Database, perform the pre-installation steps shownbelow.1. Decide whether to install a single-host system or a distributed system.

Since there are differences in the installation of a single-host system and a distributed system, decidewhich type of system you want to install.

2. Determine the user ID, sapsys group ID, and instance number.

Note:

For a single-host system, the installation program performs checks and suggests appropriate defaultvalues for these variables.

For a distributed system, use operating system commands to display information about user IDs,sapsys group IDs, and instance numbers:• User ID

Find out which user ID can be used for the planned system. Use a user ID that is still free - thatis, it is not being used on any existing host.

• sapsys group ID

Find out the IDs of the sapsys group used on all existing hosts that will be part of the system tobe installed. Note that this ID needs to be the same on all hosts involved.

• Instance number

Display the instance numbers already in use on all hosts involved, and identify an instance numberthat is still free - that is, it is not being used on any existing host.

For more information, see your operating system documentation.

3. Determine and create mountpoints.

For a distributed system, the same mountpoint <sapmnt> definitions on all hosts involved arerequired. These mountpoints must use the same string to point to the folder on the file system inwhich the software is installed that is commonly used by all hosts of a distributed system.

For more information on how to create mountpoints, see your operating system documentation.

2011-06-1721


7.2 Installing or Updating Using the Installation Manager

• GTK2 must be installed to run the graphical installation tool (GTK2 is contained in SLES11).• You are logged on as the root user.• This user is authorized to open a display.• You have finished the Pre-Installation Steps.

Installation Manager is the graphical user interface (GUI) for installing the SAP In-Memory Database.You can use it to perform the following:• Install or update a single-host system• Install or update the master of a distributed system

To use the Installation Manager:1. Open a root shell and go to the directory where you unpacked the software.2. Call the hdbsetup program as follows:

./hdbsetup

3. Choose the activity to be performed.4. Follow the instructions displayed by the Installation Manager, specifying the required entries. You

might need to refer to the values specified in Pre-Installation Steps.5. Leave the root shell after the installation has finished.

You have installed a SAP In-Memory Database, and it is now running.

It restarts automatically whenever you restart the host.

Optional: For a distributed system, continue with Adding a Host to the System.

Note:

When you call the hdbsetup program, you can also specify a configuration file and the other commandline options, except the -b option (batch mode).

Individual options override values specified in the configuration file, which in turn override the DefaultValues in the hdbsetup program.

Related Topics• Call Options for the hdbinst Program

7.3 Installing or Updating Using the Command Line

2011-06-1722


At the command line, you can install and update the software for the SAP In-Memory Database ininteractive mode or in batch mode. To run the installation or update in batch mode, specify all optionsrequired for the installation or update.

You can also specify a predefined configuration file. If you use a configuration file, you can additionallyspecify options in the command line to override individual options specified in the configuration file orthe default values in the hdbinst program.

7.3.1 Installation Methods Using the Command Line

7.3.1.1 Installing Using the Command Line in Interactive Mode

You are logged on as the root user.

In interactive mode, the program queries all parameters that are not defined in a configuration file orusing command line options, as well as parameters that have invalid values.1. Enter this command to start the installation:

./hdbinst

2. Specify the data requested by the program.Default values are displayed in square brackets.

3. Press Enter if you want to confirm the default values, noting the restrictions specified under"Determine the user ID, sapsys group ID, and instance number " and "Determine and createmountpoints" in Pre-Installation Steps.


7.3.1.2 Installing Using the Command Line in Batch Mode


Note:When calling the hdbinst program in batch mode, specify all required values using command lineoptions. If you omit required values or if you specify invalid values, the program does not run in batchmode but instead queries all missing parameters.

2011-06-1723


• Run hdbinst with the following options:./hdbinst --batch[<option_list>]

<option_list> :: =<option> <option> ...

<option> :: = -b |-h | -v | --home=<home_dir> | --password=<password> |--sid=<SID> | [--batch] | [--checkfiles] |[--configfile=<file_name>] | [--groupid=<group_ID>] |[--hostname=<host_name>] |[--no_debug_packages] |[--number=<instance_number>] | [--sapmnt=<target>] |[--shell=<shell>] | [--userid=<user_id>]


7.3.1.3 Call Options for the hdbinst Program

DescriptionOption - ShortOption - Long

Runs the program in batch mode-b--batch

Displays the list of installation options-h--help

Displays the version of the installation program-v--version

Specifies the directory containing the installation kit

Default: -a server

To specify the lifecycle management directory structure, enter-a lm. This is required for the automated update of HANA.

Note that the setting of this option affects the option install_Type(see below in this table).

-a <dir>--archive_dir

Specifies whether the instance starts automatically after themachine is rebooted

ON: The instance starts automatically.

OFF: The instance does not start automatically (default value).

--autostart= ON | OFF

2011-06-1724



Checks whether components of the installation kit are alreadyinstalled on this host

--check_files

Specifies a configuration file for using a preconfigured setupwith the graphical installation tool or for installing in the com-mand line in batch mode.

The file must be in regular ini file format.

The specified name is interpreted by the installation programas relative to the installation directory.

If the installation kit is located on a read-only file system (forexample DVD), specify the absolute path to the configurationfile.

--configfile=<file_name>

Specifies the location where the data volumes should be stored

Default:

<inst_path>/<sid>/global/hdb/data

--datapath=<base_path_data_volume>

Specifies the ID of the sapsys group

Default: 79

Note the restrictions specified under "Determine the user ID,sapsys group ID, and instance number " in Pre-InstallationSteps.

-G <group_ID>--groupid=<group_ID>

Specifies the home directory of the <sid>adm user

Default:

/usr/sap/<SID>/home

It is created by the system on the local host.

--home=<home_dir>

Specifies the virtual host name

Default: current host

If required, this can be the fully qualified domain name. This isused for lifecycle management.

-H<host_name>

--hostname=<host_name>

2011-06-1725



Specifies the installation number for lifecycle management

Default value:

INITIAL

-i <install_num-ber>

--installation=<install_number>

Displays available software components and their versions-l--list_packages

Displays a list of the installed in-memory systems, clients, andstudios on the host

--list_systems

Specifies the location where the log volumes should be stored

Default:

<inst_path>/<sid>/global/hdb/log

--logpath=<base_path_log_volume>

Suppresses the installation of debug packages--no_debug_packages

Specifies whether the instance should be started automaticallyafter installation

OFF: The instance is started automatically after installation

ON: The instance is not started automatically after installation

Default value: OFF

--nostart= ON | OFF

Specifies the number n of the instance to be created, where 0< n < 99


-n <in-stance_num-ber>

--number=<instance_number>

Specifies the password for the <sid>adm user

Minimum length is 8 characters.

-p <password>--password=<password>

For distributed systems on Linux or if for other reasons youwant to store the engine software on a file system:

To export the file system under which the software is to be in-stalled, export options rw, no_root_squash are required.

--sapmnt=<target>

2011-06-1726



Specifies the absolute path of the login shell of the <sid>admuser.

Example:/bin/sh

--shell=<shell>

Specifies the system ID for the system to be installed

Note the restrictions specified under System.

-s <SID>--sid=<SID>

Specifies the user ID for the <sid>adm user, where:

1000 ≤ <user_id> < 32000

Default: x+1, where x is the highest existing user ID on the host


-U <user_id--userid=<user_id>

Defines the password of the engine user SYSTEM--system_user_password=<password>

Installation type for landscape management

This option depends on the value set in the option --archive_dir(see above in this table).

If the value of the option --archive_dir is the default, server ,this option has the following values:

Default: DEFAULT

The other possible value is BYD.

If the value of the option --archive_dir is lm, lifecycle manage-ment, this option has the following values:

Default value: HANA.Enterprise

The other possible value is HANA.Platform.

-T <inst type>--installType=<insttype>

7.3.2 Update Methods Using the Command Line

2011-06-1727


7.3.2.1 Updating Using the Command Line in Interactive Mode


Note:In interactive mode, the program queries all parameters that are not defined using command line optionsas well as parameters that have invalid values.

1. Enter the folowing command to start the update:./hdbupd

2. Specify the data requested by the program.

Related Topics• Call Options for the hdbupd Program

7.3.2.2 Updating Using the Command Line in Batch Mode

You are logged in as the root user.

Note:When calling the hdbupd program in batch mode, specify all required values using command lineoptions. If you omit required values or if you specify invalid values, the program does not run in batchmode but instead queries all missing parameters.

• Run the hdbupd program in batch mode:./hdbupd --batch --password=<password> --sid=<SID>

Related Topics• Call Options for the hdbupd Program

7.3.2.3 Call Options for the hdbupd Program

2011-06-1728


DescriptionOption - Short FormOption - Long Form


Displays the list of update options-h--help

Displays the version of the update program-v--version

Specifies the password of the <sid>adm user-p <password>--password=<password>

Specifies the system ID of the system to be updated-s <SID>--sid=<SID>

2011-06-1729


2011-06-1730


Adding a Host to the System

You can add a host to an existing system by using the hdbaddhost program to set up a distributedsystem. Each installation has its own hdbaddhost program.

When installing the master for a distributed system, there are specific requirements that you must meetbefore you can add hosts and create a distributed system. For more information, see Distributed System,Installation Planning and Pre-Installation Steps.

Before you can add a host to the system, make sure that you meet these prerequisites:• A system has been installed with its server software on a shared file system (export options rw,

no_root_squash).• This system is running.• You are logged on to the new host as the root user.• You have mounted the current host to the shared file system.• The user ID of the <sid>adm on the master system are free and can be used on the current host.• The group ID of the <sid>adm on the master system are free and can be used on the current host.• The number of the master instance is free on the current host.• In an SAP system, the requirements for host names of SAP servers are met. For more information,

see SAP Note 611361 Host Names of SAP servers.

8.1 Adding a Host in Interactive Mode

Make sure that you meet the prerequisites in Adding a Host to the System.

In interactive mode, the program queries all parameters that are not defined using command line optionsas well as parameters that have invalid values.1. Open a root shell.2. Via the local mount point, change to the following directory on the shared file system:

/<sapmnt>/<SID>/global/hdb/install/bin

3. Call the hdbaddhost program by entering this command:./hdbaddhost


A host is added to the system, and it is now running.

To add more hosts to the system, repeat this procedure on the other hosts to be added.

2011-06-1731


http://service.sap.com/sap/support/notes/611361

Related Topics• Call Options for the hdbaddhost Program

8.2 Adding a Host in Batch Mode

Make sure that you meet the prerequisites in Adding a Host to the System.

When calling the hdbaddhost program in batch mode, specify all required values using command lineoptions. If you omit required values or specify invalid values, the program does not run in batch modebut instead queries all missing parameters.• Run the hdbaddhost program in batch mode:

<sapmnt>/<SID>/global/hdb/install/bin #./hdbaddhost --batch --password=<password> [--host=<hostname>]

A host is added to the system, and it is now running.

To add more hosts to the system, repeat this procedure on the other hosts to be added.

Related Topics• Call Options for the hdbaddhost Program

8.3 Call Options for the hdbaddhost Program


Runs the installation program in batchmode-b--batch

Displays the list of program options-h--help

Displays the installation program version-v--version

2011-06-1732



Specifies a configuration file to specify theinstallation program parameters

The file must be in regular ini file format.

The specified name is interpreted by theinstallation program as relative to the instal-lation directory. If the installation kit is locat-ed on a read-only file system (for exampleDVD), specify the absolute path to theconfiguration file.

--configfile=<file_name>

Specifies the virtual name of the currenthost-H <host_name>--hostname=<hostname>

Specifies the password of the <sid>admuser.-p <password>--password=<password >

Specifies the path to the exported file sys-tem where the software was installed--sapmnt=<target>

Specifies the ID of the system to which thehost should be added--sid=<SID>

Specifies the index server role - must bespecified. Default is worker.--role=worker|standby

Failover group in high-availability (HA)scenarios--group=<host_group>

2011-06-1733


2011-06-1734


Renaming an IMDB System

You can rename an SAP In-Memory (IIMDB) system as described in this section.

Before you can rename an IMDB system, you need to meet these prerequisites:• You identify an existing IMDB system, created by an installation or a file system copy, that is to be

renamed.• The target system ID (SID) must not exist.• The target instance number must not exist.• You are logged in as the root user.

9.1 Call Options for the hdbrename Program

Table 9-1:


Runs the installation program inbatch mode-b--batch

Displays the list of program options-h--help

Displays the installation programversion-v--version

2011-06-1735



parameters via configuration file

Specifies a configuration file tospecify the installation program pa-rameters.

The file must be in regular ini fileformat.

The specified name is interpreted bythe installation program as relativeto the installation directory. If the in-stallation kit is located on a read-onlyfile system (for example DVD),specify the absolute path to the con-figuration file.

--configfile=<filename>

Source system ID-s <sid>--source_sid=<sid>

System administrator password

This is required if the source systemis running.

--source_password=<src_passwd>

Target system IdS <newsid>--target_sid=<newsid>

Target instance number-n <instance_number>--number=<instance_number>

Location of data volumes--datapath=<base_path_data_volumes>

Location of log volumes--logpath=<base_path_log_volumes>

Location of data backups--databackuppath=<base_path_data_backup>

Location of log backups--logbackuppath=<base_path_log_backup>

System administrator password-P <password>--target_password=<password>

Home directory of system administra-tor--home=<home_dir>

2011-06-1736



Log-in shell of system administrator--shell=<shell>

User ID of system administrator-U <uid>--userid=<uid>

Group ID (sapsys)-G <gid>--groupid=<gid>

Rename hosts <source hostname>=<target host name>-H <hostS>=<hostT>--hostmap <hostS>=<hostT>

2011-06-1737


2011-06-1738


Uninstalling the Software

Each installation has its own uninstallation tool.

To uninstall the software of the SAP In-Memory Database, use the hdbuninst program of the softwarepackage to be uninstalled.

If you want to uninstall a single-host system, follow the instructions below.

If you want to uninstall a distributed system, first follow the instructions in Removing a Host to removethe hosts that were added to the system one by one. After you have removed all hosts added to themaster, you can uninstall the master itself as described in the instructions below.

10.1 Uninstalling the Software in Interactive Mode

Before you uninstall the software, make sure that you meet these prerequisites:• You are logged on to the host where the server software is installed.• You are logged on as the root user.

In interactive mode, the program queries all parameters that are not defined using command line optionsas well as parameters that have invalid values.1. Open a root shell.2. In a single-host system, go to this directory:

/usr/sap/<SID>/SYS/global/hdb/install/bin

3. In a distributed system, go to this directory:<sapmnt>/<SID>/SYS/global/hdb/install/bin

4. Enter this command:./hdbuninst


All SAP In-Memory Database server software is removed from this path.

Related Topics• Call Options for the hdbuninst Program

2011-06-1739


10.2 Uninstalling the Software in Batch Mode

Before you uninstall the software, make sure that you meet these prerequisites:• You are logged on to the host where the server software is installed.• You are logged on as the root user.

To call the hdbuninst program in batch mode, specify all required values using command line options.

Note:If you omit required values or specify invalid values, the program does not run in batch mode but insteadqueries all missing parameters.

• Run the hdbuninst program in batch mode:./hdbuninst -b --sid=<SID> [-k]

All SAP In-Memory Database software is removed from the selected host.

Related Topics• Call Options for the hdbuninst Program

10.3 Removing a Host

• You are logged on to the host to be removed.• You are logged on as the root user.

To remove a host, do the following:1. Open a root shell.2. Via the local mount point, change to this directory :

<sapmnt>/<SID>/SYS/global/hdb/install/bin

3. Enter this command:./hdbuninst


The current host is removed from the system.

If you want to remove other hosts from the system, repeat this procedure on each host in the system.Finally, uninstall the master as described in Uninstalling the Software.

2011-06-1740


10.4 Call Options for the hdbuninst Program



Displays the list of uninstallation options-h--help

Displays the version of the uninstallation program-v--version

Keeps the <sid>adm user of the system to be uninstalled-k--keep_user

Displays the installed in-memory systems, client software, andstudio

--list_system

Specifies the system ID of the system to be uninstalled-s <SID>--sid=<SID>

2011-06-1741


2011-06-1742


More Information

LocationInformation Resource

http://www.sap.comSAPBusinessObjects product infor-mation

Navigate to http://help.sap.com/businessobjects and on the "SAP Busi-nessObjects Overview" side panel click All Products.

You can access the most up-to-date documentation covering all SAPBusinessObjects products and their deployment at the SAP Help Portal.You can download PDF versions or installable HTML libraries.

Certain guides are stored on the SAP Service Marketplace and are notavailable from the SAP Help Portal. These guides are listed on the HelpPortal accompanied by a link to the SAP Service Marketplace. Customerswith a maintenance agreement have an authorized user ID to accessthis site. To obtain an ID, contact your customer support representative.

SAP Help Portal

http://service.sap.com/bosap-support > Documentation• Installation guides: https://service.sap.com/bosap-instguides• Release notes: http://service.sap.com/releasenotes

The SAP Service Marketplace stores certain installation guides, upgradeand migration guides, deployment guides, release notes and SupportedPlatforms documents. Customers with a maintenance agreement havean authorized user ID to access this site. Contact your customer supportrepresentative to obtain an ID. If you are redirected to the SAP ServiceMarketplace from the SAP Help Portal, use the menu in the navigationpane on the left to locate the category containing the documentation youwant to access.

SAP Service Marketplace

https://cw.sdn.sap.com/cw/community/docupedia

Docupedia provides additional documentation resources, a collaborativeauthoring environment, and an interactive feedback channel.

Docupedia

https://boc.sdn.sap.com/

https://www.sdn.sap.com/irj/sdn/businessobjects-sdklibraryDeveloper resources

2011-06-1743

More Information

http://www.sap.com

http://help.sap.com/businessobjects

http://service.sap.com/bosap-support

https://service.sap.com/bosap-instguides

http://service.sap.com/releasenotes

https://cw.sdn.sap.com/cw/community/docupedia

https://boc.sdn.sap.com/

https://www.sdn.sap.com/irj/sdn/businessobjects-sdklibrary

LocationInformation Resource

https://www.sdn.sap.com/irj/boc/businessobjects-articles

These articles were formerly known as technical papers.SAP BusinessObjects articles onthe SAP Community Network

https://service.sap.com/notes

These notes were formerly known as Knowledge Base articles.Notes

https://www.sdn.sap.com/irj/scn/forumsForums on the SAP CommunityNetwork

http://www.sap.com/services/education

From traditional classroom learning to targeted e-learning seminars, wecan offer a training package to suit your learning needs and preferredlearning style.

Training


The SAP Support Portal contains information about Customer Supportprograms and services. It also has links to a wide range of technical in-formation and downloads. Customers with a maintenance agreementhave an authorized user ID to access this site. To obtain an ID, contactyour customer support representative.

Online customer support

http://www.sap.com/services/bysubject/businessobjectsconsulting

Consultants can accompany you from the initial analysis stage to thedelivery of your deployment project. Expertise is available in topics suchas relational and multidimensional databases, connectivity, databasedesign tools, and customized embedding technology.

Consulting

2011-06-1744

More Information

https://www.sdn.sap.com/irj/boc/businessobjects-articles

https://service.sap.com/notes

https://www.sdn.sap.com/irj/scn/forums

http://www.sap.com/services/education


http://www.sap.com/services/bysubject/businessobjectsconsulting

sap in-memory database - server installation and update guide

Documents