Documentation

SAP HANA 2.0 SP05 Standalone Suse (SAP License not included)

In this section you will find the required information to start using your SAP HANA 2.0 SP5 instance in just minutes.

Topics

What does the instance include

EC2 instance comes with the following products:

  • SAP HANA 2.0 SP05 database

EC2 & SAP information

The following table shows the relevant information about the SAP software installation included in the AMI.

ParameterValue
Hostnamesaphana
FQDNsaphana.linkeit.local
SAP HANA Instance Number00
SAP HANA Administrator Userlnhadm
Master PasswordZaq12wsXXX

Password Change

It is mandatory to change the Database installation Master Password so that it remains private to you and meets all security requirements.

Deployment steps

Follow the next steps to deploy your new SAP instance:

  1. Log on to Amazon MarketPlace https://aws.amazon.com/marketplaceopen in new window

  2. Search for "Preinstalled SAP HANA 2.0 SP05 Suse" and access the product

  3. Click on Continue to Subscribe.

  4. Choose an Instance Type Select one of the AWS instance size from the available choices.

    Sizing

    For HANA database, a minimum of 61Gb memory is required (SAP HANA on AWS). For more detailed information about SAP Business Suite Sizing and appropriate EC2 instance types, please refer to SAP documentation, SAP sizing tool and OSS Notes (S-User required):

  5. Configure Instance Details Configure and define a network and subnet. If you need to connect directly by internet you need to enable Auto-assign Public IP.

  6. Add Storage. You can choose the EBS volume type, you can leave as default or use SSD / IOPS for best performance. In this point you can increase the size of the volumes to expand the filesystems. It depends on the size of the database you are going to use.

  7. Add Tags. Next step is to tag the instance so you can identify it in the AWS Console.

  8. Configure Security Group. You have to open the necessary ports in AWS security Group to allow the connection.

    Minimal ports needed to access the instance are:

    TypeProtocolPort RangeDescription
    SSHTCP22Connect to the EC2 instance remotely
    indexserverTCP30015SQL/MDX access or for standard database access. Used by SAP HANA Studio
    indexserverTCP30013SQL/MDX access or for standard database access on a multitenant system. Used by SAP HANA Studio

    TCP/IP Ports of All SAP Products

    Find additional information in https://help.sap.com/docs/Security/575a9f0e56f34c6e8138439eefc32b16/616a3c0b1cc748238de9c0341b15c63c.html?locale=en-USopen in new window

  9. Review Instance Launch. Review the configuration and click on Launch when accepted.

  10. The process will ask you to provide an existing Key Pair or to create a new one. If you choose to create a new one, do not forget to download the Key Pair file as this will be mandatory to access the EC2 instance through SSH.

  11. After a few minutes, you can access your instance with SSH and do the final configuration steps.

Post-deployment Steps

The following is the list of tasks to be done before you can start working with your SAP environment:

Connect to your EC2 instance

