Skip to content

Posts from the ‘SAP HANA Academy’ Category

SAP HANA 2.0 SPS 03 What’s New: Security – by the SAP HANA Academy

Introduction

In the upcoming weeks, we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced in SAP HANA 2.0 Support Package Stack (SPS) 03.

The topic of this blog is SAP HANA Database Security.

For the previous versions of this blog, see

For the full SAP HANA 2.0 SPS 03 blog list, see

For the blogs from Product Management on the topic, see

For an update about the documentation, see

What’s New?

SAP HANA Security Playlist

On the SAP HANA Academy, there is a full playlist covering all aspects of security

SAP HANA Cockpit

SAP HANA cockpit support package 06 has a number of new and enhanced features for user and role management and auditing.

For more information, see

Data Anonymization

As of SPS 03, SAP HANA provides native support for data anonymization. This allows you to gain statistically valid insights from data containing personal or sensitive information while protecting the privacy of individuals.

For the documentation, see

Shared Business Authorizations in SAP HANA

SAP S/4 HANA and other ABAP-based SAP applications use authorization objects to control access.  As of SPS 03, you can now create analytic privileges in SAP HANA that leverage these ABAP authorization objects.

The new built-in procedure SYS.GENERATE_STRUCTURED_PRIVILEGE_PFCG_CONDITION connects both worlds. PFCG is the role maintenance transaction for the Profile Generator.

CALL SYS.GENERATE_STRUCTURED_PRIVILEGE_PFCG_CONDITION( 
'A_TEST_SCHEMA',
'CHECKID1',
'{"data":
    {
        "CHECKID1":
        {
            "authobj":"OBJ1",
            "filter":[{"key":"ACTVT","valueList":["03"]}],
            "mappings":[{"fieldName":"SACMTSOID", "mappedName":"SO_ID"},
        {"fieldName":"SACMTSOLCS", "mappedName":"LIFECYCLE_STATUS"}]
        }
    }
}',
?)

For the documentation, see

User Group-Specific Password Policies

User groups were introduced in the previous release, SPS 02, see

As of SPS 03 this concept has been further enhanced and you can now configure a customized password policy for user groups.

For the documentation, see

LDAP Authentication with Automatic User Creation

As of SPS 03, SAP HANA can now automatically create database accounts for LDAP users and map their LDAP roles. This can significantly reduce complexity and cost for maintaining users and authorizations in larger system landscapes.

For this to work, the LDAP provider needs to be enabled for user creation and the user needs to be a member of at least one LDAP/HANA mapped group.

CREATE LDAP PROVIDER my_ldap_provider [...]
 ENABLE USER CREATION FOR LDAP
 [USER TYPE { STANDARD | RESTRICTED }]

For the documentation, see

Data Encryption

Password hash algorithm

Database user passwords are now stored in hashed and salted form using PBKDF2 (Password-Based Key Derivation Function 2) using the SHA-256 secure hash algorithm and 15,000 iterations.

If you are not at home in the jargon of cryptography, you might find this article helpful

Encryption configuration in tenant databases

The default status of data-at-rest encryption services in tenant databases is no longer inherited from the system database but is now controlled in the system database with parameters in the new database_initial_encryption section of the global.ini configuration file.

For the documentation, see

Client-side Data Encryption

With client-side data encryption, you can encrypt columns using an encryption key accessible only by the client, which means that column data is encrypted and decrypted only on the client.

New privileges and SQL statements have been added to support client-side encryption.

For the documentation, see

Data Masking

In addition to views, you can now also mask data in tables.

For the documentation, see

Auditing

Auditing for XSA

Auditing for XS advanced has been integrated into the SAP HANA auditing framework.

The XSA Audit Log viewer now displays a deprecation message.

The XSA_AUDIT_LOG view in the Database Explorer.

For the documentation, see

New Auditing Actions

The following new auditing actions have been added:

  • CREATE | DROP AGENT GROUP
  • PERSONAL DATA ACCESS
  • PERSONAL DATA MODIFICATION
  • CONFIGURATION CHANGE
  • SECURITY EVENT

For the documentation, see

Authorization

Any user with the system privilege ROLE ADMIN can now revoke catalog roles granted by another user.

For the recommendations, see

A user can now grant all currently available privileges on a schema by granting the ALL PRIVILEGES object privilege.

For the documentation, see

References

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 SPS 03 What’s New: High Availability – by the SAP HANA Academy

Introduction

In the upcoming weeks, we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA 2.0 Support Package Stack (SPS) 03.

The topic of this blog is high availability.

For the previous versions of this blog, see

For the full SAP HANA 2.0 SPS 03 blog list, see

What’s New?

SAP HANA System Replication Playlist

On the SAP HANA Academy, there is a full playlist covering all aspects of system replication:

SAP HANA Academy – SAP HANA System Replication playlist

SAP HANA System Replication

Multitarget System Replication

As of SPS 03, the primary system can now replicate data changes to more than one secondary system. Different disaster recovery scenarios apply, depending on whether just the primary or the whole data center experiences a failure.

For the documentation, see

Invisible Takeover

In a regular takeover scenario, all connections to the clients on the primary system are lost and there is no awareness of any previous client connection on the secondary host.

SPS 03 introduces invisible takeovers, which enables the client to keep the connections to the primary system and to restore its sessions on the secondary system. However, only read transactions are supported. When the ongoing transaction is a write transaction, the session won’t be recovered.

his is configured through the use of the enable_session_recovery parameter.

For the documentation, see

Secondary Time Travel

It is now possible to start the secondary system in online mode on a previous point in time. Secondary time travel can be used to quickly access again data, which was deleted in the original system.

Time travel on the secondary host is only possible in the operation modes logreplay or logreplay_readaccess.

The retention time is set with the timetravel_max_retention_time parameter in global.ini, section system_replication. For time travel to work, log and snapshots are kept online in the data area and you need to set the parameter carefully to avoid log full or disk full situations.

hdbnsutil -sr_timetravel --startTime=<startTime> 
[--callTakeoverHooks=on|off].

For the documentation, see

Alert 106 – ASYNC replication in-memory buffer overflow

Alert 106 is raised when the local in-memory buffer in the ASYNC replication mode is running full indicating possible network issues with the connection to the secondary system.

For the documentation, see

Host Auto-Failover Parameters

Host Auto-Failover is a built-in, fully automated high availability solution for recovering from the failure of an SAP HANA host, introduced in SAP HANA 1.0 SPS 09.

SPS 03 adds two new parameters for host auto-failover.

  • enable_master_failover – defaults to true; when set to false the check of the nameserver master candidates is disabled
  • startup_error_restart_retries – defaults to 4; defines the number of retries if a service fails in the startup procedure

For the documentation, see

getTakeoverRecommendation.py

The getTakeoverRecommendation.py Python script evaluates the status of the primary system and of the system replication to help decide if a takeover is justified. It is part of a number of Python utility scripts in the $DIR_INSTANCE/exe/python_support directory.

For the documentation, see

References

SAP HANA Documentation

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 SPS 03 What’s New: System Administration – by the SAP HANA Academy

Introduction

In the upcoming weeks, we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA 2.0 Support Package Stack (SPS) 03.

The topic of this blog is system administration.

For the previous versions of this blog, see

For the full SAP HANA 2.0 SPS 03 blog list, see

What’s New?

SAP HANA Administration Playlist

On the SAP HANA Academy, there is a full playlist on the topic of SAP HANA Administration.

Managing Tenant Databases

Fallback Snapshot

A fallback snapshot allows you to quickly and easily return back to a previous database state, for example, to reset a tenant database used for training.

They cannot be used for the system database and you can only create one at a time.

For a demonstration, see the video tutorial:

To create one interactively, you can use Manage Databases in SAP HANA cockpit and use the same view to reset the database or delete the snapshot.

SAP HANA cockpit > Manage Databases: Create Fallback Snapshot

SAP HANA cockpit > Manage Databases: Reset to Fallback Snapshot

For automation, use SQL:

-- create
ALTER DATABASE <database name> CREATE FALLBACK SNAPSHOT;
-- reset to snapshot
ALTER SYSTEM START DATABASE <database name> FROM FALLBACK SNAPSHOT;
-- delete
ALTER DATABASE <database name> DROP FALLBACK SNAPSHOT;

The system view M_SNAPSHOTS lists the snapshots (but you can only create one at a time, per tenant).

For the documentation, see

Command Line Tool: hdbmdcutil

In the unlikely event, that the persistence for your system database is damaged ánd you do not have a backup of the system database (both conditions should apply), you can now reset the system database using the new hdbmdcutil tool.

A reset of the system database is not without consequences, as any changes made to the system database are lost (license, imported delivery units or MTARs, etc.), which in particular affects the XS Advanced environment. However, resetting the system database is very quick and avoids long downtime as compared to a full new installation with a move of all associated tenant databases.

For a demonstration, see the video tutorial:

For the documentation, see

Tenant Service Port Change

You can now change the TCP port (or host) of the different services (indexserver, scriptserver, xsengine, dpserver).

ALTER DATABASE <database_name> ALTER 'scriptserver' 
AT '<host>:30303' TO '<host>:30340'

For the documentation, see

System Administration

Parameter Tracking

As of SPS 03, changes to configuration values are now logged by default with the option to add the reason for the change as a comment. This feature maintains a history of changes to configuration values including details of the time the change was made, the username, the current and previous values in the view M_INIFILE_CONTENT_HISTORY.

For the documentation, see

Persistent Memory

I already have mentioned it on my blog about SAP HANA 2.0 SPS 03 What’s New: Installation and Update: as of SPS 03, persistent memory (non-volatile RAM) is supported a storage type.

Persistent storage works the same way as regular memory and would be used for main data fragments of the column store where approximately 90% of the data of a table is held. The delta area of the column store table remains is DRAM memory.

The advantage of using persistent memory is found in the accelerated start-up times because much less data needs to be loaded into memory and this will minimize system downtime.

Persistent memory can be enabled at the column-, partition-, table-, or database-level (default), which allows for a great deal of flexibility. Below some examples from the documentation. At the time of writing, the persistent memory technology is not yet available for SAP HANA so we could not run any tests or make any tutorial video yet on this topic. When it comes available we will certainly revisit this topic.

CREATE COLUMN TABLE PMTABLE (C1 INT, C2 VARCHAR (10)) 
PERSISTENT MEMORY ON;

