HANA – hdbcons first aid hacks

A tool which got more and more power since HANA 2.0 was released is hdbcons. It should only be used by experienced admins and should be tested in non-prod systems, because it can produce system crashes. There are several known issues documented in notes which describe scenarios you should avoid the usage of hdbcons in prod systems.

This blog won’t describe the full functional scope (the central hdbcons note 2222218). I will show some general use cases which are not well known, but should be kept in mind for scenarios I call ‘HANA first aid’. At the end of the blog you will also get an example script for such a troubleshooting situation.

Basis Engineers’ Ultimate Guide for SAP Debugging

I think that every Basis engineer and SAP developer will agree with me when I say:

It can be REALLY painful to find the root cause of an issue in a complex SAP system.

SAP HANA Authorization Tracing

This document will deal with issues regarding analytical privileges with SAP HANA.

So what are Privileges some might ask?

System Privilege:

System privileges control general system activities. They are mainly used for administrative purposes, such as creating schemas, creating and changing users and roles, performing data backups, managing licenses, and so on.

HALM Usage and Troubleshooting

What is HALM?

HALM stands for HANA Application Lifecycle Management, this image from the documentation explains the product lifecycle using HALM: