SAP Certified Technology Associate: C_HANATEC_13 – by the SAP HANA Academy

Introduction

Interested in a career as SAP HANA technology consultant?

In this blog, I will provide the information you need to help you prepare for the SAP Certified Technology Associate – SAP HANA 2.0 certification exam, C_HANATEC_13.

This exam verifies that you have the required knowledge to install SAP HANA in a tailored data center (TDI) environment.

For the previous version of this blog, see

For more information about TDI, see

About the Certification

Currently, there are two versions of the SAP HANA technology associate certification:

  • C_HANATEC_13 – SAP Certified Technology Associate – SAP HANA 2.0
  • C_HANATEC_12 – SAP Certified Technology Associate – SAP HANA (Edition 2016)

Both have 80 questions, but the cut score has gone up a bit from 60 to 65% for the latest edition, so you now need to answer 52 questions correctly (up from 48).

The certification version number used to follow the SAP HANA SPS release, e.g. TEC_12 = SPS 12, but as SPS 13 entered the market as SAP HANA 2.0, this is no longer the case.

As a rule, SAP certifications are valid for a limited time period, see the FAQ.

For a list of valid certifications, see https://training.sap.com/shop/certification/validity.

You can check the validity of your exam in the SAP Credentials Manager.

At the time of writing, the certification programs for SPS 10 and earlier have expired.

Sample Questions

SAP Education provides a number of sample questions for each exam (10 for C_HANATEC_13) with  answers to help you assess your readiness for the exam. However, there is no explanation why certain answers are correct and others incorrect.

For this reason, I have posted a seperate blog where I explain the answers to the questions with some exam training suggestions and references:

Topic Areas

The topic areas have changed slightly comparing TEC12 (left) with TEC13 (right) although most categories still have an 8%-12% weight (6-10 questions).

New in the exam is the topic Multitenant Database Containers (MDC) and Operations of SAP HANA has now been renamed to Database Adminisration Tools and Tasks.

Monitoring and Troubleshooting, which counted for about a quarter of the weight for TEC12, now has been consolidated into a single topic area and the High Availability & Disaster Tolerance topic has received a few more questions.

Topic Areas: TEC_12 (left) and TEC_13 (right)

Resources

For the exam, the same SAP Education training resources are listed, based on the SAP HANA 2.0 SPS00 release:

You might need to include the prerequisite for HA200 as well:

Training participation is not a requirement. However, because of the direct relation of the exam with the training, participation is certainly recommended. If you can only attend one training, make it HA200.

Additional resources as preparation for the exam are publicly available (at no charge) on the SAP HANA Platform section on the SAP Help Portal. Particularly recommended are the following guides:

The Database Migration Option (DMO) of the Software Update Manager (SUM) tool is not included in the SAP HANA documentation set but part of the System Landscape Toolset on the SAP Service Market Place (requires login).

A good start is the SCN document Database Migration Option (DMO) of SUM – Introduction.

SAP HANA Academy

To help you prepare for the exam, there are several playlists with dozens of tutorial videos on the SAP HANA Academy channel on YouTube. Additionally, you might find our blogs useful as well in your preparation

Blogs

Playlists

References

SAP Blogs

SAP Education

Thank you for watching

The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.

For the full library, see SAP HANA Academy Library – by the SAP HANA Academy

For the full list of blogs, see Blog Posts – by the SAP HANA Academy

Installing SAP HANA SHINE – by the SAP HANA Academy

Introduction

Recently, we have updated a number of SAP HANA Academy tutorial videos for the playlist

In this blog, I will provide some references and background information for the SAP HANA Interactive Education (SHINE) videos (3) of the series.

This blog is part of a series:

SAP HANA Interactive Education

SAP HANA Interactive Education, or SHINE, is a demo application created to make it easier to learn how to develop native applications for the SAP HANA platform.

SHINE was originally introduced as an XS (classic) application back in 2013. For the nostalgic, here is a vintage video for the SPS 07 release SAP HANA Academy – SHINE: Getting Started.

SHINE for XS Advanced was made available in SPS 11 and the process of migrating from the classic to the advanced XS architecture serves as an example in the SAP HANA XS Advanced Migration Guide:

As the XS classic architecture was deprecated for SAP HANA 2.0 SPS 02 (although still available) in this blog I will only cover the installation of SHINE for XS Advanced.

As the architecture and API’s for XS Advanced are the same for Cloud Foundry, there is also a SHINE version available for the SAP Cloud Platform:

To learn more about XS Advanced, Cloud Foundry, and future developments, watch the interview with product owner Krishna Kumar and chief architect Stephen Cherian:

For the latest What’s New documentation, see:

For the fine print, known issues and limitations, see the Release & Information Note:

Installing SHINE

Below two tutorial videos about installing SHINE on the SAP HANA platform and express edition and one about enabling SHINE on the SAP Cloud Platform.

The installation steps are roughly the same:

  • download the component
  • check the pre-requisites for installation
  • create a user and grant the required role privileges
  • execute prerequisites for data generation

On the SAP Cloud Platform, of course, this all happens automagically.

Install SHINE on the platform edition

For the platform edition, be it on-premise in your company’s data center or hosted by a cloud provider like Microsoft Azure, Amazon AWS, or the Google Cloud Platform, you will need to perform all the installation steps yourself as you can see in the tutorial video below:

SAP HANA Academy – Install SHINE (SAP HANA platform edition)