CREATE COLUMN TABLE PMTABLE (C1 INT) 
  PARTITION BY RANGE (C1) (
    PARTITION ‘0’ <= VALUES < ’10’ PERSISTENT MEMORY ON, 
    PARTITION OTHERS PERSISTENT MEMORY OFF);

For the documentation, see

Data Volumes Partitions

As of SPS 03, you can now partition the data volumes of the database engine (indexserver). As an in-memory database, most operations will not benefit much from striped volumes. However, for example, startup times – when all column tables marked for load need to be read from disk – can be improved using data volume partitions.

Below an example of the SQL to manage partitions from the documentation.

ALTER SYSTEM ALTER DATAVOLUME ADD PARTITION;

Additionally, two new views have been added to keep score:

  • M_DATA_VOLUME_STATISTICS
  • M_DATA_VOLUME_PARTITION_STATISTICS

For the documentation, see

Monitoring

Changes made to Alert Thresholds

A history of changes made to alert thresholds is now maintained and can be retrieved from this system view: STATISTICS_ALERT_THRESHOLDS_HISTORY

For the documentation, see

New Alerts

Nine new alerts have been introduced (105-110, 117, 127, 128).

For the documentation, see

Managing Tables

Column Table as Default Table Type

As of SPS 03, if not specified, new tables will be created as column tables. Previously, a row table would have been created.

Heterogeneous Partitioning

There are different ways how you can partition a large table. Partitioning is typically used on a distributed system and mostly only concern very large tables. Partitioning types are range, hash, or round-robin, and this allows you, for example, to implement load balancing, maybe overcome the size limitation of column-store tables (a mere 2 billion rows), parallelize operations, improve delta merges, and for other reasons, as documented in the Administration Guide.

To overcome the limitations of hash or range partitioning, you can implement multi-level partitioning, which also makes it possible to partition by a column that is not part of the primary key.

As of SPS 03, we can now also implement heterogeneous partitioning which allows for a more flexible partitioning strategy and even includes the use of extended storage (Dynamic Tiering). Below a few examples from the documentation.

The keyword SUBPARTITION BY indicates that we are implementing heterogeneous partitioning.

Using AT LOCATION, to specify the host where the partition should reside, here a Dynamic Tiering host using extended storage.

The USING EXTENDED STORAGE clause assigns the storage type to a partition.

For the documentation, see

System-Versioned Tables

In the very early days of SAP HANA, one of the advantages explained for the insert-only approach for columnar tables is that it would allow for time travel. In the documentation, this is referred to as history tables.

SPS 03 now introduces system-versioned tables and this will eventually replace the existing history tables feature. With system-versioned tables, you can track changes on column store tables by capturing the validity period of each record.

System-versioned tables are part of the SQL standard and always consist of two physical tables: the main table of records that are currently valid, and a corresponding history table of archived records.

Details of system-versioned tables and their corresponding history table are available in the view SYS.TEMPORAL_TABLES.

For the documentation, see

Table Redistribution

As of SPS 03, you can now perform table redistribution from the command line with new configuration options and a series of weighting parameters to influence the priorities of the redistribution. One of these options is to apply the configuration only to your current session, which allows you to test redistribution options by repeatedly generating, reviewing, and optimizing the plan before it is finally executed.

The syntax for these commands is:

  • CALL REORG_GENERATE(<algorithm integer>, <optional parameter string>);
  • CALL REORG_EXECUTE(<plan_id>)

Examples of algorithm integer are:

  • 1 = Add server
    • SCHEMA_NAME
    • TABLE_NAME
    • GROUP_NAME
    • GROUP_TYPE
    • GROUP_SUBTYPE
    • RECALC
    • NO_PLAN
  • 6 = Balance landscape
    • SCHEMA_NAME
    • TABLE_NAME
    • GROUP_NAME
    • GROUP_TYPE
    • GROUP_SUBTYPE
    • RECALC
    • NO_PLAN
    • NO_SPLIT
    • SCOPE
  • 7 = Check number of partitions
  • 14 = Check table placement
    • LEAVE_UNCHANGED_UNTOUCHED
    • KEEP_VALID
    • NO_SPLIT
  • 15 = Rerun plan
  • 16 = Housekeeping
    • OPTIMIZE_COMPRESSION
    • DEFRAG
    • LOAD_TABLE
    • MERGE_DELTA
    • ALL
CALL REORG_GENERATE(1, 'SCHEMA_NAME => SAPBWP')
CALL REORG_GENERATE(6, 'SCOPE=>FILLED,NOLOB')

For information about the table distribution operations, you can query the system views

  • REORG_OVERVIEW
  • REORG_STEPS – details of the individual steps of each plan.
  • REORG_PLAN – last table redistribution plan generated with this database connection
  • REORG_PLAN_INFOS – details of the last generated plan

For the documentation, see

Table Consistency Check

Table consistency check has been around for some time (the first SAP Note on this topic goes back to 2012) but SPS 03 has added a couple of new configuration parameters for runtime management of the job defined in the indexserver.ini system parameter file.

For the documentation, see

SAP HANA Troubleshooting and Performance Analysis

Workload Management

You can now set a timeout values for queued jobs (admission control) and a statement timeout value for workload classes (in a workload class or as a configuration parameter).

SQL Plan Stability