For some actions you will need to access your EC2 instance via SSH. To do so, follow the next steps:

  1. In the EC2 console, navigate to instances. This will list all your instances in Amazon EC2. Make sure the SAP instance you want to connect to is in “running” state. If not, choose the instance, then click on Instance Actions menu, and click on Start in the pull down menu.

  2. Make a note of the IP address assigned to the instance. You will need it to connect to this SAP instance in AWS.

  3. SSH to the instance with ec2-user and the key pair chosen at launch time. To access your instance:

    1. Open an SSH client. (If you are running Windows, check how to connect using Puttyopen in new window
    2. Locate your private key file (<keypair>.pem).
    3. Connect to your instance using its IP:
      ssh -i "<keypair_path>/<keypair>.pem" ec2-user@<IP Addr>

EBS Pre-warming

We recommend you run some pre-warming commands the first time you start the system to increase performance from the beginning. First time you launch an instance from an AMI, the process synchronizes the snapshots that compose this AMI with the EBS volumes of your instance. This can take a long time depending on the size of the disks and the instance type you have chosen. Depending on the instance, it can run out of storage credits and perform at its baseline (3 iops x gb), this situation becomes a bottleneck. The process can take up to 12 hours with a m4.4xlarge instance.

To pre-warm your disks follow the guidelines in the AWS Documentation Guide http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-initialize.htmlopen in new window

Start SAP HANA database

SAP HANA must start automatically when your EC2 instance. Follow these steps to ensure that your database is up and running:

  1. Connect via SSH to your EC2 instance as describe in the previous section.

  2. From the ec2-user shell, jump into the lnhadm user:

    sudo su - lnhadm

  3. Then start the SAP HANA database by executing:

    HDB start

  4. You can check the instance status by executing:

    HDB info

  5. The output should look like the one below:

USER          PID     PPID  %CPU        VSZ        RSS COMMAND
lnhadm      20271    20270   0.2      16520       6460 -sh
lnhadm      20462    20271   0.0      13392       3464  \_ /bin/sh /usr/sap/HDB/HDB00/HDB info
lnhadm      20493    20462   0.0      34856       2916      \_ ps fx -U lnhadm -o user:8,pid:8,ppid:8,pcpu:5,vsz:10,rss:10,args
lnhadm      38697        1   0.0    4843216      52860 hdbrsutil  --start --port 39058 --volume 2 --volumesuffix mnt00001/hdb00002.0
lnhadm      23436        1   0.0     845516      52168 hdbrsutil  --start --port 39052 --volume 2 --volumesuffix mnt00001/hdb00002.0
lnhadm      16226        1   0.0    4777680      52936 hdbrsutil  --start --port 39043 --volume 2 --volumesuffix mnt00001/hdb00002.0
lnhadm      11690        1   0.0     779644      52636 hdbrsutil  --start --port 39001 --volume 1 --volumesuffix mnt00001/hdb00001 -
lnhadm      11373        1   0.0      22684       3076 sapstart pf=/usr/sap/HDB/SYS/profile/HDB_HDB00_saphana
lnhadm      11381    11373   0.0     469196      79316  \_ /usr/sap/HDB/HDB00/saphana/trace/hdb.sapHDB_HDB00 -d -nw -f /usr/sap/HDB
lnhadm      11403    11381   6.2   18866956   15257284      \_ hdbnameserver
lnhadm      11769    11381   0.9    8941528     919084      \_ hdbcompileserver
lnhadm      11772    11381   0.7    9209800     432628      \_ hdbpreprocessor
lnhadm      11829    11381   0.5   10618800     582224      \_ hdbdiserver
lnhadm      11832    11381   0.7   10901996     673244      \_ hdbwebdispatcher
lnhadm      11835    11381   0.4     779956     312396      \_ /hana/shared/HDB/xs/bin/../sapjvm_8/bin/java -Xmx128m -Xms64m -XX:Thr
lnhadm      14207    11835   0.0    1254380     346380      |   \_ /hana/shared/HDB/xs/router/webdispatcher/sapwebdisp pf=/hana/shar
lnhadm      11838    11381   5.0     776800     261924      \_ /hana/shared/HDB/xs/bin/../sapjvm_8/bin/java -Xmx128m -Xms64m -XX:Thr
lnhadm      11841    11381   0.4    1895420     713548      \_ /hana/shared/HDB/xs/bin/../sapjvm_8/bin/java -Djava.util.logging.conf
lnhadm      14759    11381  41.6   96236884   92432832      \_ hdbindexserver -port 39043
lnhadm      14762    11381   1.3   12040788    1870208      \_ hdbxsengine -port 39046
lnhadm      19226    11381   0.6   10622636     600796      \_ hdbdiserver -port 39055
lnhadm      21118    11381   5.5   14945020    9212340      \_ hdbindexserver -port 39052
lnhadm      35843    11381  52.4  124861036  121320788      \_ hdbindexserver -port 39058
lnhadm      35846    11381   1.3   12435288    1788380      \_ hdbxsengine -port 39061
lnhadm      39642    11381   0.6   10621356     598532      \_ hdbdiserver -port 39064
lnhadm       5623        1   0.0     501652      30600 /usr/sap/HDB/HDB00/exe/sapstartsrv pf=/usr/sap/HDB/  SYS/profile/HDB_HDB00_lnks
lnhadm       5356        1   0.0      41520       5044 /usr/lib/systemd/systemd --user
lnhadm       5359     5356   0.0      86680       1928  \_ (sd-**pam**

License your SAP HANA database

SAP HANA 2.0 SP05 Suse database comes without a valid SAP License on it. To activate SAP HANA database you must provide the system with a valid license. Follow the next steps to activate the server:

  1. Connect to the SYSTEMDB database by using SAP HANA Studio or command line tools. The following examples will be based on SAP HANA Studio.

  2. The first time you connect to Hana studio an error message will appear to inform that you need a proper license. Access to Tenant (SAP) DB

  3. Click on the Checking license properties... link in the warning message, or access the Properties of the server in the drop down menu.

  4. Note down the Hardware Key for the license request in SAP Portal.

  5. Go to https://support.sap.com/keys-systems-installations/keys.htmlopen in new window and obtain a valid license for your deployed SAP HANA database following the SAP License Keys for the SAP HANA Database Guideopen in new window

  6. Download the license file to your computer.

  7. Go back to Properties section in SAP HANA Studio.

  8. Click on Install a license

  9. Select your downloaded license file and Accept.

  10. If no error is displayed means that your SAP HANA database has been correctly licensed.

Ready to work

If all the previous steps are done, you are ready to start working with your new SAP Instance!

Check [Maintenance] section for more details in how to manage the daily basis.