You can download the component from SAP ONE Support Launchpad Software Downloads (SAP HANA DEMO MODEL ADV. 1 (SUPPORT PACKAGES AND PATCHES).

SAP ONE Support Portal Software Downloads

Install SHINE on the express edition

For the express edition, the prerequisite checks and the user creation are performed by an installation script for your convenience. All we need to do is download SHINE to the HANA server – and we can do this using the download manager included with SAP HANA, express edition – and run the installation script. Easy!

SAP HANA Academy – Install SHINE (SAP HANA, express edition)

If your SAP HANA, express edition server does not have internet connectiviy, you can download SHINE using the SAP HANA, Express Edition Download Manager to your Windows or Mac client computer and then transfer it to the SAP HANA server.

SAP HANA, Express Edition Download Manager

Enable SHINE on the SAP Cloud Platform

To enable SHINE on the SAP Cloud Platform, we only need to define the user.

SAP HANA Academy – Enable SHINE on the SAP Cloud Platform

Next Steps

For in-depth information about the code, usage scenarios and tutorials, see the guide:

Lucia Subatin has also published some easy to follow-along tutorials on the SAP Developer site:

Once you have found your bearings, you can start to clone the source code repository from GitHub:

Finally, for completeness sake, there is an openSAP course on SHINE from 2016 but you will need to reactivate it for a small fee. It is mostly on the original XS classic version, so you may want to wait for an update:

SHINE Sales Dashboard

References

SAP HANA Academy Playlists

SAP Downloads

SAP GitHub Repositories

SAP Documentation

SAP Blogs

Notes

SAP Developer Tutorials

Open SAP

SAP Teched

Thank you for watching

The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.

For the full library, see SAP HANA Academy Library – by the SAP HANA Academy

For the full list of blogs, see Blog Posts – by the SAP HANA Academy

SAP HANA Installation Automation – by the SAP HANA Academy

Introduction

Recently, we have updated a number of SAP HANA Academy tutorial videos for the playlist

In this blog, I will provide some references and background information about installation automation with the SAP HANA platform lifecycle management tools.

This blog is part of a series:

 

SAP HANA Academy – SAP HANA Installation and Update (YouTube Playlist)

 

Tutorial Video

SAP HANA Academy – SAP HANA Installation and Update: Installation Automation

 

Create the Configuration File

In the previous blogs about SAP HANA 2.0 platform lifecycle management and SAP HANA 2.0 Server Installation, I already briefly mentioned installation automation. Using a combination of configuration files, optional command line options, you can automate installations, that is, create a repeatable process that can be scheduled without any further human intervention.

The process is simple. First, you create a configuration or response file by running the hdblcm installation tool with the dump_configfile_template and the action parameter.

The location and name of the file, including the extension (if any), are for you to choose.

./hdblcm --action=install \
--dump_configfile_template=/tmp/install.rsp

This command will generate both the configuration template file and a password template file.

 

Configure the Configuration File

Next, we need to edit the installation parameters. There are a bit over 100 parameters available so this might take a bit time to get this right, depending on the requirements. However, the good news is that all parameters have a default value, except for the sid (system identifier) and the password parameters.

For the parameter reference, see

 

General and Action

In the General section, you specify where the installation media is located (component_medium, _dirs, _root), whether to use a master password – for the operating system accounts <sid>adm and sapadm and database users SYS and SYSTEM (amongst others, see below) and which components to install.

It also includes the configuration of remote execution which concerns a distributed (multi-host) installation which itself is configured in the AddHosts section (see below).

For remote execution of multiple-host system operations, see

 

The Action section only has a single parameter, action, which will have been already specified with the value you provided on the command line when running the hdblcm command.

As I explained in the SAP HANA 2.0 platform lifecycle management blog, hdblcm is a ‘wrapper’ tool that calls other executables for the different actions. Action=install will call hdbinst and action=update will call hdbupd. In the Client section below, you can see that we can run these tools independently as well with a response file, for example, when installing the SAP HANA client on a client computer.

 

Server

In the Server section, all the parameters specific to the HANA database server are specified. The sid is required, all others are optional.

For more information about these parameters, see

 

Storage

The storage_cfg parameter points to the directory where you have placed the customized global.ini file. This makes it possible to set up a storage connector, allowing SAP HANA to use hardware vendor-specific scripts for automated resource allocation and input/output fencing during failover.

For an example of such an implementation, see

For the documentation, see

Note that the hdbparam utility is no longer included with SAP HANA 2.0 and has been deprecated.

 

Storage Configuration Best Practices for SAP HANA TDI on Dell EMC VMAX 33 Solution Guide

Implementing High Availability and Disaster Recovery Solutions with SAP HANA on IBM Power Systems

The AddHosts section covers the parameters relevant to distributed (mult-host) systems: the hostname of the hosts and the host role.

Optional Components

There is a dedicated section for each of the different host roles (Streaming Analytics, Dynamic Tiering, Accelerator for ASE and Remote Data Synch. When these components are not listed in the General section, these sections are ignored by the installer.

For more information about these features, see

 

XS Advanced

For the XS Advanced runtime, there is another dedicated parameter section.

For more information about these parameters and about installing XSA, see

 

Client and Studio

Finally, there is a section about the SAP HANA client and studio. See

 

Configure the Password File

As we have seen, there are several locations where passwords can be specified in the configuration file. Master password in the General section, operating system accounts (root, sapadm, <sid>adm) and database users in the Server section, accounts for features, and for XS Advanced.

Typically, a security administrator will not be amused when passwords are specified in text files.

For this reason, the  read_password_from_stdin=xml parameter is available to indicate to hdblcm when running in batch mode to get the passwords from ‘standard input’, which for UNIX refers to commands entered on the command line.

However, as we still want to automate the installation, we are now going to set the passwords in another configuration file, this time in XML format, which we can secure and include in the installation process as appropriate.

In the vi editor, you can use the substitute command to easily change the asterisks to a new master password.

:%s/\*\*\*/your-master-password/

 

For more information, see

 

Install in Batch Mode

When we are done with editing the configuration and password file, we can simply run the install in batch mode with the -b (or –batch) parameter together with —configfile.

Parameters passed as call options to the installer take precedence over parameter defined in the configuration file.

You could, for example, generate the SID parameter using a script and pass it to the installer in case you need unique values.

#!/bin/bash
# sample script to explain the concept
# do not try this at home or at work

for i in {0..9} do
./hdblcm -b --sid=EZ$i –-configfile=server.cfg
done
exit 0

 

To include our password parameter file, we are going to make use of more UNIX magic: the pipe. This allows us to pass the passwords to the installer without displaying them on the console or in command history.

cat ~/passwords.xml | ./hdblcm --sid=DB1 \
--read_password_from_stdin=xml \
--configfile=server.cfg -b

 

SAP HANA Client

To automate installations of the SAP HANA client (or studio) on a system that do not contain an SAP  HANA server installation, we can use the same approach.

First, generate a configuration file and edit the parameters. This time, use the hdbinst or hdbupd executable directly (and hence we no longer need to specify the action= parameter). Again, the name and extension of the response file are irrelevant.

To install, run the command specifying –batch (-b) with configfile.

For the parameter reference, see

 

# Windows in command prompt
hdbinst.exe --dump_configfile_template=c:\temp\client.rsp
hdbinst.exe -b --configfile=c:\temp\client.rsp

# UNIX, Linux, macOS 
./hdbinst --dump_configfile_template=/tmp/client.cfg
./hdbinst -b --configfile=/tmp/client.cfg

 

References

For more information see:

SAP HANA Academy Playlists

SAP Community Blogs

SAP Documentation

Notes

SAP Partner Documentation

 

Thank you for watching

The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.

For the full library, see SAP HANA Academy Library – by the SAP HANA Academy

For the full list of blogs, see Blog Posts – by the SAP HANA Academy

 

SAP HANA 2.0 editions (2018) – by the SAP HANA Academy

Introduction

The Feature Scope Description for SAP HANA has been updated for 2018. In this blog, you will find a brief overview of the feature sets with references to SAP HANA Academy tutorial videos and playlists.

For the previous version of this blog, see

Editions

SAP HANA is available in three editions:

 

SAP HANA Features

SAP HANA platform

 

Standard Edition

The SAP HANA standard edition comprises the core database, integration and application services, series data, plus a number of components that require additional installation. Some components require the usage the SAP HANA database lifecycle management toold ‘hdblcm’ (Platform Lifecycle Managment). Others are “powered by HANA” and make use of Application Lifecycle Management (ALM) tools for installation:

  • Dynamic Tiering (PLM)
  • SAP HANA Accelerator for SAP ASE (PLM)
  • SAP Enterprise Architecture Designer, edition for SAP HANA (ALM)
  • Operational Process Intelligence (ALM)
  • HANA Rules Framework (ALM)
  • Data Warehousing Foundation (ALM)

There are no playlists on the SAP HANA Academy that specifically cover the core SAP HANA  services but you will find most of them addressed in our library.

For recent blog posts on the topic, see

 

Dynamic Tiering

SAP HANA dynamic tiering is a native big data solution for SAP HANA that adds smart, disk-based extended storage to your SAP HANA database with its own database, integration and application services feature sets.

Under the hood: SAP HANA dynamic tiering

 

For recent blog posts on the topic, see

For the SAP HANA Academy video tutorial playlists, see

For the documentation, see

For developer tutorials, see

 

SAP HANA Academy video tutorial – SAP HANA Dynamic Tiering 2.0

 

SAP HANA Accelerator for SAP ASE

The accelerator for SAP Adaptive Server Enterprise (ASE) adds analytics acceleration to the SAP ASE database engine leveraging SAP HANA.

SAP HANA Accelerator for SAP ASE Architecture

 

For recent blog posts on the topic, see

For the documentation, see

 

SAP Enterprise Architecture Designer, edition for SAP HANA

SAP Enterprise Architecture Designer, edition for SAP HANA allows you to capture, analyze, and present your organization’s landscapes, strategies, requirements, processes, data, and other artifacts in a shared environment.

SAP EAD – Workspace

 

For recent blog posts on the topic, see

For the product page, see

For the documentation, see

 

SAP HANA Academy video tutorial – SAP Enterprise Architect Designer

 

Series

Series data is data collected at a measurable interval, such as time. You can use series data SQL statements to detect and forecast trends in a series.

CREATE COLUMN TABLE "InterpolationTable"
    (ts_id VARCHAR(20), date DAYDATE, val DOUBLE)
    SERIES(SERIES KEY(ts_id) PERIOD FOR SERIES(date)
        EQUIDISTANT INCREMENT BY INTERVAL 1 DAY MISSING ELEMENTS ALLOWED);

SELECT CUBIC_SPLINE_APPROX(val, 'SPLINE_TYPE_NOT_A_KNOT')
    OVER(SERIES TABLE "InterpolationTable") FROM "InterpolationTable";

For the SAP HANA Academy video tutorial playlists, see

For the documentation, see

 

Operational Process Intelligence (incl HRF)

Includes SAP Operational Process Intelligence powered by SAP HANA and SAP HANA rules framework.

SAP Operational Process Intelligence – Business Scenario

 

For recent blog posts on the topic, see

For the SAP HANA Academy video tutorial playlists, see

For the documentation, see

 

Data Warehousing Foundation

SAP HANA data warehousing foundation supports data management and distribution across complex SAP HANA landscapes.

For recent blog posts on the topic, see

For the SAP HANA Academy video tutorial playlists, see

For the documentation, see

 

SAP HANA Academy video tutorial playlist – SAP HANA Data Warehousing Foundation

 

Enterprise Edition

The SAP HANA enterprise edition comprises all of the above, adding:

  • Spatial and Graph
  • Data Privacy
  • Search, Text Analysis, and Text Mining

plus a number of components that require additional installation:

  • Predictive Analysis Library and R (PLM)
  • SAP HANA Streaming Analytics (PLM)
  • Enterprise Information Management
    • Smart Data Integration
    • Smart Data Quality
  • SAP HANA Replication
    • SAP Landscape Transformation Replication Server,
    • SAP Replication Server

Spatial and Graph

With SAP HANA Spatial, you can process, store and retrieve geospatial data. With SAP HANA Graph, you can process and visualize graphs, and execute built-in algorithms.

SAP HANA Graph Viewer

 

SAP HANA Spatial Map Client

 

For recent blog posts on the topic, see

For the SAP HANA Academy video tutorial playlists, see

For the documentation, see

For developer tutorials, see

 

SAP HANA Academy video tutorial – Graph: Getting Started 

 

Data Privacy

Data privacy provides additional protection for sensitive and confidential data.

For recent blog posts on the topic, see

For the documentation, see

Search, Text Analysis, and Text Mining

A feature set to search inside the database, gain insights from text analysis and conduct text mining. Previously, search, text analysis, and text mining were collectively referred to as SAP HANA advanced data processing (ADP).

For recent blog posts on the topic, see

For the SAP HANA Academy video tutorial playlists, see

For the documentation, see

 

SAP HANA Academy video tutorial playlist – SAP HANA Search, Text Analysis, and Text Mining playlist

 

Predictive Analysis Library and R

As part of the application function library software development kit for SAP HANA, SAP HANA predictive analysis library (PAL) offers functions to perform classic and universal predictive analysis algorithms for a number of different data mining categories. Integration of the SAP HANA database with R allows you to use the R environment for specific statistical functions.

For recent blog posts on the topic, see

For the SAP HANA Academy video tutorial playlists, see

For the documentation, see

 

SAP HANA Academy video tutorial – Getting Started with PAL

 

SAP HANA Academy video tutorial – Getting Started with R Integration

 

SAP HANA Academy video tutorial playlist – Predictive Analysis Library

 

SAP HANA Streaming Analytics

SAP HANA streaming analytics (also known as SAP HANA smart data streaming) applies complex processing logic to identify patterns, calculate aggregates, detect problems, and generate alerts by combining real-time streams of data with the appropriate historic and reference data using an in-memory stream processing engine. Integrated machine learning capabilities provide SAP HANA streaming analytics with the ability to generate and use predictions in real time.

Under the hood: SAP HANA streaming analytics

 

For recent blog posts on the topic, see

For the SAP HANA Academy video tutorial playlists, see

For the documentation, see

For developer tutorials, see

 

 

SAP HANA Academy video tutorial playlist – SAP HANA Streaming Analytics

 

Enterprise Information Management

Bundles SAP HANA Smart Data Integration (Integration Services and Enterprise Semantic Services) and SAP HANA Smart Data Quality.

For recent blog posts on the topic, see

For the SAP HANA Academy video tutorial playlists, see

For the documentation, see

 

SAP HANA Academy video tutorial playlist – SAP HANA Smart Data Integration and Smart Data Quality

 

SAP HANA Replication

SAP HANA replication provides technologies for replicating data from any supported source system to the SAP HANA database: trigger-based data replication using SAP Landscape Transformation Replication Server, log-based replication using SAP Replication Server.

For recent blog posts on the topic, see

There are currently no tutorial videos on this topic in the SAP HANA Academy.

For the documentation, see

 

SAP HANA Active/Active Read Enabled System Replication

The active/active read-enabled feature enhances the existing high availability and disaster recovery capabilities of SAP HANA system replication and enables you to use the secondary systems of SAP HANA system replication actively for read-intense workloads.

SAP HANA cockpit – System Replication

 

For a recent blog post on the topic, see

For the SAP HANA Academy video tutorial playlists, see

 

SAP HANA Academy video tutorial – SAP HANA System Replication Active/active read-enabled 

 

Express Edition

SAP HANA, express edition has its own Feature Scope Description document. Most of the standard services are included but obviously not the functionality that would make little sense for a developer edition, like distributed systems (32 GB memory restriction) and dynamic tiering (separate installation on an additional host). For the full list, see Feature Scope Description for SAP HANA, express edition 2.0 SPS 02.

For recent blog posts on the topic, see

For the video tutorial playlist, see

For developer tutorials, see

 

SAP HANA Academy video tutorial playlist – SAP HANA Express

 

 

More Information

SAP HANA Academy Playlists

SAP Community Posts

SAP Community Tags

Developer Tutorials

Product Documentation (Guides)

Product Documentation (Portal)

Product Home

 

Thank you for watching

The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.

For the full library, see SAP HANA Academy Library – by the SAP HANA Academy

For the full list of blogs, see Blog Posts – by the SAP HANA Academy

 

SAP HANA platform lifecycle management – by the SAP HANA Academy

Introduction

Recently, we have updated a number of SAP HANA Academy tutorial videos for the playlist

In this blog, I will provide some references and background information about using SAP HANA platform lifecycle management tools.

This blog is part of a series:

 

SAP HANA Academy – SAP HANA Installation and Update (YouTube Playlist)

 

Tutorial Video

SAP HANA Academy – SAP HANA Installation and Update: Lifecycle Management Tools

 

Overview

SAP HANA provides tools for both Application Lifecycle Management (ALM) for everything that is ‘powered by HANA’ – running on the SAP HANA platform, that is – and for Platform Lifecycle Management (PLM), to manage the installation and update for the SAP HANA platform itself, the topic of this blog. ALM will be addressed in another blog in this series.

I have written about PLM on two earlier occasions: for the SAP HANA 1.0 SPS 09 release in 2014, when the new tool was introduced, and for the SPS 12 release in 2016, when some significant enhancements were added:

The latest three SPS releases (SAP HANA 2.0 00, 01 and 02) only introduced minor changes.

 

1001 Tasks

Platform lifecycle management for SAP HANA covers all tasks and activities affecting the SAP HANA platform and its constituent components (client, options, plug-ins, etc.). There is a single tool for both installations, updates and post-installation configuration tasks: the SAP HANA database lifecycle management tool, abbreviated to hdblcm, the name of the executable.

The LCM tool is included with the installation media – the ‘DVD’ or full download of the SAP HANA Support Package Stack (SPS) main release – and you run this tool to install the SAP HANA (database) server plus additional components, like the SAP HANA client, the SAP HANA studio, the Application Function Library (AFL) component for the Predictive Application Library (PAL) or Extended Machine Learning (EML), but also options like Dynamic Tiering, Streaming Analytics, or the Accelerator for Adaptive Server Enterprise (ASE).

Apart from providing a single installation experience for the installation of all SAP HANA components, it also makes no difference whether you are installing SAP HANA on a single-host system or on a distributed (multiple-host) system. The same is true for when you are creating a failover cluster with standby hosts.

When you install (or update) the SAP HANA server, a local (resident) version of the installation tool is installed and this resident hdblcm we will then use to perform the post-installation administration tasks. Examples are – but the list is long – adding or removing hosts, renaming the system identifier, configuring the internal network, or registering the SAP HANA server for the System Landscape Directory of SAP NetWeaver (SLD).

Same Interface

The LCM tool is available as a command-line tool and with a graphical interface for X-Windows and web. You can only use the web version for the resident (administration tasks) as it gets deployed, in fact, to the SAP host agent. Both the graphical X-Windows version and the command-line tool accept call options (parameter on the command line), including the parameter to use a response file for automated installations. Typically, you would use the X-Windows (and web) version for one-off actions: perform a single task once.

Commands to launch the SAP HANA Lifecycle Management tool:

# LCM from installation media
/install/51052325/DATA_UNITS/HDB_LCM_LINUX_X86_64/hdblcmgui

# resident LCM
/hana/shared/T01/hdblcm/hdblcmgui

The resident LCM is included in the path of the system /<sapmnt>/<SID> and is kept synchronized with the HANA server with each update.

 

SAP HANA Lifecycle Management – Install or Update

The resident hdblcm version can be executed with the permissions of the SAP HANA operating system administration account <sid>adm but for some activities, like rename or uninstall the system, root privileges are required (as indicated on the screen).

SAP HANA Lifecycle Management – Administration (X-Windows)

From the Web

The web version provides the same functionality as the X-Windows version plus a link to the documentation (Help) and the option to download components from the SAP ONE Support Portal Downloads location and also to upload components to the HANA server.

The URL connects to the SAP Host Agent included with the SAP HANA server installation. In the default configuration, each server has a single host agent with a fixed port for HTTP (1128) and HTTPS (1129). To indicate which system we want to perform lifecycle management software logistics, the SID is added to the URL.

https://<hostname>:1129/lmsl/HDBLCM/<SID>/index.html

To access the web interface for SAP HANA Platform Lifecycle Management, shortcuts (menu) are provided in SAP HANA studio and the SAP HANA cockpit. Both will open the same URL in a new browser window.

SAP HANA Platform Lifecycle Management – Administration (web)

SAP HANA Studio – Platform Lifecycle Management 

SAP HANA Cockpit – Platform Lifecycle Management 

From the Console

The command-line version also provides the same functionality as the X-Windows and web version.

SAP HANA Platform Lifecycle Management – Administration (command-line)

Although the parameters are extensively documented in the SAP HANA Server Installation and Update Guide [Parameter Reference], you can also get the ‘man’ (well, it’s equivalent) from the command line itself, as you would expect.

Below a print screen from the resident hdblcm and the one from the installation media (note the different action= parameters.

Additional (and quite extensive) help is provided once you have selected the action.

To automate installations, you would first generate a template response file with the
–dump_configfile_template=<filename> parameter and subsequently run the installer with the
–configfile=<filename>
option. Automated installations will be the topic of another blog in this series.

hdblcm -h (resident) 

hdblcm -h (installation media) 

hdblcm -h –action=install

 

More LCM Tools

In the very early days of SAP HANA, you had to run a different tool for each of the actions mentioned above: hdbaddhost to add a host, hdbrename to rename the system and hdbuninst to uninstall.

As you can from the listing below, these tools still exist and are, in fact, still performing all of the hard work as they are called by the platform lifecycle management tool, hdblcm.

Running the tools directly on the command-line yourself is not recommended and without the proper parameters may have undesired consequences. However, the log files generated by the tools may return relevant information when troubleshooting.

The exception is when you want to install stand-alone components like the SAP HANA client or SAP HANA studio as the installation media for these components do not include the platform lifecycle management tool (hdblcm) but only the ‘worker’ tools. Run hdbinst (or hdbuninst) on the command line for automated installations and hdbsetup for a one-off installation using the graphical installer.

Note that hdblcm is included both stand-alone and bundled with the SAP HANA server on the installation media. You can run either. The outcome will be the same.

On the first screen, hdblcm will display the detected components for you to install, update, or extract.

hdblcm – Detected Components

 

Please Note

SAP Support has published a number of Knowledge Bases Articles (KBA’s) on the SAP ONE Support portal about SAP HANA platform lifecycle management (component HAN-LM-PLT). Below two notes that provide a good starting point:

 

References

For more information see:

SAP HANA Academy Playlists

SAP Community Blogs

SAP Documentation

Notes

 

Thank you for watching

The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.

For the full library, see SAP HANA Academy Library – by the SAP HANA Academy

For the full list of blogs, see Blog Posts – by the SAP HANA Academy

 

SAP HANA Cockpit 2.0 SP 05 What’s New

Introduction

Earlier this week (January 23, 2018), SAP HANA cockpit 2.0 SP 05 was released-to-customer (RTC).

Below you will find an overview of the new features with reference to the documentation.

 

For the full SAP HANA cockpit playlist on YouTube, see

For the previous version of this blog, see

For a complete list of the SAP HANA cockpit 2.0 What’s New blogs, see

 

Documentation

New features and known issues are documented in

For all SAP HANA cockpit documentation, see

SAP HANA Cockpit SP – Release Notes

 

Software Download

You can download the support pack from Software Downloads on the SAP ONE Support Portal:

SAP Software Downloads: HANA Cockpit 

 

Administration

Improved Cockpit Resource Management

SAP HANA cockpit SP 02 introduced the cockpit user roles Cockpit Administrator, Cockpit Resource Administrator, and Cockpit User to enable separation of duties for cockpit and, as a result a more secure environment.

In SP 05, this has been further enhanced with the roles Cockpit User Administrator and Cockpit Power User. A power user can register a resource but will have to request the resource administrator to add the resource to a resource group and assign its users.

For more information, see

Cockpit Manager – Cockpit Roles

 

Fine Tuning Cockpit Settings

In SP 05, the collection schedule for availability, performance, capacity, and alerts (APCA) statistics is now configurable. Defaults to 60 seconds and the documentation adds that “This should only be performed if necessary.” Additionally, you can also change the number of worker threads for the collection service (defaults to 10). Increasing threads can improve response time but uses more memory.

In Settings, you can now also configure connection timeouts and whether resource groups should be generated automatically for certain system types.

As a reminder, the system type for the SAP HANA database server – Production, Test, Development, Custom – is a configurable parameter, typically set during installation. Systems with system_type=production trigger specific client behavior in SAP HANA cockpit and studio, for example, returning an are-you-sure? warning when executing SQL, etc.

For more information, see

Cockpit Manager > Settings > Data Collection

Cockpit Manager > Settings > Connections

Cockpit Manager > Settings > Display

 

Name that Resource (even offline)

You can now provide a custom name for a resource (or stick to the default database@SID) when registering and/or editing a resource in the Cockpit Manager.

SP 04 introduced registering offline resources. This has now been extended to the import functionality.

Cockpit Manager > Register Resource: Resource Name

 

Stop System

You can now stop (or start) systems directly from the Overall (System) Database Status tile.

For more information, see

Cockpit > Overview > Stop | Start System

 

Change Layers

On the Configuration of System Properties page it is now much easier to change the layer (system, host, database) for a given parameter. The dialog (window) has been improved.

For more information, see

Cockpit > Configuration of System Properties > Change Layer

 

User Management and Security Administration

Cutting Corners: Grant Privileges to User

There is a new page (or app, if you prefer), Assign Privilege, which allows you to directly grant privileges to a user.

The best practice remains to grant privileges to roles and assign roles to users but for those that prefer quick-and-dirty: at your service!

There are links to both Assign Roles and Assign Privileges on the Users page.

For more information, see

Cockpit > Assign Privileges

Cockpit > User > Assign Privileges

 

Filter, Sort, and Group the Audit Table Log

For audit trails with the database as target (not syslog or CSV), log entries are now displayed on the Auditing page. There are a lot of columns (35) that you can display plus options to filter, sort and group.

For more information, see

Cockpit > Auditing > Audit Table Log

Cockpit > Auditing > Audit Table Log > Configure

 

Audit Logging for the Cockpit

To track events for the cockpit itself you can now use the Audit Logs app accesible from the XS Advanced Administration tool.

For more information, see

Audit Logs

 

Backup and Recovery

Backup Configuration

SP 05 adds a page to edit (or view) the backup configuration for each database (Catalog Settings, Log Settings and Data Backup).

For more information, see

Cockpit > Manage Databases > Configure Backup

Backup Configuration

 

Performance Monitoring and Analysis

Memory Analysis

A link (Analyze Memory Statistics) to the Memory Analysis page is now directly accessible from the Memory Usage tile on the Overview page.

Should any out of memory event occur, you can now access the SAP Database Explorer Dump Viewer for the relevant trace files from the Out of Memory Events tab on the Memory Analysis page.

For more information, see

Cockpit > Overview: Memory Usage

Cockpit > Memory Analysis

 

Monitor Volumes and Reclaim Space

SP 05 adds a Disk Volume Monitor page, where you view disk statistics (per host, tenant, type (data or log), service and volume ID.

Links to Reclaim Space, Backup and configure System Replication are included.

For more information, see

Cockpit > Disk Volume Monitor

Cockpit > Disk Volume Monitor: Reclaim Space

 

Capture and Replay – Backup, Thresholds and Syncs

Several enhancements have been made to Capture and Replay. It is now very easy to make that recommended full backup after a capture: include it with the capture or trigger it from the Monitor Capture page.

To avoid unintended and misleading classifications in the replay report for statements that display minor runtime differences, you can now set a threshold value during the preprocessing step.

It is now also possible to synchronize the replay with an existing database backup on the Replay Configuration page.

For more information, see

Cockpit > Capture and Replay > Configure New Capture

Cockpit > Replay Workload > Replay Management > Replay Configuration

 

Performance Monitor – Presets and Comparisons

Presets in the Performance Monitor make it easier to select any of the most common time frames.

Additionally, you can now easily compare KPI performance with Performance Comparison.

For more information, see

Cockpit > Performance Monitor: Preset

Cockpit > Performance Monitor > Performance Comparison

 

Workload Analyzer

Several enhancements have been made to the Workload Analyzer Based on Thread Samples page:

  • The page now opens on a chart displaying top SQL statements by lock time.
  • You can choose different operation periods to be displayed, and choose an entry on the chart to have more information displayed below along with the full SQL statement. Once a bar is selected, the corresponding information will be added to the filter on the analysis page.
  • You can navigate to the original analysis page by clicking Analyze in the footer bar.

For more information, see

Cockpit > Workload Analysis 

 

Threads – Filter, Sort, and Group

Several enhancements have been made to the Threads page:

  • Filter threads by host, service, and thread type
  • Select the sorting parameters of the threads with the Group and Sort option
  • Get the Call Stack information for the selected thread.
  • Define the columns by choosing parameters that will be displayed in the table.

For more information, see

Cockpit > Threads

Workload Admission Control Settings

Admission Control was introduced in initial release of SAP HANA cockpit 2.0. New for SP 05 is the configuration page. Previously, admission control was only configurable through SQL.

For more information, see

Cockpit > Manage Workload Classes 

Cockpit > Manage Workload Classes > Manage Admission Control

 

Workload Classes

You can now import (and export) Workload classes for exchange between systems.

For more information, see

The creation of workload class mappings has been enhanced with application component name and application component type.

For more information, see

Cockpit > Manage Workload Classes > Import

Cockpit > Manage Workload Classes > Create Class

 

Statements Monitor and Expensive Statements

It is now possible to set up or modify the workload class of a statement on the Statements Monitor and Expensive Statements page.

For more information, see

 

SAP HANA Database Explorer

Trace Configuration

In SP 05, trace configuration has been enhanced. You can now configure tracing for the kernel profiler to analyze performance issues with systems on which third-party software cannot be installed, or for parts of the database that are not accessible by the performance trace.

Additionally, you can now also configure tracing for expensive statements whose execution time exceeded a configured threshold.

Statement Library

Also new in SP 05 is the statement library which contains a number of default system statements but also allows you to add SQL statements of your own.

For more information, see

SAP HANA Database Explorer > Trace Configuration

SAP HANA Database Explorer > Trace Configuration > Kernel Profiler

SAP HANA Database Explorer > Trace Configuration > Expensive Statement Trace

SAP HANA Database Explorer > Add to Statement Library

SAP HANA Database Explorer: Statement Library

SQL Analyzer

Several enhancements have been made to the SQL Analyzer:

  • View the details of table accesses performed (Table Accesses List tab),
  • Get aggregated information for each column and choose aggregator functions, filter and sort the results, and customize columns.
  • Re-execute the SQL query with parameter changes.
  • Open SQL Analyzer through the Statement Hints page.>
  • Move to Operator List after selecting the Tables Used tile in Overview.
  • Split the areas between the operators and the timeline chart.

Additionally, the Plan Graph now displays critical paths.

For more information, see

Cockpit > Monitor Expensive Statements > SQL Analyzer: Input Parameters

Cockpit > Monitor Expensive Statements > SQL Analyzer: Operator List

Cockpit > Manage Statement Hints: Add Statement Hint

High Availability and Scalability

Reinitializing the Secondary System

With SP 05 it is now possible to re-register a stopped secondary system. For example, in case full data shipping is needed or when you want to change the operation mode.

For more information, see

 

System Health

On the System Health page, by selecting specific system health information, you can now drill down to details on specific KPIs displayed in the Performance Monitor and the Workload Analyzer.

For more information, see

 

Documentation

For more information, see:

SAP Community Blogs

SAP Help Portal

SAP Notes

 

Thank you for watching

The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.

For the full library, see SAP HANA Academy Library – by the SAP HANA Academy

For the full list of blogs, see Blog Posts – by the SAP HANA Academy

 

SAP HANA 2.0 XS Advanced Installation

Introduction

Recently, we have updated a number of SAP HANA Academy tutorial videos about installing SAP HANA components:

In this blog, I will provide some references and background information about the SAP HANA XS Advanced (XSA) runtime.

This blog is part of a series:

 

SAP HANA Academy – SAP HANA Installation and Update (YouTube Playlist)

 

Tutorial Video

In this tutorial video, we cover where to download the latest version of both the SAP HANA XS Advanced runtime and the different XS Advanced components; how to perform an installation of the runtime together with SAP HANA database server; and how to perform an update of a server installation to add the XSA runtime component using the SAP HANA database lifecycle management tool (hdblcm) in graphical, web, and command-line mode; how to perform an unattended installation of the XSA runtime with hdblcm in batch mode and the use of a response file.

SAP HANA Academy – XS Advanced

 

SAP HANA XS Advanced Model

Whereas installing the SAP HANA (database) server maybe takes 15 minutes on a bad day, installing the SAP HANA XSA runtime will take a good 90 minutes. To understand why this is the case, it is good to have a basic understanding of the XSA architecture.

For a gentle introduction, see

Unlike the xsengine process of XS classic, the XS Advanced runtime is not built-in/embedded into the SAP HANA database server and needs to be installed separately.

The XSA runtime comprises four operating system processes:

  • xsconstroller (Controller, FileSystem Broker, Platform Router)
  • xsexecagent (Execution Agent)
  • diserver (Deployment Infrastructure Server)
  • xsuaaserver (User Account and Authentication (UAA) service, UAA broker, HDI broker)

The runtime has its own role (xs_worker) and can be included with the SAP HANA server on a single-host installation, on a distributed system for load balancing, and on a dedicated host in a multi-host environment, including as a standby system (xs_standby role) for high availability configurations:

 

XS Advanced system concepts

 

The images below are from the Developer and Administration/Security guides (same paragraph) and illustrate the functionality which the different services provide.

For more information about the architecture, see

XS Advanced system architecture

 

Technical System Landscape of XS Advanced Application Server

 

Software Downloads

You can download the latest version of the XS Advanced runtime and the XSA components from the SAP ONE Support Portal. This works exactly the same as for the other SAP HANA components.

Navigation path: H > SAP HANA PLATFORM EDITION > SAP HANA PLATFORM EDITION 2.0: SUPPORT PACKAGES AND PATCHES

The table below lists the XSA components for SAP HANA Platform Edition 2.0

Software Component Support Package Patches Note
XS_ADVANCED_RUNTIME XS RUNTIME 1 2582204
XS_ADVANCED_RUNTIME SAP EXTENDED APP SERVICES 1 2582204
XS_MONITORING XS MONITORING 1 2465860
XS_SERVICES XS SERVICES 1 2465860
XS_JAVA XS JAVA 1 2465860
XS_JAVASCRIPT XS JAVASCRIPT 1 2465860
XSAC_ALM_PI_UI XSAC_ALM_PRODUCT_INSTALLER_UI1 2495800
XSAC_XSA_COCKPIT XSA COCKPIT 1 2465860
XSAC_SAP_WEB_IDE SAP WEB IDE 2 2457320
XSAC_HRTT SAP HANA RUNTIME TOOLS 2.0 2373065
XSAC_FILE_PROC XSAC FILEPROCESSOR 1.0 2419428
XSAC_PORTAL_SERV XSAC_PORTAL_SERVICES 1.0 2538943
XSAC_UI5_FESV2 SAPUI5 FESV2 XSA 1 2451647
XSAC_UI5_FESV3 SAPUI5 FESV3 XSA 1 2458437
XSAC_XMLA_INT XSAC XMLA INTERFACE FOR HANA 1 2494696
XSAC_SHINE SAP HANA DEMO MODEL ADV. 1 2239095
XSAC_MIGRATION XSAC MIGRATION 1 2493252
XS_GERRIT XS GERRIT 2 2503815

 

SAP Software Downloads – Support Packages and Patches

 

The XSA runtime and XSA components are included in the SAP HANA 2.0 platform edition installation media.

Most components are included in the XSA_CONTENT_10 directory but not the SAP Web IDE for SAP HANA, the migration toolkit, and the Database Explorer (Runtime Tools: HRTT).

The XS clients for Windows, Linux and macOS are provided as compressed zip files in the XSA_CLIENT_10 directory. The installation steps are documented in

 

The XSA runtime directory contains the SAP HANA lifecycle management tools hdbsetup (graphical), hdbinst, hdbsetup and hdbuninst but these utilities should not be executed directly. On the SAP HANA server, always install components using the SAP HANA Database Lifecycle Manager (hdblcm).

SAP HANA 2.0 platform edition – 51052325 extracted

 

SAP HANA XS Advanced Runtime Installation

To install the XSA runtime and the different XSA components, you can choose to run the SAP HANA Lifecycle Management tool in graphical (Windows), web or command-line mode.

For the web version, you can start the tool from the SAP HANA cockpit, SAP HANA studio, or directly using the SAP host agent URL [ https://<host>:1129/lmsl/HDBLCM/<SID>/index.html ]

SAP HANA Platform Lifecycle Management – URL

Start the installation from the Install or Update Additional Components tool.

The first step is to indicate to the tool where the installation media is located using the Add Software Locations button.

SAP HANA Lifecycle Management – 1. Add Software Locations

Next, select the SAP HANA XS Advanced Runtime component for installation.

SAP HANA Lifecycle Management – 2. Select Components

In step 3, you can add additional hosts in case you want to create a distributed system and define the host role for the XSA runtime (xs-worker or xs_standby). You will be prompted if you want to assign the XS runtime roles to the hosts with database roles (see above, section XSA system concepts).

SAP HANA Lifecycle Management – 3. Additional Hosts Properties

In step 4, you need to provide the passwords for the operating system administration account <sid>adm and for the system and tenant database SYSTEM accounts. This is not XSA specific but related to the SAP HANA server.

In step 10 (steps 6, 7, 8, and 9 are for Streaming, Dynamic Tiering, Accelerator and Remote Data Sync – when selected), we get to the screen where we can define the XS Advanced Runtime parameters.

For more information about each of the parameters, see

For more information about the organization and customer space name (and the impact of running applications in customer spaces with separate operating system users), see

For more information about routing mode and domain names, see

SAP HANA Lifecycle Management – 10. Configure XS Advanced Runtime

When the checkbox ‘Run Applications in Customer Space with Separate OS User’ is selected, you are prompted to set the operating system user ID for the SAP and customer space users (Linux). In a distributed (multi-host) environment, these need to be the same.

SAP HANA Lifecycle Management – 11. Configure XS Advanced Space OS User Properties

In the last step, step 13, you can select the XSA components that you want install together with the runtime. Note that not all components are selected by default.

You can run the SAP HANA Lifecycle Management tool again to install (or update) additional XSA components at a later stage. Alternatively, you can use the XS client command ‘xs install’ to add components:

SAP HANA Lifecycle Management – 12. Choose XS Advanced Components to be Installed

The last screen lists all selections made for review and confirmation.

SAP HANA Lifecycle Management – 14. Review and Confirm

Install using Windows

To run the SAP HANA Lifecycle Management tool in graphical mode, just run the hdblcmgui command from the installation media from the Lifecycle Management directory (HDB_LCM_LINUX_X86_64). To run the tool in graphical mode, an X-Windows environment needs have been installed and configured. This might be a bit of an issue as typically the SAP HANA server will have a minimal installation without X-Windows environment.

Running HDB_LCM_LINUX_X86_64/hdblcmgui

In the print screens below, you can see that the dialogs in the version are exactly the same as for the web version. The same is true for the command-line.

SAP HANA Lifecycle Management (hdblcmgui) – Detected Software Components

SAP HANA Lifecycle Management (hdblcmgui) – Add Hosts

SAP HANA Lifecycle Management (hdblcmgui) – XS Advanced Runtime Properties

Unattended Installation with Response File

To automate SAP HANA XS Advanced runtime installations (or XSA component updates), you can run the SAP HANA Lifecycle Management tool in batch mode with a response file.

Installation automation is the topic of another blog in this series, so I will just highlight the required steps here.

First, create a template file with the hdblcm parameter ‘–dump_configfile_template=<filename>’

SAP HANA Lifecycle Management (hdblcm) – Create Config File

Next, you need to edit the template file to provide the required parameters. You use the online help from hdblcm for the specific syntax of the parameters. Alternatively, of course, you can also look them up in the documentation:

Most parameters will have a default value.

SAP HANA Lifecycle Management (hdblcm) – configfile 

Once the response file (template file) and password file have been prepared, we can run the hdblcm command in unattended mode (–batch or -b) specifying the action, the template file and to read the password file from STDIN.

SAP HANA Lifecycle Management (hdblcm) – hdblcm in batch mode

 

Installing SAP HANA XS Advanced Runtime…

The installer first extracts (unzip) the different components and proceeds to stop the SAP HANA system after which the runtime will be installed (Installing package…) and the system started again. This is the system downtime phase and takes about a minute.

Next, we can see that the SAP HANA XS runtime processes are started: hdbxscontroller, hdbxsexecagent, and hdbxsuaaserver.

Installing SAP HANA XS Advanced Runtime…

With the runtime processes started, initial content is loaded and the spaces are created.

Loading initial content

Next, the different services and applications are created that support the infrastructure. This phase ends with the API (URL) of XS Controler, with default HTTPS port 3<instance_number>30 (for port-based routing). This is the API endpoint to use with the XS client.

XS Controller API End Point

In the next phase, the XSA components (Cockpit, SAP UI5, etc.) are installed. Depending on the number of components selected, this will take some time.

The installer exits with an URL for feedback and the location of the log files, should any issue have occurred.

SAP HANA Database components updated

Apps!

Once the runtime is up and running and the XSA components installed, we can connect to the controller with the XS client.

In the print screen below, the XS client included with the SAP HANA XS runtime installation is used. You can also install the XS client on a Microsoft Windows, Linux, or Apple macOS computer. This topic will be discussed in a subsequent blog in this series.

To connect, you will need to provide the API_URL, which refers to the XS Controller API, together with the administration user you created during the installation in step 10 Configure XS Advanced Runtime.

xs login

With the ‘xs apps’ command, we can then list the apps running in space “SAP”, their status, and urls.

xs apps

You can use the URLs to access the different XSA applications in a browser. Below the xsa-admin application, the web interface for XS Advanced Administration.

XS Advanced Administration

References

For more information see:

SAP HANA Academy Playlists

SAP Downloads

SAP Documentation

SAP Blogs

Notes

 

Thank you for watching

The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.

For the full library, see SAP HANA Academy Library – by the SAP HANA Academy

For the full list of blogs, see Blog Posts – by the SAP HANA Academy