SQL Plan Stability allows you to protect the performance of queries by capturing query plans in a source system and reusing them in a target system to regenerate the original query plan. You can use this feature, for example, when upgrading from SAP HANA 1.0 to SAP HANA 2.0.

ALTER SYSTEM START CAPTURE ABSTRACT SQL PLAN WITH SQL PLAN CACHE;
ALTER SYSTEM ENABLE ABSTRACT SQL PLAN FOR ALL;

For the documentation, see

ESX and HEX

Not new to SPS 03 but mentioned in the SPS 03 What’s New guide, so repeated here for completeness sake. As documented,

Starting from HANA 2 SPS 02, two new processing engines to execute SQL queries are being phased into SAP HANA: the Extended SQL Executor (ESX), and the HANA Execution Engine (HEX). The functionality of the product remains the same but these engines offer better performance.

For the documentation, see

Security Administration – Managing Data Encryption

Client-side Data Encryption

With client-side data encryption, you can encrypt columns using an encryption key accessible only by the client, which means that column data is encrypted and decrypted only on the client.

New privileges and SQL statements have been added to support client-side encryption.

For the documentation, see

SAP HANA HDBSQL

Options

Three new options have been added to the SAP HANA Database interactive terminal (hdbsql)

  • -strictSeparatorLine
  • -printoutput
  • \read

For the documentation, see

 

References

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 Cockpit 2.0 SP 06 What’s New – by the SAP HANA Academy

Introduction

In the upcoming days and weeks, we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA 2.0 SPS 03.

The topic of this blog is SAP HANA cockpit 2.0 SP 06, released together with SAP HANA 2.0 SPS 03.

For the previous version of this cockpit What’s New blog, see

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

For the complete list of SAP HANA 2.0 SPS 03 What’s New blogs, see

For the Getting Started with SAP HANA cockpit 2.0 blog, see

For the full SAP HANA cockpit playlist on YouTube, see

Documentation

New features and known issues are documented in

For all SAP HANA cockpit documentation, see

 

SAP HANA Cockpit SP – Release Notes

SAP HANA XS Advanced Cockpit

SAP HANA Platform 2.0 SPS 03 introduces the new and enhanced version of SAP HANA XS Advanced Administration tool called SAP HANA XS Advanced Cockpit.

For an overview, see the next tutorial video:

User Management and Security Administration

Data Anonymization Views

As of SPS 03, SAP HANA provides native support for data anonymization. This allows you to gain statistically valid insights from data containing personal or sensitive information while protecting the privacy of individuals.

How this works is explained by Sinéad:

As of SP06, you can get a list of all the calculation views that have one or more anonymization node views configured using the link View anonymization report under Security Related Links.

For the documentation, see

Manage SAML identity providers

A new page (app) has been added to the SAP HANA cockpit where you can add and manage the SAML identify providers for your SAP HANA system.

For the documentation, see

SAP HANA Cockpit – Overview

SAP HANA Cockpit – Configure SAML Identity Providers

SAP HANA Cockpit – New User

Administration and Monitoring

Table Redistribution

On a distributed or scale-out system, the location of tables and table partitions might affect the performance of a query. For this reason, at times you may need to optimize the redistribute of tables or table partitions. Similarly, when adding or removing hosts on a distributed system, you also typically need to perform table redistribution operations.

To facilitate table distribution, as of SP 06, you can now view and save current table distributions to a plan, which can be restored when needed. You can also automatically generate optimzed distribution plans.

For the documentation, see

Memory Analysis – Open In

You can now navigate directly from the Memory Analysis page to the Performance Monitor or Workload Analysis, and from there to other apps or pages. Previously, you had to first return to the Overview page. Open In navigation aides make it easier to investigate issues without distraction.

For the documentation, see

SAP HANA Cockpit – Memory Analysis

SAP HANA Cockpit – Performance Monitor

Required Privileges Documentation

The authorizations needed for monitoring and administration in the SAP HANA cockpit are now documented.

For the documentation, see

SAP HANA Database Explorer

Whereas for the earlier versions of the SAP Web IDE for SAP HANA and the SAP HANA Database Explorer the focus was on achieving feature parity with the SAP HANA 1.0 studio tool, as of SPS 02 and more specifically SPS 03, they clearly go beyond to what studio had to offer with a very rich set of features to support data modeling and native development for SAP HANA.

Background Activities with Monitor

Two options have been added to the Run command for SQL statements:

  • Run as Background Activity
  • Run on Multiple Databases

On the right pane, you can access the Background Activities Monitor to view progress and result of the statement.

SQLScript Code Analyzer

You can now analyze a procedure or function written in SQLScript to search for patterns indicating problems in code quality, security or performance. Choose the Analyze SQLScript Code option from the context menu of a database, schema, procedure, or function.

Catalog Browser

In the catalog browser now displays both Graph Workspaces and Table Types, and a right-click on a  Graph Workspaces opens a new editor that shows the properties of the graph workspace and allows you to apply filters and algorithms to your graph workspace.

For an introduction, watch Philip’s Getting Started, below.

For the full story, see his blog

For the documentation, see

Debug Logging and Remove User Data

Under preferences, a new section for Database Explorer has been added where we can enable debug logging and remove user data. Debug logging needs to be confirmed informing the user about  data protection and privacy regulations impact, and there is a visual indicator (recording) that reminds the user about debug logging being enabled.

Remote Source

You can now create remote sources in the database explorer and create virtual objects from those remote sources.

For the documentation, see

SQL Debugger

All debuggers in the SAP WEb IDE, Node.js, Java, SQLScript, now have a common look and feel.

Data Preview Hierarchies

The Data Preview editor for dimension calculation views and CUBE calculation views now contains a Hierarchies tab that shows hierarchies and measures details if they are available for the view.

Backup and Recovery

Recover SAP HANA 1.0

With SAP HANA cockpit 2.0 SP 06, you can restore both SAP HANA 2.0 and 1.0 (SPS 12) databases. Before, only 2.0 databases could be restored using cockpit.

For the documentation, see

References

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 SPS 03 What’s New: Installation and Update – by the SAP HANA Academy

Introduction

In the upcoming weeks, we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA 2.0 SPS 03.

The topic of this blog is Installation and Update.

For the previous versions of this blog, see

For the full SAP HANA 2.0 SPS 03 blog list, see

Tutorial Video

What’s New?

Platform Lifecycle Management (PLM) for SAP HANA 2.0 is a mature and stable technology which has not changed much over the last four support package stacks.

For SPS 03, support for persistent memory has been added and software authenticity verification is now standard included. To support this, new installation parameters have been added. Further, there have been some usability enhancements.

Software Authenticity Verification

Secure-by-design and secure-by-default are important SAP software development standards. As of SPS 03, software authenticity verification is executed by default by the SAP HANA database lifecycle management tool (hdblcm) for any (downloaded) component.

hdblcmweb > Update System Components

hdblcmweb > Add Components > Advanced Parameters Configuration

For the documentation, see

Support for Persistent Memory

As of SPS 03, SAP HANA 2.0 supports persistent memory, also referenced as non-volatile RAM. This storage type requires a specific file system that supports DAX (Direct Access).

At the time of writing, the technology is not available yet but the key performance benefit will be system downtime minimization. Persistent memory allows you to keep the main storage of the column tables loaded into memory even when power is off. In case of a hard stop (power off, system crash, or user error), startup time will be considerably reduced.

You can enable persistent storage for the database as a whole or for specific column tables, column partitions, or even individuals columns – so there is a high degree of flexibility.

For the documentation, see

For earlier announcements (SAPPHIRE NOW 2017), see

For the release notes of supported operating (file) systems, see

New HDBLCM Parameters

To validate the signature:

–action=[install|update] –verify_signature

When using persistent memory:

–action=install –use_pmem
–action=install –pmempath=/hana/pmem/<SID>

To specify a temporary location for file extraction and the location of the executables:

–action=extract_components –extract_temp_dir=<extract_temp_dir>
–action=extract_components –overwrite_extract_dir
–action=extract_components –sapcar_location=<sapcar_location>
–action=extract_components –tar_executable_location=<tar_executable_location>
–action=extract_components –unrar_executable_location=<unrar_executable_location>

To enable interactive input of system database user (SYSTEM) password, or (in case of a single-tenant to multi-tenant system conversion) to use the single-container database user password for the system database user to be created:

–action=update –systemdb_system_user_password
–action=update –systemdb_use_singledb_user_password

To specify the path to the (trust) certificate and key for use by XS advanced:

–xs_cert_key=<path>
–xs_cert_pem=<path>
–xs_trust_pem=<path>

What’s Changed?

Resume Update after Delivery Unit Import Error

The SAP HANA database lifecycle management tool (hdblcm, -gui, -web) is a wrapper tool that calls utility tools to perform the action. Previously, when an upgrade failed because of a delivery unit import error, you had to manually complete the task using any of these utility tools. Now, you can just rerun hbdlcm to resume the update.

Usability Improvement

You can now verify existing configuration parameters when using the SAP HANA database lifecycle management tool web interface.

SAP HANA database lifecycle management > Configure System Landscape Directory Registration

For the documentation, see

Playlist(s)

On the SAP HANA Academy, there is a full playlist covering all aspects of installation and update

References

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

 

What’s New in SAP HANA 2.0 SPS 03 – by the SAP HANA Academy

Introduction

In the upcoming days and weeks, we will be adding new videos to the SAP HANA Academy to show new features and functionality introduced in SAP HANA 2.0 Support Package Stack (SPS) 03.

For the release announcement from SAP HANA product management with dates for the live expert session webinars, see

For the recordings, see

For previous SAP HANA Academy What’s New blogs, see

What’s New with SAP HANA 2.0 SPS 03 on YouTube

For the video tutorial playlist about SPS 03 new features, see

What’s New with SAP HANA 2.0 SPS 03 – Blogs

For each of the topic areas, additional blogs will be added to provide background, context, and links to additional documentation and other resources.

This blog roll will be updated in the next couple of weeks to list expert blogs as they come available.

Database Management

SAP HANA Academy

Community Blogs

Links to the What’s New Guide (Release Notes)

Application Development

Community Blogs

Links to the What’s New Guide (Release Notes)

Advanced Analytical Processing

SAP HANA Academy

Links to the What’s New Guide (Release Notes)

Data Integration & Quality

Links to the What’s New Guide (Release Notes)

Feature Scope

For an overview of the different editions and options, see

References

SAP HANA Product home

SAP Help Portal

SAP Notes

Product Availability Matrix (PAM)

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

C_HANATEC_13 Topics: Monitoring and Troubleshooting – by the SAP HANA Academy

Introduction

This blog is part of a series to help you pass the SAP Certified Technology Associate – SAP HANA 2.0 certification exam, C_HANATEC_13.

For an overview of the exam, see

For the sample questions, see

Topic Areas

There are 10 topic areas and you can expect about 8 questions for each topic.

In this blog, I will discuss the Monitoring and Troubleshooting topic.

This topic is an exception to the 10% / 8 question rule as I counted a whopping 13 questions marked for this topic! Your mileage may vary but you might want to take note. It is a big topic.

On the SAP Training website for C_HANATEC_13, the exam objective for this topic is stated:

Use SAP HANA cockpit or DBA Cockpit to monitor the SAP HANA database, 
configure the traces and collect diagnosis information.

On my exam there were exactly 0 questions about DBA Cockpit, but again, your exam could very well be different.

Study Material

The exam guide states that the study material for this topic comes from training

You can download the index of the guide with the units and lesson objectives from the SAP Training website.

For such an important topic you would expect a dedicated unit or lesson about monitoring and troubleshooting but this is not the case. There are two exercises for monitoring, one for HANA cockpit and one for DBA cockpit. It is covered in the units Administration Tools and in Database Administration Tasks which we discuss in another blog

The topic is also mentioned in the lesson about Memory Management and Data Persistence, for this see the blog about

For SAP HANA 2.0 SPS 02, there is a dedicated SAP Training about this topic

It might be listed for the upcoming C_HANATEC_14 on SPS 02 but it is not listed for C_HANATEC_13 (SPS00). I will discuss some of the topics of HA215 below.

There is an openSAP course on SAP HANA Administration which includes monitoring

There is also a TechEd recording available from Lucas Kiesow, product manager for SAP HANA

For the documentation, see

What’s New?

The focus will be on the new SAP HANA 2.0 features, so if you are new to this version you might be interested to view the What’s New videos first:

Note that C_HANATEC_13 covers SAP HANA 2.0 SPS 00 only. C_HANATEC_14 will cover SPS 02.

Capture and Replay

The capture and replay tool is only mentioned briefly in the HA200 training so you are not expected to be familiar with this tool in any depth.

Should you be curious and want to learn a bit more: for a good introduction on the topic, see

There is also a tutorial video about capture and replay on the Academy

SAP HANA Academy – Administration: Capture and Replay

If you want to set your own test/training environment up, this guide may be of use

For the documentation, see

Workload Management

Workload management is not mentioned at all in the HA200 training so you are not expected to be familiar with this tool.

Again, should you be curious: for a good introduction on the topic, see the whitepaper and/or the TechEd talk by the product manager Ruediger Karl

For the documentation, see

References

SAP HANA Academy Playlists

SAP Blogs

SAP Notes

SAP Help Portal (Documentation)

Whitepapers

SAP Education

openSAP

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

 

C_HANATEC_13 Topics: High Availability and Disaster Tolerance – by the SAP HANA Academy

Introduction

This blog is part of a series to help you pass the SAP Certified Technology Associate – SAP HANA 2.0 certification exam, C_HANATEC_13.

For an overview of the exam, see

For the sample questions, see

Topic Areas

There are 10 topic areas and you can expect about 8 questions for each topic.

In this blog, I will discuss the High Availability and Disaster Tolerance topic.

On the SAP Training website for C_HANATEC_13, the exam objective for this topic is stated:

Design a strategy for high availability and disaster recovery, 
explain the high availability and system replication features 
of SAP HANA.

Study Material

The exam guide states that the study material for this topic comes from training

However, I have not been able to find much material on HA/DR or system replication in this training but expect this to be added for the next release.

You can download the index of the guide with the unit and lesson objectives from the SAP Training website.

There is an openSAP course on HA/DR

For the documentation, see

What’s New?

The focus will be on the new SAP HANA 2.0 features, so if you are new to this version you might be interested to view the What’s New videos first:

Note that C_HANATEC_13 covers SAP HANA 2.0 SPS 00 only. C_HANATEC_14 will cover SPS 02.

High Availability

For a good introduction on the topic, see

This whitepaper will help you get familiar with RPO and RTO, and the different HA/DR options available for SAP HANA.

Backup and recovery is part of HA but for the exam, it is a separate topic area, see

You will also find several blogs on this topic on the SAP HANA Community, e.g.

<

For the documentation, see

System Replication

When system replication was just introduced, we did a whole series on this topic. Here is the playlist

The two most important videos are embedded below.

For the configuration, SAP HANA studio was used. For SAP HANA 2.0, you would use cockpit. The interface is less relevant, however, as the actual actions are performed by hdbnsutil.

For cockpit, see below Active/Active Read-Enabled.

SAP HANA Academy – System Replication: Concepts

SAP HANA Academy – System Replication: Setup

In case you want to setup a system replication environment for training, you might find the following blog helpful (cloud-based)

 

For the documentation, see

Active/Active (Read-Enabled)

Active/Active (read enabled) enables SAP HANA system replication to support read access on the secondary system.

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

For the documentation, see

References

SAP HANA Academy Playlists

SAP Blogs

SAP Notes

SAP Help Portal (Documentation)

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

 

C_HANATEC_13 Topics: Database Administration Tools and Tasks – by the SAP HANA Academy

Introduction

This blog is part of a series to help you pass the SAP Certified Technology Associate – SAP HANA 2.0 certification exam, C_HANATEC_13.

For an overview of the exam, see

For the sample questions, see

Topic Areas

There are 10 topic areas and you can expect about 8 questions for each topic.

In this blog, I will discuss the Database Administration Tools and Tasks topic.

On the SAP Training website for C_HANATEC_13, the (somewhat obscure) exam objective for this topic is stated:

Create SAP HANA database administration guides on the day to day 
database administration tasks like starting and stopping, 
changing the configuration settings and performing table 
administration.

Study Material

The study material for this topic comes from training

Unit 5, 8 and 9 of HA200 cover the topics SAP HANA Cockpit 2.0Administration Tools and Database Administration Tasks respectively.

SAP HANA cockpit we already covered for the Installation and Upgrade topic area.

You can download the index of the guide with the unit and lesson objectives from the SAP Training website.

These topics are also addressed in the following SAP HANA guides:

What’s New?

The focus will be on the new SAP HANA 2.0 features, so if you are new to this version you might be interested to view the What’s New videos first:

Note that C_HANATEC_13 covers SAP HANA 2.0 SPS 00 only. C_HANATEC_14 will cover SPS 02.

Administration Tools

You are expected to be (to some extent) familiar with the SAP HANA administration tools. There used to be quite a number of questions about Solution Manager but this appears to be a thing of the past. Your mileage may vary, but in HEC13 I did not count a single one.

As you might expect for a tool that’s new for SAP HANA 2.0, there were quite a number of questions about or referencing SAP HANA cockpit – a good 20% in my case – although studio also came up a couple of times.

As of SAP HANA 2.0, there has been no more development on SAP HANA studio, no more updates on the documentation, and part of the functionality (repository, XS classic development) has already been marked deprecated in the SPS 02 release. You can expect studio to quietly leave the stage of the exam in the near future.

If not mistaken, there was one question about ALM (Application Lifecycle Management), one or two about the SAP HANA interactive terminal, hdbsql, and a couple about the SAP HANA database lifecycle management tool hdblcm, and one that referenced the hardware check configuration tool, but none (0) about XS Advanced administration, Landscape Manager, Solution Manager (as mentioned) or ITOA.

For the documentation, see

HDBSQL

If you need to brush up on the hdbsql skills, you might find the following tutorial playlist of interest

There is also a blog that provides context and references

SAP HANA Academy – SAP HANA Administration: hdbsql – Getting Started

For the documentation, see

DBA Cockpit

One of the training objectives is to be able to work with the SAP (Netweaver AS ABAP) DBA cockpit. However, is it not explicitly mentioned as exam objective and I did not have any question about it (but your exam might be different). In past exams, the only questions I have seen were about scheduling backups (as this could not be done in SAP HANA studio). However, as we can now schedule backups in SAP HANA cockpit, it looks like DBA Cockpit takes the same way out as SAP HANA studio.

If you are not familiar at all with DBA cockpit, you might want to browse the documentation a bit or scan the internet for a video. Otherwise, I would not invest too much time into this subject.

For the documentation, see

SAP (Netweaver AS ABAP) DBA Cockpit

SAP Landscape Manager

For LaMa the same applies as for DBA Cockpit. It is part of the training but might not be part of the exam.

If you are new to this topic and are interested, see the blog by the product manager, Michael Hesse

For the community, see

SAP HANA Studio

Most of you will be very familiar with SAP HANA studio so you can check the boxes: perspectives, add a system, diagnosis mode. No need for any hard study here.

For those new to this tool, here is an overview from 2015.

SAP HANA Academy – SAP HANA Administration: SAP HANA Studio – Overview [2.0 SPS 00]

For the documentation, see

Start and Stop

No surprise, as an SAP HANA technician, you are expected to know how to start and stop an SAP HANA system using cockpit, HDB, and sapcontrol, start and stop tenant databases, start and stop services, but also troubleshooting an unresponsive system (unplanned maintenance).

There is a blog post about all the ins and outs of starting and stopping SAP HANA systems and tenants (on GCP but the same applies to on-premise).

Additionally, we have posted two under-the-hood blogs that cover the inner workings of the HDB system management script, and the role of sapinit and SAPStartSrv (in a lot more detail than you are expected to know for the exam).

SAP HANA Academy – Start and Stop with cockpit and studio

SAP HANA Academy – Start and Stop with HDB

SAP HANA Academy – Start and Stop with sapcontrol

For the documentation, see

Configuration

Another topic you need to master is how to configure system properties for SAP HANA.

The video below shows how this works in SAP HANA studio but the same applies to SAP HANA cockpit.

 

SAP HANA Academy – SAP HANA Administration: Configuring System Parameters

For more information, see

Database Administration Tasks

Another exam requirement is to be at ease with common database administration tasks like making a backup (for this see the Backup and Recovery section), checking system health, CPU and memory usage, alerts, sessions, statements, etc., all with focus on the SAP HANA cockpit.

SAP HANA Academy – SAP HANA cockpit

For the documentation, see

Tracing and Diagnostics

Closely related to performance monitoring is the topic of tracing and diagnostics. The objective here is that you are familiar with the several trace options and working with diagnosis information.

For the monitoring playlist on the SAP HANA Academy, see

We are will be updating this topic for the upcoming release (SPS 03).

For the documentation, see

SQL Console

For this topic, you need to know how to execute SQL in SAP HANA cockpit (using the Database Explorer), how to monitor expensive statements, and use the SQL Plan Cache.

SAP HANA Academy – Web IDE for HANA: Database Explorer

 

For the documentation, see

Table administration

For this topic, you need to know when to use a column-based and when to use row-based table storage, how to create a table, display definition and content, and how to work with table partitioning.

For the documentation, see

SAP HANA Application Lifecycle Management

This topic is about XS classic: SAP HANA content, delivery units, packages, repository, design-time/runtime objects and how to transport these between systems.

As the XS classic repository has been deprecated for release SAP HANA 2.0 SPS 02, this is probably the last exam with questions about this topic.

If you have never seen ALM for classic XS (a new UI was introduced for SPS 11), you might find the video tutorial below of interest.

ALM for XS Advanced works quite different but is not (yet) included in the exam requirements; no need to study XSA.

SAP HANA Academy – Application Lifecycle Management

For the documentation, see

References

SAP HANA Academy Playlists

SAP Blogs

SAP Notes

SAP Help Portal (Documentation)

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

 

C_HANATEC_13 Topics: SAP HANA System Architecture – by the SAP HANA Academy

Introduction

This blog is part of a series to help you pass the SAP Certified Technology Associate – SAP HANA 2.0 certification exam, C_HANATEC_13.

For an overview of the exam, see

For the sample questions, see

Topic Areas

There are 10 topic areas and you can expect about 8 questions for each topic.

In this blog, I will discuss the System Architecture topic.

On the SAP Training website for C_HANATEC_13, the exam objective for this topic is stated:

Design a system architecture for an SAP HANA implementation 
that includes hardware sizing, data persistence, 
network requirements and integrates with the existing customer landscape.

Study Material

The study material for this topic comes from training

Unit 4 of HA200 covers the SAP HANA Architecture in 2 lessons with the objectives:

  1. Explain SAP HANA architecture and technology
  2. Explain SAP HANA memory management and data persistence

Unit 2 of HA100 covers the SAP HANA Architecture in several lessons of which the ‘Understanding the key features of SAP HANA database’ lesson is the most important (it is also its objective).

You can download the index of the guide with objectives from the SAP Training website (see links above).

These topics are also addressed in the following SAP HANA guides:

SAP HANA Architecture

Components

A good understanding of the SAP HANA architecture is important for this topic area. Technically, we distinguish different components (server, client, studio, AFL, etc.). From a licensing perspective, these are bundled in editions and options.

For an overview, see

SAP HANA 2.0 Editions and Options

Note that feature scope description has changed this year (2018). For the most current state of affairs (at the time of writing), see

There are no questions about which edition contains which component but knowing the different pieces of the platform is certainly relevant.

For the feature scope description, see

For the documentation, see

Deployment Options

You also need to be familiar with the different deployment options: MDC, MCOD, MCOS, etc.

The video tutorial below explains these concepts for SAP HANA 1.0 SPS 12 but this also applies to SAP HANA 2.0.

SAP HANA Academy – Installation and Update: Server Concepts

For the documentation, see

Under the Hood

Although not in great detail, you might get a question or two about SAP HANA under the hood: its services, the startup process, savepoints (see also the Backup and Recovery topic), data persistence, and memory management.

For an earlier release, I have recorded a tutorial video about the architecture. This certainly needs an update as XS Advanced and Multitenant Database Containers are not included. However, for the role of the nameserver and indexserver process, the webdispatcher, the client interfaces, etc. not all that much has changed, so if you are new to this topic you still might find it helpful.

The backup and recovery concepts video covers savepoints.

Additionally, we have posted two under-the-hood blogs that cover the inner workings of the HDB system management script, and the role of sapinit and SAPStartSrv

 

SAP HANA Academy – SAP HANA Administration: Architecture – Overview

SAP HANA Academy – Backup and Recovery: Concepts

SAP HANA Memory Management

For the documentation, see

Table Management

Additionally, you can several questions related to table management, like column versus row-based tables, column compression and merge operations, table redistribution, data temperature, etc. For this, see

 

 

 

SAP HANA XS Advanced Model (XSA)

You can also expect a couple of questions about XSA, so it is relevant to have some understanding of the architecture and how it compares to XS classic.

There is a lot of documentation and blogs about XSA, so it is to drown in this topic. However. in my exam, there were maybe 2 or 3 questions about XS classic (repository) and only 1 or 2 about XSA, so you might want to take this into consideration about how to spend your study time.

If you just want to refresh and test your XS knowledge, try our quiz (where we cover the key concepts):

There is a full playlist about XS Advanced on the SAP HANA Academy:

You do not have to watch all 100+ videos. For this topic, the overview video suffices:

SAP HANA Academy – XS Advanced

For the documentation, see

References

SAP HANA Academy Playlists

SAP Blogs

SAP Help Portal (Documentation)

SAP Notes

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